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.JL_BR_SPED_PKG dependencies on JL_BR_CUSTOMER_TRX_EXTS

Line 28: FROM JL_BR_CUSTOMER_TRX_EXTS

24: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
25:
26: CURSOR C_CUST_EXT IS
27: SELECT COUNT(*) as CTR
28: FROM JL_BR_CUSTOMER_TRX_EXTS
29: WHERE ELECTRONIC_INV_STATUS IN ('2','7')
30: AND CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
31: AND NOT EXISTS ( SELECT 'X' FROM AR_PAYMENT_SCHEDULES
32: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID

Line 98: for inserting the Electronic Invoice attributes in the JL_BR_CUSTOMER_TRX_EXTS extension table*/

94: END Set_Trx_Lock_Status;
95:
96: /* Function Name : Copy_GDF_Attributes
97: Description : This function will be called from the core AR Autoinvoice program and the Copy Transactions program
98: for inserting the Electronic Invoice attributes in the JL_BR_CUSTOMER_TRX_EXTS extension table*/
99: FUNCTION COPY_GDF_ATTRIBUTES (P_REQUEST_ID IN NUMBER, P_CALLED_FROM IN VARCHAR2) RETURN NUMBER IS
100:
101: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;
102: TYPE LINE_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.LINE_GDF_ATTRIBUTE1%TYPE; --ER 9974789

Line 107: TYPE LEGAL_PROCESS_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_CODE%TYPE;

103:
104: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
105: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
106:
107: TYPE LEGAL_PROCESS_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_CODE%TYPE;
108: TYPE LEGAL_PROCESS_SOURCE_IND_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_SOURCE_IND%TYPE;
109: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;
110: TYPE VEHICLE_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_ANTT_INSCRIPTION%TYPE;
111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;

Line 108: TYPE LEGAL_PROCESS_SOURCE_IND_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_SOURCE_IND%TYPE;

104: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
105: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
106:
107: TYPE LEGAL_PROCESS_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_CODE%TYPE;
108: TYPE LEGAL_PROCESS_SOURCE_IND_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_SOURCE_IND%TYPE;
109: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;
110: TYPE VEHICLE_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_ANTT_INSCRIPTION%TYPE;
111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;

Line 109: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;

105: TYPE CUSTOMER_TRX_LINE_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
106:
107: TYPE LEGAL_PROCESS_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_CODE%TYPE;
108: TYPE LEGAL_PROCESS_SOURCE_IND_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_SOURCE_IND%TYPE;
109: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;
110: TYPE VEHICLE_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_ANTT_INSCRIPTION%TYPE;
111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;

Line 110: TYPE VEHICLE_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_ANTT_INSCRIPTION%TYPE;

106:
107: TYPE LEGAL_PROCESS_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_CODE%TYPE;
108: TYPE LEGAL_PROCESS_SOURCE_IND_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_SOURCE_IND%TYPE;
109: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;
110: TYPE VEHICLE_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_ANTT_INSCRIPTION%TYPE;
111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;
114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;

Line 111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;

107: TYPE LEGAL_PROCESS_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_CODE%TYPE;
108: TYPE LEGAL_PROCESS_SOURCE_IND_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_SOURCE_IND%TYPE;
109: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;
110: TYPE VEHICLE_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_ANTT_INSCRIPTION%TYPE;
111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;
114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;
115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;

Line 112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;

108: TYPE LEGAL_PROCESS_SOURCE_IND_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_SOURCE_IND%TYPE;
109: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;
110: TYPE VEHICLE_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_ANTT_INSCRIPTION%TYPE;
111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;
114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;
115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;
116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;

Line 113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;

109: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;
110: TYPE VEHICLE_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_ANTT_INSCRIPTION%TYPE;
111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;
114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;
115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;
116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;
117: TYPE ELECTRONIC_INV_PROTOCOL_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_PROTOCOL%TYPE;

Line 114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;

110: TYPE VEHICLE_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_ANTT_INSCRIPTION%TYPE;
111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;
114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;
115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;
116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;
117: TYPE ELECTRONIC_INV_PROTOCOL_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_PROTOCOL%TYPE;
118: TYPE WAGON_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.WAGON_CODE%TYPE;

Line 115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;

111: TYPE TOWING_VEH_PLATE_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_NUMBER%TYPE;
112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;
114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;
115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;
116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;
117: TYPE ELECTRONIC_INV_PROTOCOL_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_PROTOCOL%TYPE;
118: TYPE WAGON_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.WAGON_CODE%TYPE;
119: TYPE FERRY_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.FERRY_CODE%TYPE;

Line 116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;

112: TYPE TOWING_VEH_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_PLATE_STATE_CODE%TYPE;
113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;
114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;
115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;
116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;
117: TYPE ELECTRONIC_INV_PROTOCOL_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_PROTOCOL%TYPE;
118: TYPE WAGON_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.WAGON_CODE%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

Line 117: TYPE ELECTRONIC_INV_PROTOCOL_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_PROTOCOL%TYPE;

113: TYPE TOWING_VEH_ANTT_INSCRIPTION_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.TOWING_VEH_ANTT_INSCRIPTION%TYPE;
114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;
115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;
116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;
117: TYPE ELECTRONIC_INV_PROTOCOL_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_PROTOCOL%TYPE;
118: TYPE WAGON_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.WAGON_CODE%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:

Line 118: TYPE WAGON_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.WAGON_CODE%TYPE;

114: TYPE SEAL_NUMBER_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SEAL_NUMBER%TYPE;
115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;
116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;
117: TYPE ELECTRONIC_INV_PROTOCOL_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_PROTOCOL%TYPE;
118: TYPE WAGON_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.WAGON_CODE%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*/

Line 119: TYPE FERRY_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.FERRY_CODE%TYPE;

115: TYPE ELECTRONIC_INV_WEB_ADDRESS_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_WEB_ADDRESS%TYPE;
116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;
117: TYPE ELECTRONIC_INV_PROTOCOL_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_PROTOCOL%TYPE;
118: TYPE WAGON_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.WAGON_CODE%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;

Line 120: TYPE SERVICE_EXEC_DATE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.SRV_EXEC_DATE%TYPE; -- BUG 11825724

116: TYPE ELECTRONIC_INV_ACCESS_KEY_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_ACCESS_KEY%TYPE;
117: TYPE ELECTRONIC_INV_PROTOCOL_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.ELECTRONIC_INV_PROTOCOL%TYPE;
118: TYPE WAGON_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.WAGON_CODE%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:

Line 360: FROM JL_BR_CUSTOMER_TRX_EXTS OLD_TRX,

356: ,OLD_TRX.TOWING_VEH_PLATE_STATE_CODE4
357: ,OLD_TRX.TOWING_VEH_PLATE_NUMBER5
358: ,OLD_TRX.TOWING_VEH_PLATE_STATE_CODE5
359: ,OLD_TRX.SRV_EXEC_DATE --BUG 11825724 Service Execution Date
360: FROM JL_BR_CUSTOMER_TRX_EXTS OLD_TRX,
361: (SELECT TRX_NUMBER, CUSTOMER_TRX_ID,RECURRED_FROM_TRX_NUMBER,BATCH_SOURCE_ID
362: FROM RA_CUSTOMER_TRX WHERE REQUEST_ID = P_REQUEST_ID) NEW_TRX
363: WHERE OLD_TRX.CUSTOMER_TRX_ID = (SELECT CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX
364: WHERE TRX_NUMBER = NEW_TRX.RECURRED_FROM_TRX_NUMBER

Line 477: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS

473: WHEN OTHERS THEN
474: RETURN 0;
475: END;
476:
477: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS
478: (ELECTRONIC_INV_ACCESS_KEY_ID
479: ,CUSTOMER_TRX_ID
480: ,LEGAL_PROCESS_CODE
481: ,LEGAL_PROCESS_SOURCE_IND

Line 544: UPDATE JL_BR_CUSTOMER_TRX_EXTS

540: IF AUTO_CUST_TRX_ID.COUNT > 0 THEN
541:
542: FOR I IN 1..AUTO_CUST_TRX_ID.COUNT
543: LOOP
544: UPDATE JL_BR_CUSTOMER_TRX_EXTS
545: SET TOWING_VEH_PLATE_NUMBER2 = HEADER_GDF_ATTRIBUTE31(I),
546: TOWING_VEH_PLATE_STATE_CODE2 = HEADER_GDF_ATTRIBUTE32(I),
547: TOWING_VEH_PLATE_NUMBER3 = HEADER_GDF_ATTRIBUTE33(I),
548: TOWING_VEH_PLATE_STATE_CODE3 = HEADER_GDF_ATTRIBUTE34(I),

Line 730: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS

726: EXCEPTION
727: WHEN OTHERS THEN
728: RETURN 0;
729: END;
730: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS
731: (ELECTRONIC_INV_ACCESS_KEY_ID
732: ,CUSTOMER_TRX_ID
733: ,LEGAL_PROCESS_CODE
734: ,LEGAL_PROCESS_SOURCE_IND

Line 930: This function will insert the Electronic Invoice attributes IN THE JL_BR_CUSTOMER_TRX_EXTS

926:
927:
928: /*Function name : Copy_GDF_Attributes_API
929: Description : This function will be called from the core AR Invoice API
930: This function will insert the Electronic Invoice attributes IN THE JL_BR_CUSTOMER_TRX_EXTS
931: the the extension table */
932: FUNCTION COPY_GDF_ATTRIBUTES_API (P_CUSTOMER_TRX_ID IN NUMBER) RETURN NUMBER IS
933:
934: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;

Line 1126: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS

1122: WHEN OTHERS THEN
1123: RETURN 0;
1124: END;
1125:
1126: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS
1127: (ELECTRONIC_INV_ACCESS_KEY_ID
1128: ,CUSTOMER_TRX_ID
1129: ,LEGAL_PROCESS_CODE
1130: ,LEGAL_PROCESS_SOURCE_IND

Line 1194: UPDATE JL_BR_CUSTOMER_TRX_EXTS

1190: IF CUST_TRX_ID.COUNT > 0 THEN
1191:
1192: FOR I IN 1..CUST_TRX_ID.COUNT
1193: LOOP
1194: UPDATE JL_BR_CUSTOMER_TRX_EXTS
1195: SET TOWING_VEH_PLATE_NUMBER2 = TOWING_VEH_PLATE_NUMBER2(I),
1196: TOWING_VEH_PLATE_STATE_CODE2 = TOWING_VEH_PLATE_STATE_CODE2(I),
1197: TOWING_VEH_PLATE_NUMBER3 = TOWING_VEH_PLATE_NUMBER3(I),
1198: TOWING_VEH_PLATE_STATE_CODE3 = TOWING_VEH_PLATE_STATE_CODE3(I),