DBA Data[Home] [Help]

APPS.PA_PURGE_BILLING dependencies on PA_PLSQL_DATATYPES

Line 183: l_crdl_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;

179: l_NoOfRecordsDel NUMBER;
180: l_MC_NoOfRecordsIns NUMBER := NULL;
181: l_MC_NoOfRecordsDel NUMBER := NULL;
182:
183: l_crdl_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;
184: l_crdl_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;
185: l_fetch_complete BOOLEAN := FALSE;
186: l_crdl_ind NUMBER;
187:

Line 184: l_crdl_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;

180: l_MC_NoOfRecordsIns NUMBER := NULL;
181: l_MC_NoOfRecordsDel NUMBER := NULL;
182:
183: l_crdl_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;
184: l_crdl_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;
185: l_fetch_complete BOOLEAN := FALSE;
186: l_crdl_ind NUMBER;
187:
188: cursor c_crdl_records is

Line 700: l_erdl_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;

696: l_NoOfRecordsIns NUMBER;
697: l_NoOfRecordsDel NUMBER;
698: l_MC_NoOfRecordsIns NUMBER := NULL;
699: l_MC_NoOfRecordsDel NUMBER := NULL;
700: l_erdl_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;
701: l_erdl_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;
702: l_fetch_complete BOOLEAN := FALSE;
703: l_erdl_ind NUMBER;
704:

Line 701: l_erdl_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;

697: l_NoOfRecordsDel NUMBER;
698: l_MC_NoOfRecordsIns NUMBER := NULL;
699: l_MC_NoOfRecordsDel NUMBER := NULL;
700: l_erdl_rowid_tab PA_PLSQL_DATATYPES.RowIDTabTyp;
701: l_erdl_rowid_tab_empty PA_PLSQL_DATATYPES.RowIDTabTyp;
702: l_fetch_complete BOOLEAN := FALSE;
703: l_erdl_ind NUMBER;
704:
705: cursor c_erdl_records is