APPS.JL_BR_SPED_PUB dependencies on JL_BR_CUSTOMER_TRX_EXTS

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

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

Line 56: FROM JL_BR_CUSTOMER_TRX_EXTS

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

Line 126: -- Create an entry in JL_BR_CUSTOMER_TRX_EXTS table

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

Line 127: INSERT INTO JL_BR_CUSTOMER_TRX_EXTS(

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

Line 155: UPDATE JL_BR_CUSTOMER_TRX_EXTS

151: FOR trx_rec IN C_TRX LOOP
152: RAISE inv_status_final;
153: END LOOP;
154:
155: UPDATE JL_BR_CUSTOMER_TRX_EXTS
156: SET ELECTRONIC_INV_WEB_ADDRESS = P_ELECT_INV_WEB_ADDRESS,
157: ELECTRONIC_INV_STATUS = P_ELECT_INV_STATUS,
158: ELECTRONIC_INV_ACCESS_KEY = P_ELECT_INV_ACCESS_KEY,
159: ELECTRONIC_INV_PROTOCOL = P_ELECT_INV_PROTOCOL,

Line 256: FROM JL_BR_CUSTOMER_TRX_EXTS

252: -- Declaration part
253:
254: CURSOR C_INV_STATUS IS
255: SELECT ELECTRONIC_INV_STATUS
256: FROM JL_BR_CUSTOMER_TRX_EXTS
257: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID;
258:
259: CURSOR C_CUST_TRX_EXIST IS
260: SELECT 'Yes' as isExist FROM RA_CUSTOMER_TRX_ALL