APPS.OE_TRANSACTION_TYPES_PKG dependencies on OE_TRANSACTION_TYPES_ALL

Line 80: cursor C is select ROWID from OE_TRANSACTION_TYPES_ALL

76: X_CREDIT_CARD_REV_REAUTH_CODE in VARCHAR2 default null, --CC Reversal ER#16014135
77: X_use_ame_approval IN VARCHAR2 default null-- AME ER 16084377
78:
79: ) is
80: cursor C is select ROWID from OE_TRANSACTION_TYPES_ALL
81: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
82: ;
83: begin
84: insert into OE_TRANSACTION_TYPES_ALL (

Line 84: insert into OE_TRANSACTION_TYPES_ALL (

80: cursor C is select ROWID from OE_TRANSACTION_TYPES_ALL
81: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
82: ;
83: begin
84: insert into OE_TRANSACTION_TYPES_ALL (
85: TRANSACTION_TYPE_ID,
86: TRANSACTION_TYPE_CODE,
87: ORG_ID,
88: ORDER_CATEGORY_CODE,

Line 408: from OE_TRANSACTION_TYPES_ALL

404: quote_num_as_ord_num_flag,
405: CONTRACT_TEMPLATE_ID ,
406: CREDIT_CARD_REV_REAUTH_CODE, --CC Reversal ER#16014135
407: use_ame_approval --ame er 16084377
408: from OE_TRANSACTION_TYPES_ALL
409: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
410: for update of TRANSACTION_TYPE_ID nowait;
411: recinfo c%rowtype;
412:

Line 648: update OE_TRANSACTION_TYPES_ALL set

644: X_CREDIT_CARD_REV_REAUTH_CODE in VARCHAR2 default null ,--CC Reversal ER#16014135
645: X_use_ame_approval IN VARCHAR2 default null -- AME ER 16084377
646: ) is
647: begin
648: update OE_TRANSACTION_TYPES_ALL set
649: TRANSACTION_TYPE_CODE = X_TRANSACTION_TYPE_CODE,
650: ORDER_CATEGORY_CODE = X_ORDER_CATEGORY_CODE,
651: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
652: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 747: delete from OE_TRANSACTION_TYPES_ALL

743: if (sql%notfound) then
744: raise no_data_found;
745: end if;
746:
747: delete from OE_TRANSACTION_TYPES_ALL
748: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
749:
750: if (sql%notfound) then
751: raise no_data_found;

Line 761: from OE_TRANSACTION_TYPES_ALL B

757: begin
758: delete from OE_TRANSACTION_TYPES_TL T
759: where not exists
760: (select NULL
761: from OE_TRANSACTION_TYPES_ALL B
762: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
763: );
764:
765: update OE_TRANSACTION_TYPES_TL T set (