APPS.AS_SALES_METHODOLOGY_PKG dependencies on AS_SALES_METHODOLOGY_B

Line 33: CURSOR C IS SELECT ROWID FROM AS_SALES_METHODOLOGY_B

29: X_LAST_UPDATE_DATE IN DATE,
30: X_LAST_UPDATED_BY IN NUMBER,
31: X_LAST_UPDATE_LOGIN IN NUMBER)
32: IS
33: CURSOR C IS SELECT ROWID FROM AS_SALES_METHODOLOGY_B
34: WHERE SALES_METHODOLOGY_ID = X_SALES_METHODOLOGY_ID
35: ;
36: BEGIN
37: INSERT INTO AS_SALES_METHODOLOGY_B (

Line 37: INSERT INTO AS_SALES_METHODOLOGY_B (

33: CURSOR C IS SELECT ROWID FROM AS_SALES_METHODOLOGY_B
34: WHERE SALES_METHODOLOGY_ID = X_SALES_METHODOLOGY_ID
35: ;
36: BEGIN
37: INSERT INTO AS_SALES_METHODOLOGY_B (
38: SALES_METHODOLOGY_ID,
39: START_DATE_ACTIVE,
40: END_DATE_ACTIVE,
41: AUTOCREATETASK_FLAG,

Line 139: from AS_SALES_METHODOLOGY_B

135: X_OBJECT_VERSION_NUMBER in NUMBER
136: ) is
137: cursor c is select
138: OBJECT_VERSION_NUMBER
139: from AS_SALES_METHODOLOGY_B
140: where SALES_METHODOLOGY_ID = X_SALES_METHODOLOGY_ID
141: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
142: for update of SALES_METHODOLOGY_ID nowait;
143: recinfo c%rowtype;

Line 195: UPDATE AS_SALES_METHODOLOGY_B SET

191: X_LAST_UPDATED_BY IN NUMBER,
192: X_LAST_UPDATE_LOGIN IN NUMBER
193: ) IS
194: BEGIN
195: UPDATE AS_SALES_METHODOLOGY_B SET
196: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
197: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
198: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
199: AUTOCREATETASK_FLAG = X_AUTOCREATETASK_FLAG,

Line 252: DELETE FROM AS_SALES_METHODOLOGY_B

248: IF (SQL%NOTFOUND) THEN
249: RAISE no_data_found;
250: END IF;
251:
252: DELETE FROM AS_SALES_METHODOLOGY_B
253: WHERE SALES_METHODOLOGY_ID = X_SALES_METHODOLOGY_ID ;
254:
255: IF (SQL%NOTFOUND) THEN
256: RAISE no_data_found;

Line 266: FROM AS_SALES_METHODOLOGY_B B

262: BEGIN
263: DELETE FROM AS_SALES_METHODOLOGY_TL T
264: WHERE NOT EXISTS
265: (SELECT NULL
266: FROM AS_SALES_METHODOLOGY_B B
267: WHERE B.SALES_METHODOLOGY_ID = T.SALES_METHODOLOGY_ID
268: );
269:
270: update AS_SALES_METHODOLOGY_TL T set (