DBA Data[Home] [Help]

APPS.PA_TIEBACK_ADJ_COSTS dependencies on PA_PLSQL_DATATYPES

Line 226: l_RowIdTab PA_PLSQL_DATATYPES.RowidTabTyp;

222: And Lines.Reference_2 = To_Char(Cdl.Expenditure_Item_Id) || '-' || To_Char(Cdl.Line_Num);
223:
224: /* Need new index on Ap_Invoice_Lines_Interface (reference_2) */
225:
226: l_RowIdTab PA_PLSQL_DATATYPES.RowidTabTyp;
227: l_EiTab PA_PLSQL_DATATYPES.IdTabTyp;
228: l_LineNumTab PA_PLSQL_DATATYPES.IdTabTyp;
229: l_InvStatusTab PA_PLSQL_DATATYPES.Char25TabTyp;
230:

Line 227: l_EiTab PA_PLSQL_DATATYPES.IdTabTyp;

223:
224: /* Need new index on Ap_Invoice_Lines_Interface (reference_2) */
225:
226: l_RowIdTab PA_PLSQL_DATATYPES.RowidTabTyp;
227: l_EiTab PA_PLSQL_DATATYPES.IdTabTyp;
228: l_LineNumTab PA_PLSQL_DATATYPES.IdTabTyp;
229: l_InvStatusTab PA_PLSQL_DATATYPES.Char25TabTyp;
230:
231: L_ROWS BINARY_INTEGER := 200;

Line 228: l_LineNumTab PA_PLSQL_DATATYPES.IdTabTyp;

224: /* Need new index on Ap_Invoice_Lines_Interface (reference_2) */
225:
226: l_RowIdTab PA_PLSQL_DATATYPES.RowidTabTyp;
227: l_EiTab PA_PLSQL_DATATYPES.IdTabTyp;
228: l_LineNumTab PA_PLSQL_DATATYPES.IdTabTyp;
229: l_InvStatusTab PA_PLSQL_DATATYPES.Char25TabTyp;
230:
231: L_ROWS BINARY_INTEGER := 200;
232:

Line 229: l_InvStatusTab PA_PLSQL_DATATYPES.Char25TabTyp;

225:
226: l_RowIdTab PA_PLSQL_DATATYPES.RowidTabTyp;
227: l_EiTab PA_PLSQL_DATATYPES.IdTabTyp;
228: l_LineNumTab PA_PLSQL_DATATYPES.IdTabTyp;
229: l_InvStatusTab PA_PLSQL_DATATYPES.Char25TabTyp;
230:
231: L_ROWS BINARY_INTEGER := 200;
232:
233: BEGIN