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 1245: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

1241: l_batch_size IN VARCHAR2,
1242: l_batch_id IN NUMBER,
1243: l_action_flag IN VARCHAR2)
1244: IS
1245: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1246: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1247: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1248: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1246: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1242: l_batch_id IN NUMBER,
1243: l_action_flag IN VARCHAR2)
1244: IS
1245: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1246: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1247: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1248: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;

Line 1247: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;

1243: l_action_flag IN VARCHAR2)
1244: IS
1245: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1246: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1247: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1248: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1248: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

1244: IS
1245: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1246: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1247: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1248: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;

Line 1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;

1245: ln_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1246: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1247: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1248: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

Line 1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;

1246: ln_AE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1247: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1248: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1247: ln_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1248: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;

1248: ln_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

1249: ln_GL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1250: ln_GL_SL_LINK_ID DBMS_SQL.NUMBER_TABLE;
1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

1251: ln_ACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;

Line 1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

1252: ln_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1253: ln_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1254: ln_PARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;

Line 1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;

1255: ln_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;

Line 1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;

1256: ln_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

1257: ln_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;

1258: ln_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;

Line 1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;

1259: ln_DESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;

1260: ln_STATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;

1261: ln_CURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;

Line 1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;

1262: ln_CURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;

Line 1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

1263: ln_CURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

Line 1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

1264: ln_CURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;

1265: ln_USSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;

1266: ln_JGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

1267: ln_CONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1268: ln_ANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1269: ln_GL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;

Line 1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;

1270: ln_DISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

1271: ln_UPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

1272: ln_UNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;

Line 1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;

1273: ln_UNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1274: ln_GAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

Line 1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;

1275: ln_UNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1283: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;

Line 1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;

1276: ln_UNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1283: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1284: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

Line 1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

1277: ln_SUBSTITUTED_CCID DBMS_SQL.NUMBER_TABLE;
1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1283: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1284: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1285: ln_accounting_date DBMS_SQL.DATE_TABLE;

Line 1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

1278: ln_BUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1283: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1284: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1285: ln_accounting_date DBMS_SQL.DATE_TABLE;
1286: ln_ledger_id DBMS_SQL.NUMBER_TABLE;

Line 1283: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;

1279: ln_MPA_ACCRUAL_ENTRY_FLAG DBMS_SQL.VARCHAR2_TABLE;
1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1283: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1284: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1285: ln_accounting_date DBMS_SQL.DATE_TABLE;
1286: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1287:

Line 1284: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

1280: ln_ENCUMBRANCE_TYPE_ID DBMS_SQL.NUMBER_TABLE;
1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1283: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1284: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1285: ln_accounting_date DBMS_SQL.DATE_TABLE;
1286: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1287:
1288: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;

Line 1285: ln_accounting_date DBMS_SQL.DATE_TABLE;

1281: ln_FUNDS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1283: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1284: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1285: ln_accounting_date DBMS_SQL.DATE_TABLE;
1286: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1287:
1288: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1289: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;

Line 1286: ln_ledger_id DBMS_SQL.NUMBER_TABLE;

1282: ln_MERGE_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1283: ln_MERGE_PARTY_ID DBMS_SQL.NUMBER_TABLE;
1284: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1285: ln_accounting_date DBMS_SQL.DATE_TABLE;
1286: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1287:
1288: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1289: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1290: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1288: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;

1284: ln_MERGE_PARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1285: ln_accounting_date DBMS_SQL.DATE_TABLE;
1286: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1287:
1288: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1289: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1290: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1291: ev_EVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;

Line 1289: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;

1285: ln_accounting_date DBMS_SQL.DATE_TABLE;
1286: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1287:
1288: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1289: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1290: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1291: ev_EVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;

Line 1290: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1286: ln_ledger_id DBMS_SQL.NUMBER_TABLE;
1287:
1288: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1289: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1290: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1291: ev_EVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1291: ev_EVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1287:
1288: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1289: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1290: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1291: ev_EVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;

