APPS.OE_TRANSACTION_TYPES_PKG dependencies on OE_TRANSACTION_TYPES_ALL

Line 78: cursor C is select ROWID from OE_TRANSACTION_TYPES_ALL

74: X_quote_num_as_ord_num_flag in VARCHAR2 default null,
75: X_CONTRACT_TEMPLATE_ID in number
76:
77: ) is
78: cursor C is select ROWID from OE_TRANSACTION_TYPES_ALL
79: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
80: ;
81: begin
82: insert into OE_TRANSACTION_TYPES_ALL (

Line 82: insert into OE_TRANSACTION_TYPES_ALL (

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

Line 399: from OE_TRANSACTION_TYPES_ALL

395: DEFAULT_LINE_SET_CODE,
396: def_transaction_phase_code,
397: quote_num_as_ord_num_flag,
398: CONTRACT_TEMPLATE_ID
399: from OE_TRANSACTION_TYPES_ALL
400: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
401: for update of TRANSACTION_TYPE_ID nowait;
402: recinfo c%rowtype;
403:

Line 633: update OE_TRANSACTION_TYPES_ALL set

629: X_quote_num_as_ord_num_flag in VARCHAR2 default null,
630: X_CONTRACT_TEMPLATE_ID in number
631: ) is
632: begin
633: update OE_TRANSACTION_TYPES_ALL set
634: TRANSACTION_TYPE_CODE = X_TRANSACTION_TYPE_CODE,
635: ORDER_CATEGORY_CODE = X_ORDER_CATEGORY_CODE,
636: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
637: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 730: delete from OE_TRANSACTION_TYPES_ALL

726: if (sql%notfound) then
727: raise no_data_found;
728: end if;
729:
730: delete from OE_TRANSACTION_TYPES_ALL
731: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
732:
733: if (sql%notfound) then
734: raise no_data_found;

Line 744: from OE_TRANSACTION_TYPES_ALL B

740: begin
741: delete from OE_TRANSACTION_TYPES_TL T
742: where not exists
743: (select NULL
744: from OE_TRANSACTION_TYPES_ALL B
745: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
746: );
747:
748: update OE_TRANSACTION_TYPES_TL T set (