APPS.JL_BR_SPED_PKG dependencies on RA_CUSTOMER_TRX

Line 23: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

19: -- Declaration part
20:
21: CURSOR C_BATCH_SOURCE IS
22: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') GLOBAL_ATTRIBUTE5
23: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
24: WHERE T.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
25: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
26:
27: CURSOR C_CUST_EXT IS

Line 78: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T

74: PROCEDURE Set_Trx_Lock_Status(p_customer_trx_id IN NUMBER) IS
75:
76: CURSOR C_BATCH_SOURCE IS
77: SELECT NVL(B.GLOBAL_ATTRIBUTE5, 'N') GLOBAL_ATTRIBUTE5
78: FROM RA_BATCH_SOURCES B, RA_CUSTOMER_TRX T
79: WHERE T.CUSTOMER_TRX_ID = p_customer_trx_id
80: AND B.BATCH_SOURCE_ID = T.BATCH_SOURCE_ID;
81: l_country_code varchar2(30);
82: BEGIN

Line 104: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;

100: FUNCTION COPY_GDF_ATTRIBUTES (P_REQUEST_ID IN NUMBER, P_CALLED_FROM IN VARCHAR2) RETURN NUMBER IS
101:
102: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;
103:
104: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
105:
106: TYPE LEGAL_PROCESS_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_CODE%TYPE;
107: TYPE LEGAL_PROCESS_SOURCE_IND_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.LEGAL_PROCESS_SOURCE_IND%TYPE;
108: TYPE VEHICLE_PLATE_STATE_CODE_T IS TABLE OF JL_BR_CUSTOMER_TRX_EXTS.VEHICLE_PLATE_STATE_CODE%TYPE;

Line 159: RA_CUSTOMER_TRX TRX

155: GT.HEADER_GDF_ATTRIBUTE27,
156: GT.HEADER_GDF_ATTRIBUTE29,
157: GT.HEADER_GDF_ATTRIBUTE30
158: FROM RA_INTERFACE_LINES_GT GT,
159: RA_CUSTOMER_TRX TRX
160: WHERE TRX.REQUEST_ID = P_REQUEST_ID
161: AND GT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
162: AND GT.INTERFACE_LINE_ID = (SELECT MIN(GT.INTERFACE_LINE_ID)
163: FROM RA_INTERFACE_LINES_GT GT_2

Line 182: FROM RA_CUSTOMER_TRX

178: ,OLD_TRX.ELECTRONIC_INV_ACCESS_KEY
179: ,OLD_TRX.ELECTRONIC_INV_PROTOCOL
180: FROM JL_BR_CUSTOMER_TRX_EXTS OLD_TRX,
181: (SELECT TRX_NUMBER, CUSTOMER_TRX_ID,RECURRED_FROM_TRX_NUMBER,BATCH_SOURCE_ID
182: FROM RA_CUSTOMER_TRX
183: WHERE REQUEST_ID = P_REQUEST_ID) NEW_TRX
184: WHERE OLD_TRX.CUSTOMER_TRX_ID = (SELECT CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX
185: WHERE TRX_NUMBER = NEW_TRX.RECURRED_FROM_TRX_NUMBER
186: AND BATCH_SOURCE_ID = NEW_TRX.BATCH_SOURCE_ID);

Line 184: WHERE OLD_TRX.CUSTOMER_TRX_ID = (SELECT CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX

180: FROM JL_BR_CUSTOMER_TRX_EXTS OLD_TRX,
181: (SELECT TRX_NUMBER, CUSTOMER_TRX_ID,RECURRED_FROM_TRX_NUMBER,BATCH_SOURCE_ID
182: FROM RA_CUSTOMER_TRX
183: WHERE REQUEST_ID = P_REQUEST_ID) NEW_TRX
184: WHERE OLD_TRX.CUSTOMER_TRX_ID = (SELECT CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX
185: WHERE TRX_NUMBER = NEW_TRX.RECURRED_FROM_TRX_NUMBER
186: AND BATCH_SOURCE_ID = NEW_TRX.BATCH_SOURCE_ID);
187:
188: L_COUNTRY_CODE VARCHAR2(30);

Line 334: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;

330: the the extension table */
331: FUNCTION COPY_GDF_ATTRIBUTES_API (P_CUSTOMER_TRX_ID IN NUMBER) RETURN NUMBER IS
332:
333: TYPE HEADER_GDF_ATTR_TYPE IS TABLE OF RA_INTERFACE_LINES_ALL.HEADER_GDF_ATTRIBUTE1%TYPE;
334: TYPE CUSTOMER_TRX_ID_TYPE IS TABLE OF RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE;
335: CUSTOMER_TRX_ID CUSTOMER_TRX_ID_TYPE;
336: HEADER_GDF_ATTRIBUTE19 HEADER_GDF_ATTR_TYPE;
337: HEADER_GDF_ATTRIBUTE20 HEADER_GDF_ATTR_TYPE;
338: HEADER_GDF_ATTRIBUTE21 HEADER_GDF_ATTR_TYPE;