1288: ev_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1289: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1290: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1291: ev_EVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;

Line 1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;

1289: ev_APPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1290: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1291: ev_EVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;

Line 1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

1290: ev_EVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1291: ev_EVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;

Line 1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;

1291: ev_EVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;

Line 1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;

1292: ev_EVENT_DATE DBMS_SQL.DATE_TABLE;
1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

Line 1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;

1293: ev_ENTITY_ID DBMS_SQL.NUMBER_TABLE;
1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;

Line 1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;

1294: ev_EVENT_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;

1295: ev_PROCESS_STATUS_CODE DBMS_SQL.VARCHAR2_TABLE;
1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

1296: ev_REFERENCE_NUM_1 DBMS_SQL.NUMBER_TABLE;
1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;

Line 1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;

1297: ev_EVENT_NUMBER DBMS_SQL.NUMBER_TABLE;
1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;

Line 1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;

1298: ctlgd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;

Line 1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;

1299: ctlgd_CUSTOMER_TRX_LINE_ID DBMS_SQL.NUMBER_TABLE;
1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;

Line 1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;

1300: ctlgd_CODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;

Line 1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;

1301: ctlgd_SET_OF_BOOKS_ID DBMS_SQL.NUMBER_TABLE;
1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1309: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;

Line 1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;

1302: ctlgd_AMOUNT DBMS_SQL.NUMBER_TABLE;
1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1309: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1310: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;

Line 1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;

1303: ctlgd_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1309: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1310: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1311: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;

Line 1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;

1304: ctlgd_GL_DATE DBMS_SQL.DATE_TABLE;
1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1309: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1310: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1311: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1312: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;

Line 1309: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;

1305: ctlgd_GL_POSTED_DATE DBMS_SQL.DATE_TABLE;
1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1309: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1310: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1311: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1312: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;
1313:

Line 1310: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;

1306: ctlgd_ACCOUNT_CLASS DBMS_SQL.VARCHAR2_TABLE;
1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1309: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1310: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1311: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1312: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;
1313:
1314: CURSOR c(l_start_rowid ROWID, l_end_rowid ROWID) IS

Line 1311: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;

