eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_UPG_PSA_DIST_PKG dependencies on DBMS_SQL

Line 1211: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

1207: l_batch_size IN VARCHAR2,
1208: l_batch_id IN NUMBER,
1209: l_action_flag IN VARCHAR2)
1210: IS
1211: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1212: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1213: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1214: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1212: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1208: l_batch_id IN NUMBER,
1209: l_action_flag IN VARCHAR2)
1210: IS
1211: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1212: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1213: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1214: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;

Line 1213: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;

1209: l_action_flag IN VARCHAR2)
1210: IS
1211: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1212: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1213: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1214: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1214: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

1210: IS
1211: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1212: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1213: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1214: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;

Line 1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;

1211: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1212: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1213: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1214: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

Line 1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;

1212: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1213: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1214: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1213: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1214: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;

1214: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

1215: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1216: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

1217: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;

Line 1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

1218: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1219: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1220: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;

Line 1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;

1221: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;

Line 1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;

1222: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

1223: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;

1224: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;

Line 1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;

1225: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;

1226: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;

1227: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;

Line 1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;

1228: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;

Line 1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

1229: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

Line 1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

1230: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;

1231: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;

1232: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

1233: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1234: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1235: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;

Line 1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;

1236: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

1237: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

1238: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;

Line 1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;

1239: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1240: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

Line 1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;

1241: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;

Line 1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;

1242: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1250: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

Line 1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

1243: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1250: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_accounting_date DBMS_SQL.DATE_TABLE;

Line 1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

1244: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1250: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_accounting_date DBMS_SQL.DATE_TABLE;
1252: ln_ledger_id DBMS_SQL.NUMBER_TABLE;

Line 1249: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;

1245: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1250: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_accounting_date DBMS_SQL.DATE_TABLE;
1252: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1253:

Line 1250: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

1246: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1250: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_accounting_date DBMS_SQL.DATE_TABLE;
1252: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1253:
1254: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;

Line 1251: ln_accounting_date DBMS_SQL.DATE_TABLE;

1247: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1250: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_accounting_date DBMS_SQL.DATE_TABLE;
1252: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1253:
1254: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1255: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;

Line 1252: ln_ledger_id DBMS_SQL.NUMBER_TABLE;

1248: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1250: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_accounting_date DBMS_SQL.DATE_TABLE;
1252: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1253:
1254: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1255: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1256: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1254: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;

1250: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_accounting_date DBMS_SQL.DATE_TABLE;
1252: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1253:
1254: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1255: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1256: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1257: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;

Line 1255: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;

1251: ln_accounting_date DBMS_SQL.DATE_TABLE;
1252: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1253:
1254: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1255: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1256: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1257: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1256: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1252: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1253:
1254: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1255: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1256: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1257: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1257: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;

1253:
1254: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1255: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1256: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1257: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;

Line 1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;

1254: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1255: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1256: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1257: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;

Line 1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

1255: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1256: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1257: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;

Line 1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

1256: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1257: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;

Line 1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;

1257: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

Line 1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;

1258: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;

Line 1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;

1259: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;

1260: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

1261: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;

Line 1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;

1262: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;

Line 1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;

1263: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;

Line 1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;

1264: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;

Line 1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;

1265: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;

Line 1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;

1266: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1274: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;

Line 1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;

1267: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1274: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1275: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;

Line 1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;

1268: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1274: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1275: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1276: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;

Line 1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;

1269: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1274: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1275: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1276: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1277: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;

Line 1274: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;

1270: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1274: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1275: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1276: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1277: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;
1278:

Line 1275: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;

1271: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1274: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1275: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1276: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1277: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;
1278:
1279: CURSOR c(l_start_rowid ROWID, l_end_rowid ROWID) IS

Line 1276: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;

