APPS.OZF_REASON_CODES_ALL_PKG dependencies on OZF_REASON_CODES_ALL_B

Line 58: CURSOR C IS SELECT rowid FROM OZF_REASON_CODES_ALL_B

54: IS
55: X_ROWID VARCHAR2(30);
56: l_reason_count NUMBER;
57:
58: CURSOR C IS SELECT rowid FROM OZF_REASON_CODES_ALL_B
59: WHERE REASON_CODE_ID = px_REASON_CODE_ID;
60: CURSOR C2 IS SELECT OZF_REASON_CODES_ALL_B_S.nextval FROM sys.dual;
61: CURSOR C_REASON_COUNT(l_reason_code_id NUMBER) IS
62: SELECT COUNT(REASON_CODE_ID)

Line 60: CURSOR C2 IS SELECT OZF_REASON_CODES_ALL_B_S.nextval FROM sys.dual;

56: l_reason_count NUMBER;
57:
58: CURSOR C IS SELECT rowid FROM OZF_REASON_CODES_ALL_B
59: WHERE REASON_CODE_ID = px_REASON_CODE_ID;
60: CURSOR C2 IS SELECT OZF_REASON_CODES_ALL_B_S.nextval FROM sys.dual;
61: CURSOR C_REASON_COUNT(l_reason_code_id NUMBER) IS
62: SELECT COUNT(REASON_CODE_ID)
63: FROM OZF_REASON_CODES_ALL_B
64: WHERE REASON_CODE_ID = l_reason_code_id;

Line 63: FROM OZF_REASON_CODES_ALL_B

59: WHERE REASON_CODE_ID = px_REASON_CODE_ID;
60: CURSOR C2 IS SELECT OZF_REASON_CODES_ALL_B_S.nextval FROM sys.dual;
61: CURSOR C_REASON_COUNT(l_reason_code_id NUMBER) IS
62: SELECT COUNT(REASON_CODE_ID)
63: FROM OZF_REASON_CODES_ALL_B
64: WHERE REASON_CODE_ID = l_reason_code_id;
65:
66: BEGIN
67: /* IF (px_ORG_ID IS NULL OR px_ORG_ID = FND_API.G_MISS_NUM) THEN

Line 91: INSERT INTO OZF_REASON_CODES_ALL_B(

87: px_OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM) THEN
88: px_OBJECT_VERSION_NUMBER := 1;
89: END IF;
90:
91: INSERT INTO OZF_REASON_CODES_ALL_B(
92: REASON_CODE_ID,
93: OBJECT_VERSION_NUMBER,
94: LAST_UPDATE_DATE,
95: LAST_UPDATED_BY,

Line 236: Update OZF_REASON_CODES_ALL_B

232: p_PARTNER_ACCESS_FLAG VARCHAR2)
233:
234: IS
235: BEGIN
236: Update OZF_REASON_CODES_ALL_B
237: SET
238: REASON_CODE_ID = p_REASON_CODE_ID,
239: OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER,
240: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,

Line 303: DELETE FROM OZF_REASON_CODES_ALL_B

299: if (sql%notfound) then
300: raise no_data_found;
301: end if;
302:
303: DELETE FROM OZF_REASON_CODES_ALL_B
304: WHERE REASON_CODE_ID = p_REASON_CODE_ID;
305:
306: If (SQL%NOTFOUND) then
307: RAISE NO_DATA_FOUND;

Line 350: FROM OZF_REASON_CODES_ALL_B

346:
347: IS
348: CURSOR C IS
349: SELECT *
350: FROM OZF_REASON_CODES_ALL_B
351: WHERE REASON_CODE_ID = p_REASON_CODE_ID
352: FOR UPDATE of REASON_CODE_ID NOWAIT;
353: Recinfo C%ROWTYPE;
354:

Line 498: from OZF_REASON_CODES_ALL_B B

494: begin
495: delete from OZF_REASON_CODES_ALL_TL T
496: where not exists
497: (select NULL
498: from OZF_REASON_CODES_ALL_B B
499: where B.REASON_CODE_ID = T.REASON_CODE_ID
500: and NVL(B.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
501: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
502: NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',