APPS.JL_BR_SPED_PKG dependencies on JL_BR_CUST_TRX_LINES_EXTS

Line 123: TYPE INDUSTRY_ATTRIBUTE_T IS TABLE OF JL_BR_CUST_TRX_LINES_EXTS.INDUSTRY_ATTRIBUTE1%TYPE;

119: TYPE FERRY_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.FERRY_CODE%TYPE;
120: TYPE SERVICE_EXEC_DATE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SRV_EXEC_DATE%TYPE; -- BUG 11825724
121:
122: /*Added for ER 9974789*/
123: TYPE INDUSTRY_ATTRIBUTE_T IS TABLE OF JL_BR_CUST_TRX_LINES_EXTS.INDUSTRY_ATTRIBUTE1%TYPE;
124:
125: AUTO_CUSTOMER_TRX_ID CUSTOMER_TRX_ID_TYPE;
126: AUTO_CUST_TRX_ID CUSTOMER_TRX_ID_TYPE;
127: AUTO_CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID_TYPE;

Line 401: FROM JL_BR_CUST_TRX_LINES_EXTS OLD,

397: OLD.INDUSTRY_ATTRIBUTE27,
398: OLD.INDUSTRY_ATTRIBUTE28,
399: OLD.INDUSTRY_ATTRIBUTE29,
400: OLD.INDUSTRY_ATTRIBUTE30
401: FROM JL_BR_CUST_TRX_LINES_EXTS OLD,
402: RA_CUSTOMER_TRX TRX,
403: RA_CUSTOMER_TRX_LINES TRXL,
404: (SELECT RATRX.TRX_NUMBER, RATRX.CUSTOMER_TRX_ID, RATRX.RECURRED_FROM_TRX_NUMBER, RATRX.BATCH_SOURCE_ID,
405: RATXL.CUSTOMER_TRX_LINE_ID, RATXL.LINE_NUMBER, RATXL.LINE_TYPE

Line 603: INSERT INTO JL_BR_CUST_TRX_LINES_EXTS

599:
600: FOR I IN 1..AUTO_CUSTOMER_TRX_LINE_ID.COUNT
601: LOOP
602:
603: INSERT INTO JL_BR_CUST_TRX_LINES_EXTS
604: (CUSTOMER_TRX_ID
605: ,CUSTOMER_TRX_LINE_ID
606: ,INDUSTRY_ATTRIBUTE1
607: ,INDUSTRY_ATTRIBUTE2

Line 840: INSERT INTO JL_BR_CUST_TRX_LINES_EXTS

836:
837: FOR I IN 1..COPY_CUSTOMER_TRX_LINE_ID.COUNT
838: LOOP
839:
840: INSERT INTO JL_BR_CUST_TRX_LINES_EXTS
841: (CUSTOMER_TRX_ID
842: ,CUSTOMER_TRX_LINE_ID
843: ,INDUSTRY_ATTRIBUTE1
844: ,INDUSTRY_ATTRIBUTE2

Line 937: TYPE INDUSTRY_ATTRIBUTE_TYPE IS TABLE OF JL_BR_CUST_TRX_LINES_EXTS.INDUSTRY_ATTRIBUTE1%TYPE;

933:
934: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;
935: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
936: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
937: TYPE INDUSTRY_ATTRIBUTE_TYPE IS TABLE OF JL_BR_CUST_TRX_LINES_EXTS.INDUSTRY_ATTRIBUTE1%TYPE;
938: TYPE SERVICE_EXEC_DATE_TYPE IS TABLE OF JL_BR_INV_API_TRX_LINES_T.SRV_EXEC_DATE%TYPE; --BUG 11825724
939:
940: CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID_TYPE;
941: CUSTOMER_TRX_ID CUSTOMER_TRX_ID_TYPE;

Line 1251: INSERT INTO JL_BR_CUST_TRX_LINES_EXTS

1247:
1248: FOR I IN 1..CUSTOMER_TRX_LINE_ID.COUNT
1249: LOOP
1250:
1251: INSERT INTO JL_BR_CUST_TRX_LINES_EXTS
1252: (CUSTOMER_TRX_ID
1253: ,CUSTOMER_TRX_LINE_ID
1254: ,INDUSTRY_ATTRIBUTE1
1255: ,INDUSTRY_ATTRIBUTE2