1272: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1274: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1275: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1276: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1277: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;
1278:
1279: CURSOR c(l_start_rowid ROWID, l_end_rowid ROWID) IS
1280: SELECT /*+ leading(pd,ctlgd,gud) rowid(pd) use_nl(ctlgd,ct,ent,ev,hdr,ln,lnk) use_hash(gud) swap_join_inputs(gud)

Line 1277: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;

1273: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1274: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1275: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1276: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1277: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;
1278:
1279: CURSOR c(l_start_rowid ROWID, l_end_rowid ROWID) IS
1280: SELECT /*+ leading(pd,ctlgd,gud) rowid(pd) use_nl(ctlgd,ct,ent,ev,hdr,ln,lnk) use_hash(gud) swap_join_inputs(gud)
1281: INDEX(ent xla_transaction_entities_N1)

Line 1514: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

1510:
1511:
1512: --xla_ae_lines
1513:
1514: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1515: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1516: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1517: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1515: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1511:
1512: --xla_ae_lines
1513:
1514: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1515: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1516: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1517: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;

Line 1516: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;

1512: --xla_ae_lines
1513:
1514: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1515: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1516: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1517: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1517: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

1513:
1514: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1515: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1516: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1517: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;

Line 1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;

1514: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1515: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1516: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1517: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

Line 1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;

1515: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1516: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1517: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1516: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1517: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;

1517: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

1518: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1519: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;

1520: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;

Line 1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;

1521: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1522: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1523: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;

Line 1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;

1524: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;

Line 1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;

1525: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

1526: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;

1527: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;

Line 1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;

1528: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;

1529: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;

1530: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;

Line 1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;

1531: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;

Line 1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

1532: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

Line 1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

1533: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;

1534: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;

1535: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

1536: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1537: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1545: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1538: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1545: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1546: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;

1539: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1545: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1546: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1547: laccounting_date DBMS_SQL.DATE_TABLE;

Line 1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

1540: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1545: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1546: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1547: laccounting_date DBMS_SQL.DATE_TABLE;
1548: lledger_id DBMS_SQL.NUMBER_TABLE;

Line 1545: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

1541: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1545: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1546: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1547: laccounting_date DBMS_SQL.DATE_TABLE;
1548: lledger_id DBMS_SQL.NUMBER_TABLE;
1549:

Line 1546: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1542: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1545: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1546: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1547: laccounting_date DBMS_SQL.DATE_TABLE;
1548: lledger_id DBMS_SQL.NUMBER_TABLE;
1549:
1550:

Line 1547: laccounting_date DBMS_SQL.DATE_TABLE;

1543: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1545: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1546: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1547: laccounting_date DBMS_SQL.DATE_TABLE;
1548: lledger_id DBMS_SQL.NUMBER_TABLE;
1549:
1550:
1551: --xla_distribution_links

Line 1548: lledger_id DBMS_SQL.NUMBER_TABLE;

1544: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1545: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1546: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1547: laccounting_date DBMS_SQL.DATE_TABLE;
1548: lledger_id DBMS_SQL.NUMBER_TABLE;
1549:
1550:
1551: --xla_distribution_links
1552:

Line 1553: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;

1549:
1550:
1551: --xla_distribution_links
1552:
1553: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1554: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1555: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1556: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 1554: DEVENT_ID DBMS_SQL.NUMBER_TABLE;

1550:
1551: --xla_distribution_links
1552:
1553: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1554: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1555: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1556: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;

Line 1555: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

1551: --xla_distribution_links
1552:
1553: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1554: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1555: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1556: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;

Line 1556: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1552:
1553: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1554: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1555: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1556: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

Line 1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;

1553: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1554: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1555: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1556: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;

Line 1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;

1554: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1555: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1556: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;

1555: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1556: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

1556: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1557: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;

Line 1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;

1558: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;

Line 1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1559: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;

1560: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1561: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

Line 1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;

1562: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1570: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1563: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1570: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1571: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1564: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1570: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1571: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1572: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

1565: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1570: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1571: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1572: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1573: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1570: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

1566: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1570: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1571: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1572: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1573: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1574:

Line 1571: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

1567: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1570: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1571: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1572: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1573: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1574:
1575: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;

Line 1572: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1568: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1570: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1571: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1572: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1573: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1574:
1575: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1576: empty_number_list DBMS_SQL.NUMBER_TABLE;

Line 1573: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1569: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1570: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1571: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1572: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1573: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1574:
1575: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1576: empty_number_list DBMS_SQL.NUMBER_TABLE;
1577: empty_date_list DBMS_SQL.DATE_TABLE;

Line 1575: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;

1571: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1572: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1573: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1574:
1575: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1576: empty_number_list DBMS_SQL.NUMBER_TABLE;
1577: empty_date_list DBMS_SQL.DATE_TABLE;
1578:
1579:

Line 1576: empty_number_list DBMS_SQL.NUMBER_TABLE;

1572: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1573: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1574:
1575: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1576: empty_number_list DBMS_SQL.NUMBER_TABLE;
1577: empty_date_list DBMS_SQL.DATE_TABLE;
1578:
1579:
1580: l_sys_date DATE := SYSDATE;

Line 1577: empty_date_list DBMS_SQL.DATE_TABLE;

1573: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1574:
1575: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1576: empty_number_list DBMS_SQL.NUMBER_TABLE;
1577: empty_date_list DBMS_SQL.DATE_TABLE;
1578:
1579:
1580: l_sys_date DATE := SYSDATE;
1581: