APPS.OE_PAYMENT_TYPES_UTIL dependencies on OE_PAYMENT_TYPES_ALL

Line 111: INSERT INTO oe_payment_types_all

107: where t.org_id = p_org_id
108: and t.payment_type_code = p_payment_type_code
109: and t.language = L.LANGUAGE_CODE);
110:
111: INSERT INTO oe_payment_types_all
112: (payment_type_code
113: ,start_date_active
114: ,end_date_active
115: ,enabled_flag

Line 217: FROM oe_payment_types_all

213:
214: ) IS
215: CURSOR C IS
216: SELECT *
217: FROM oe_payment_types_all
218: WHERE payment_type_code = p_payment_type_code
219: AND nvl(org_id,-1) = nvl(p_org_id,-1)
220: FOR UPDATE OF PAYMENT_TYPE_CODE NOWAIT;
221:

Line 388: UPDATE oe_payment_types_all

384: WHERE nvl(org_id,-1) = nvl(p_org_id, -1)
385: AND payment_type_code = p_payment_type_code
386: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
387:
388: UPDATE oe_payment_types_all
389: SET
390: payment_type_code = p_payment_type_code,
391: start_date_active = p_start_date_active,
392: end_date_active = p_end_date_active,

Line 445: DELETE FROM oe_payment_types_all

441: DELETE FROM oe_payment_types_tl
442: WHERE nvl(org_id,-1) = nvl(l_org_id,-1)
443: AND payment_type_code = p_payment_type_code;
444:
445: DELETE FROM oe_payment_types_all
446: WHERE nvl(org_id,-1) = nvl(l_org_id,-1)
447: AND payment_type_code = p_payment_type_code;
448:
449:

Line 528: from oe_payment_types_all

524:
525: l_user_id :=fnd_load_util.owner_id(x_owner); --seed data version
526:
527: select org_id,last_updated_by into l_org_id,l_db_user_id
528: from oe_payment_types_all
529: where payment_type_code = x_payment_type_code
530: and nvl(org_id,-1) = nvl(x_org_id,-1)
531: and rownum = 1;
532: --seed data version start

Line 669: from oe_payment_types_all opta

665: from oe_payment_types_vl optv
666: where nvl(org_id, -1) = nvl(p_from_org_id, -1)
667: and not exists (
668: select null
669: from oe_payment_types_all opta
670: where opta.payment_type_code = optv.payment_type_code
671: and nvl(opta.org_id, -1) = nvl(p_to_org_id, -1) );
672:
673: x_owner varchar2(30) := NULL;

Line 731: from OE_PAYMENT_TYPES_ALL B

727: begin
728: delete from OE_PAYMENT_TYPES_TL T
729: where not exists
730: (select NULL
731: from OE_PAYMENT_TYPES_ALL B
732: where B.PAYMENT_TYPE_CODE = T.PAYMENT_TYPE_CODE
733: and NVL(B.ORG_ID, -1) = NVL(T.ORG_ID, -1)
734: );
735: