APPS.OE_HOLDS_PUB dependencies on OE_PAYMENTS

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

3084: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
3085:
3086: l_entity_tab entity_tab;
3087:
3088: TYPE payment_type_tab IS TABLE OF OE_PAYMENTS.PAYMENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3089: l_payment_type_tab payment_type_tab;
3090: pay_idx NUMBER :=0;
3091: l_all_del_pay varchar2(1) := 'Y';
3092: --ER#7479609 end

Line 3232: FROM OE_PAYMENTS

3228: l_payment_type_tab.delete;
3229:
3230: Select payment_type_code payment_type
3231: BULK COLLECT INTO l_payment_type_tab
3232: FROM OE_PAYMENTS
3233: WHERE header_id=l_header_rec.header_id
3234: AND line_id IS NULL;
3235:
3236: EXCEPTION

Line 3460: FROM OE_PAYMENTS

3456: SELECT V.payment_type
3457: BULK COLLECT INTO l_payment_type_tab
3458: FROM
3459: (Select payment_type_code payment_type
3460: FROM OE_PAYMENTS
3461: WHERE header_id=l_header_rec.header_id
3462: AND line_id IS NULL
3463: UNION
3464: SELECT payment_type_code payment_type

Line 3510: FROM OE_PAYMENTS

3506: l_payment_type_tab.delete;
3507:
3508: Select payment_type_code payment_type
3509: BULK COLLECT INTO l_payment_type_tab
3510: FROM OE_PAYMENTS
3511: WHERE header_id=l_header_rec.header_id
3512: AND line_id IS NOT NULL;
3513:
3514: EXCEPTION

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

4568: TYPE entity_tab IS TABLE OF entity_rec INDEX BY BINARY_INTEGER;
4569:
4570: l_entity_tab entity_tab;
4571:
4572: TYPE payment_type_tab IS TABLE OF OE_PAYMENTS.PAYMENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
4573: l_payment_type_tab payment_type_tab;
4574: pay_idx NUMBER :=0;
4575:
4576: --ER#7479609 end

Line 4697: FROM OE_PAYMENTS

4693: SELECT V.payment_type
4694: BULK COLLECT INTO l_payment_type_tab
4695: FROM
4696: (Select payment_type_code payment_type
4697: FROM OE_PAYMENTS
4698: WHERE header_id=l_header_rec.header_id
4699: AND line_id IS NULL
4700: UNION
4701: SELECT payment_type_code payment_type

Line 4760: FROM OE_PAYMENTS

4756: l_payment_type_tab.delete;
4757:
4758: Select payment_type_code payment_type
4759: BULK COLLECT INTO l_payment_type_tab
4760: FROM OE_PAYMENTS
4761: WHERE header_id=l_header_rec.header_id
4762: AND line_id IS NOT NULL;
4763: EXCEPTION
4764: WHEN OTHERS THEN