1307: ctlgd_posting_control_id DBMS_SQL.NUMBER_TABLE;
1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1309: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1310: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1311: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1312: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;
1313:
1314: CURSOR c(l_start_rowid ROWID, l_end_rowid ROWID) IS
1315: SELECT /*+ leading(pd,ctlgd,gud) rowid(pd) use_nl(ctlgd,ct,ent,ev,hdr,ln,lnk) use_hash(gud) swap_join_inputs(gud)

Line 1312: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;

1308: pd_CUST_TRX_LINE_GL_DIST_ID DBMS_SQL.NUMBER_TABLE;
1309: pd_MF_RECEIVABLES_CCID DBMS_SQL.NUMBER_TABLE;
1310: pd_POSTING_CONTROL_ID DBMS_SQL.NUMBER_TABLE;
1311: cnt_by_hdr DBMS_SQL.NUMBER_TABLE;
1312: pdf_cust_trx_line_gl_dist_id DBMS_SQL.NUMBER_TABLE;
1313:
1314: CURSOR c(l_start_rowid ROWID, l_end_rowid ROWID) IS
1315: SELECT /*+ leading(pd,ctlgd,gud) rowid(pd) use_nl(ctlgd,ct,ent,ev,hdr,ln,lnk) use_hash(gud) swap_join_inputs(gud)
1316: INDEX(ent xla_transaction_entities_N1)

Line 1593: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

1589:
1590:
1591: --xla_ae_lines
1592:
1593: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1594: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1595: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1596: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1594: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1590:
1591: --xla_ae_lines
1592:
1593: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1594: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1595: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1596: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;

Line 1595: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;

1591: --xla_ae_lines
1592:
1593: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1594: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1595: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1596: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1596: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;

1592:
1593: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1594: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1595: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1596: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;

Line 1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;

1593: LAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1594: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1595: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1596: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

Line 1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;

1594: LAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1595: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1596: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1595: LAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1596: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;

1596: LCODE_COMBINATION_ID DBMS_SQL.NUMBER_TABLE;
1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;

1597: LGL_TRANSFER_MODE_CODE DBMS_SQL.VARCHAR2_TABLE;
1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1598: LGL_SL_LINK_ID DBMS_SQL.VARCHAR2_TABLE;
1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;

1599: LACCOUNTING_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;

Line 1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;

1600: LPARTY_ID DBMS_SQL.NUMBER_TABLE;
1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1601: LPARTY_SITE_ID DBMS_SQL.NUMBER_TABLE;
1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1602: LPARTY_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;

Line 1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;

1603: LENTERED_DR DBMS_SQL.NUMBER_TABLE;
1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;

Line 1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;

1604: LENTERED_CR DBMS_SQL.NUMBER_TABLE;
1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;

1605: LACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;

1606: LACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;

Line 1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;

1607: LDESCRIPTION DBMS_SQL.VARCHAR2_TABLE;
1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;

1608: LSTATISTICAL_AMOUNT DBMS_SQL.NUMBER_TABLE;
1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;

1609: LCURRENCY_CODE DBMS_SQL.VARCHAR2_TABLE;
1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;

Line 1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;

1610: LCURRENCY_CONVERSION_DATE DBMS_SQL.DATE_TABLE;
1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;

Line 1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

1611: LCURRENCY_CONVERSION_RATE DBMS_SQL.NUMBER_TABLE;
1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

Line 1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;

1612: LCURRENCY_CONVERSION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;

1613: LUSSGL_TRANSACTION_CODE DBMS_SQL.VARCHAR2_TABLE;
1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;

1614: LJGZZ_RECON_REF DBMS_SQL.VARCHAR2_TABLE;
1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

1615: LCONTROL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1616: LANALYTICAL_BALANCE_FLAG DBMS_SQL.VARCHAR2_TABLE;
1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1624: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1617: LGL_SL_LINK_TABLE DBMS_SQL.VARCHAR2_TABLE;
1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1624: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1625: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;

1618: LDISPLAYED_LINE_NUMBER DBMS_SQL.NUMBER_TABLE;
1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1624: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1625: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1626: laccounting_date DBMS_SQL.DATE_TABLE;

Line 1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

1619: LUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1624: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1625: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1626: laccounting_date DBMS_SQL.DATE_TABLE;
1627: lledger_id DBMS_SQL.NUMBER_TABLE;

Line 1624: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

1620: LUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1624: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1625: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1626: laccounting_date DBMS_SQL.DATE_TABLE;
1627: lledger_id DBMS_SQL.NUMBER_TABLE;
1628:

Line 1625: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1621: LUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1624: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1625: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1626: laccounting_date DBMS_SQL.DATE_TABLE;
1627: lledger_id DBMS_SQL.NUMBER_TABLE;
1628:
1629:

Line 1626: laccounting_date DBMS_SQL.DATE_TABLE;

1622: LGAIN_OR_LOSS_FLAG DBMS_SQL.VARCHAR2_TABLE;
1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1624: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1625: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1626: laccounting_date DBMS_SQL.DATE_TABLE;
1627: lledger_id DBMS_SQL.NUMBER_TABLE;
1628:
1629:
1630: --xla_distribution_links

Line 1627: lledger_id DBMS_SQL.NUMBER_TABLE;

1623: LUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1624: LUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1625: LBUSINESS_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1626: laccounting_date DBMS_SQL.DATE_TABLE;
1627: lledger_id DBMS_SQL.NUMBER_TABLE;
1628:
1629:
1630: --xla_distribution_links
1631:

Line 1632: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;

1628:
1629:
1630: --xla_distribution_links
1631:
1632: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1633: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1634: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1635: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 1633: DEVENT_ID DBMS_SQL.NUMBER_TABLE;

1629:
1630: --xla_distribution_links
1631:
1632: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1633: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1634: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1635: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;

Line 1634: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

1630: --xla_distribution_links
1631:
1632: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1633: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1634: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1635: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;

Line 1635: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1631:
1632: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1633: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1634: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1635: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

Line 1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;

1632: DAPPLICATION_ID DBMS_SQL.NUMBER_TABLE;
1633: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1634: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1635: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;

Line 1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;

1633: DEVENT_ID DBMS_SQL.NUMBER_TABLE;
1634: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1635: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;

1634: DAE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1635: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;

1635: DAE_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1636: DSOURCE_DISTRIBUTION_TYPE DBMS_SQL.VARCHAR2_TABLE;
1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;

Line 1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;

1637: DSOURCE_DISTRIBUTION_ID_NUM_1 DBMS_SQL.NUMBER_TABLE;
1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;

Line 1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1638: DTAX_LINE_REF_ID DBMS_SQL.NUMBER_TABLE;
1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;

1639: DREF_AE_HEADER_ID DBMS_SQL.NUMBER_TABLE;
1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

Line 1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;

1640: DREF_TEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

Line 1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;

1641: DACCOUNTING_LINE_CODE DBMS_SQL.VARCHAR2_TABLE;
1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1649: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

Line 1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;

1642: DACCOUNTING_LINE_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1649: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1650: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

Line 1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;

1643: DMERGE_DUPLICATE_CODE DBMS_SQL.VARCHAR2_TABLE;
1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1649: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1650: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1651: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

Line 1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;

1644: DTEMP_LINE_NUM DBMS_SQL.NUMBER_TABLE;
1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1649: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1650: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1651: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1652: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

Line 1649: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;

1645: DREF_EVENT_ID DBMS_SQL.NUMBER_TABLE;
1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1649: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1650: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1651: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1652: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1653:

Line 1650: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;

1646: DEVENT_CLASS_CODE DBMS_SQL.VARCHAR2_TABLE;
1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1649: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1650: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1651: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1652: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1653:
1654: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;

Line 1651: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;

1647: DEVENT_TYPE_CODE DBMS_SQL.VARCHAR2_TABLE;
1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1649: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1650: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1651: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1652: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1653:
1654: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1655: empty_number_list DBMS_SQL.NUMBER_TABLE;

Line 1652: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;

1648: DUPG_BATCH_ID DBMS_SQL.NUMBER_TABLE;
1649: DUNROUNDED_ENTERED_DR DBMS_SQL.NUMBER_TABLE;
1650: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1651: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1652: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1653:
1654: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1655: empty_number_list DBMS_SQL.NUMBER_TABLE;
1656: empty_date_list DBMS_SQL.DATE_TABLE;

Line 1654: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;

1650: DUNROUNDED_ENTERED_CR DBMS_SQL.NUMBER_TABLE;
1651: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1652: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1653:
1654: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1655: empty_number_list DBMS_SQL.NUMBER_TABLE;
1656: empty_date_list DBMS_SQL.DATE_TABLE;
1657:
1658:

Line 1655: empty_number_list DBMS_SQL.NUMBER_TABLE;

1651: DUNROUNDED_ACCOUNTED_CR DBMS_SQL.NUMBER_TABLE;
1652: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1653:
1654: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1655: empty_number_list DBMS_SQL.NUMBER_TABLE;
1656: empty_date_list DBMS_SQL.DATE_TABLE;
1657:
1658:
1659: l_sys_date DATE := SYSDATE;

Line 1656: empty_date_list DBMS_SQL.DATE_TABLE;

1652: DUNROUNDED_ACCOUNTED_DR DBMS_SQL.NUMBER_TABLE;
1653:
1654: empty_varchar2_list DBMS_SQL.VARCHAR2_TABLE;
1655: empty_number_list DBMS_SQL.NUMBER_TABLE;
1656: empty_date_list DBMS_SQL.DATE_TABLE;
1657:
1658:
1659: l_sys_date DATE := SYSDATE;
1660: