APPS.JL_BR_SPED_PUB dependencies on JL_BR_CUSTOMER_TRX_EXTS

Line 52: SELECT COUNT(*) as cnt FROM JL_BR_CUSTOMER_TRX_EXTS

48:
49: -- Declaration part
50:
51: CURSOR C_EXT IS
52: SELECT COUNT(*) as cnt FROM JL_BR_CUSTOMER_TRX_EXTS
53: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
54:
55: CURSOR C_TRX IS
56: SELECT 'Yes' as isExist

Line 57: FROM JL_BR_CUSTOMER_TRX_EXTS

53: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
54:
55: CURSOR C_TRX IS
56: SELECT 'Yes' as isExist
57: FROM JL_BR_CUSTOMER_TRX_EXTS
58: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
59: AND ELECTRONIC_INV_STATUS IN ('2','7');
60:
61: CURSOR C_CUST_TRX_EXIST IS

Line 127: -- Create an entry in JL_BR_CUSTOMER_TRX_EXTS table

123: l_count := ext_rec.cnt;
124: END LOOP;
125:
126: IF l_count = 0 THEN
127: -- Create an entry in JL_BR_CUSTOMER_TRX_EXTS table
128: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS(
129: CUSTOMER_TRX_ID,
130: ELECTRONIC_INV_WEB_ADDRESS,
131: ELECTRONIC_INV_STATUS,

Line 128: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS(

124: END LOOP;
125:
126: IF l_count = 0 THEN
127: -- Create an entry in JL_BR_CUSTOMER_TRX_EXTS table
128: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS(
129: CUSTOMER_TRX_ID,
130: ELECTRONIC_INV_WEB_ADDRESS,
131: ELECTRONIC_INV_STATUS,
132: ELECTRONIC_INV_ACCESS_KEY,

Line 160: UPDATE JL_BR_CUSTOMER_TRX_EXTS

156: END LOOP;
157: End If;
158: -- Bug 8780811
159:
160: UPDATE JL_BR_CUSTOMER_TRX_EXTS
161: SET ELECTRONIC_INV_WEB_ADDRESS = P_ELECT_INV_WEB_ADDRESS,
162: ELECTRONIC_INV_STATUS = P_ELECT_INV_STATUS,
163: ELECTRONIC_INV_ACCESS_KEY = P_ELECT_INV_ACCESS_KEY,
164: ELECTRONIC_INV_PROTOCOL = P_ELECT_INV_PROTOCOL,

Line 262: FROM JL_BR_CUSTOMER_TRX_EXTS

258: -- Declaration part
259:
260: CURSOR C_INV_STATUS IS
261: SELECT ELECTRONIC_INV_STATUS
262: FROM JL_BR_CUSTOMER_TRX_EXTS
263: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
264:
265: CURSOR C_CUST_TRX_EXIST IS
266: SELECT 'Yes' as isExist FROM RA_CUSTOMER_TRX_ALL