APPS.PO_CHANGE_ORDER_TOLERANCES_PKG dependencies on PO_CHANGE_ORDER_TOLERANCES_ALL

Line 14: -- 1. inserts a record into PO_CHANGE_ORDER_TOLERANCES_ALL table

10: -- None
11: --Locks:
12: -- None
13: --Function:
14: -- 1. inserts a record into PO_CHANGE_ORDER_TOLERANCES_ALL table
15: --Parameters:
16: --IN:
17: -- X_CHANGE_ORDER_TYPE Change Order Type
18: -- X_TOLERANCE_NAME Tolerance name

Line 53: insert into PO_CHANGE_ORDER_TOLERANCES_ALL (

49:
50: select to_char(PO_CHANGE_ORDER_TOLERANCES_S.NEXTVAL)
51: into X_TOLERANCE_ID from sys.dual;
52:
53: insert into PO_CHANGE_ORDER_TOLERANCES_ALL (
54: TOLERANCE_ID,
55: CHANGE_ORDER_TYPE,
56: TOLERANCE_NAME,
57: ORG_ID,

Line 94: -- 1. Load the row into PO_CHANGE_ORDER_TOLERANCES_ALL table

90: -- None
91: --Locks:
92: -- None
93: --Function:
94: -- 1. Load the row into PO_CHANGE_ORDER_TOLERANCES_ALL table
95: --Parameters:
96: --IN:
97: -- X_CHANGE_ORDER_TYPE Change Order Type
98: -- X_TOLERANCE_NAME Tolerance name

Line 139: from PO_CHANGE_ORDER_TOLERANCES_ALL

135: -- last_updated_by to 1 when it is -1 so that the record can be updated.
136:
137: select DECODE(LAST_UPDATED_BY, -1, 1, LAST_UPDATED_BY), LAST_UPDATE_DATE
138: into db_luby, db_ludate
139: from PO_CHANGE_ORDER_TOLERANCES_ALL
140: where change_order_Type = X_CHANGE_ORDER_TYPE
141: and TOLERANCE_NAME = X_TOLERANCE_NAME
142: and ( (X_ORG_ID is null and org_id = -3113 )
143: or (X_ORG_ID is not null and org_id = X_ORG_ID));

Line 149: UPDATE PO_CHANGE_ORDER_TOLERANCES_ALL

145: -- Chanded the condition in such a way that only date is considered while updating owner is not updated
146: -- if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
147: if (fnd_load_util.upload_test(f_luby, f_ludate, f_luby, db_ludate, X_CUSTOM_MODE)) then
148:
149: UPDATE PO_CHANGE_ORDER_TOLERANCES_ALL
150: SET MAXIMUM_INCREMENT = X_MAXIMUM_INCREMENT,
151: MAXIMUM_DECREMENT = X_MAXIMUM_DECREMENT,
152: ROUTING_FLAG = X_ROUTING_FLAG,
153: LAST_UPDATE_DATE = f_ludate ,