APPS.OE_HOLDS_PUB dependencies on OE_PAYMENTS

Line 2982: TYPE payment_type_tab IS TABLE OF OE_PAYMENTS.PAYMENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

2978: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
2979:
2980: l_entity_tab entity_tab;
2981:
2982: TYPE payment_type_tab IS TABLE OF OE_PAYMENTS.PAYMENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2983: l_payment_type_tab payment_type_tab;
2984: pay_idx NUMBER :=0;
2985: l_all_del_pay varchar2(1) := 'Y';
2986: --ER#7479609 end

Line 3108: FROM OE_PAYMENTS

3104: l_payment_type_tab.delete;
3105:
3106: Select payment_type_code payment_type
3107: BULK COLLECT INTO l_payment_type_tab
3108: FROM OE_PAYMENTS
3109: WHERE header_id=l_header_rec.header_id
3110: AND line_id IS NULL;
3111:
3112: EXCEPTION

Line 3323: FROM OE_PAYMENTS

3319: SELECT V.payment_type
3320: BULK COLLECT INTO l_payment_type_tab
3321: FROM
3322: (Select payment_type_code payment_type
3323: FROM OE_PAYMENTS
3324: WHERE header_id=l_header_rec.header_id
3325: AND line_id IS NULL
3326: UNION
3327: SELECT payment_type_code payment_type

Line 3370: FROM OE_PAYMENTS

3366: l_payment_type_tab.delete;
3367:
3368: Select payment_type_code payment_type
3369: BULK COLLECT INTO l_payment_type_tab
3370: FROM OE_PAYMENTS
3371: WHERE header_id=l_header_rec.header_id
3372: AND line_id IS NOT NULL;
3373:
3374: EXCEPTION

Line 4275: TYPE payment_type_tab IS TABLE OF OE_PAYMENTS.PAYMENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

4271: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
4272:
4273: l_entity_tab entity_tab;
4274:
4275: TYPE payment_type_tab IS TABLE OF OE_PAYMENTS.PAYMENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
4276: l_payment_type_tab payment_type_tab;
4277: pay_idx NUMBER :=0;
4278:
4279: --ER#7479609 end

Line 4394: FROM OE_PAYMENTS

4390: SELECT V.payment_type
4391: BULK COLLECT INTO l_payment_type_tab
4392: FROM
4393: (Select payment_type_code payment_type
4394: FROM OE_PAYMENTS
4395: WHERE header_id=l_header_rec.header_id
4396: AND line_id IS NULL
4397: UNION
4398: SELECT payment_type_code payment_type

Line 4435: FROM OE_PAYMENTS

4431: l_payment_type_tab.delete;
4432:
4433: Select payment_type_code payment_type
4434: BULK COLLECT INTO l_payment_type_tab
4435: FROM OE_PAYMENTS
4436: WHERE header_id=l_header_rec.header_id
4437: AND line_id IS NOT NULL;
4438: EXCEPTION
4439: WHEN OTHERS THEN