APPS.JTF_PC_CATEGORIES_PKG dependencies on JTF_PC_CATEGORIES_B

Line 34: CURSOR C IS SELECT rowid FROM jtf_pc_categories_b

30: X_Last_Update_Date DATE,
31: X_Last_Update_Login NUMBER DEFAULT NULL
32: ) IS
33:
34: CURSOR C IS SELECT rowid FROM jtf_pc_categories_b
35: WHERE category_id = X_Category_Id;
36: BEGIN
37:
38:

Line 39: INSERT INTO jtf_pc_categories_b(

35: WHERE category_id = X_Category_Id;
36: BEGIN
37:
38:
39: INSERT INTO jtf_pc_categories_b(
40: Category_Id,
41: Internal_Name,
42: Start_Date_Effective,
43: End_Date_Effective,

Line 161: FROM jtf_pc_categories_b

157: X_Attribute15 VARCHAR2 DEFAULT NULL
158: ) IS
159: CURSOR C IS
160: SELECT *
161: FROM jtf_pc_categories_b
162: WHERE rowid = X_Rowid
163: FOR UPDATE of Category_Id NOWAIT;
164: Recinfo C%ROWTYPE;
165:

Line 294: UPDATE jtf_pc_categories_b

290: X_Last_Update_Date DATE,
291: X_Last_Update_Login NUMBER DEFAULT NULL
292: ) IS
293: BEGIN
294: UPDATE jtf_pc_categories_b
295: SET
296: internal_name = X_Internal_Name,
297: start_date_effective = X_Start_Date_Effective,
298: end_date_effective = X_End_Date_Effective,

Line 348: DELETE FROM jtf_pc_categories_b

344: X_Object_Version_Number NUMBER) IS
345:
346: BEGIN
347:
348: DELETE FROM jtf_pc_categories_b
349: WHERE CATEGORY_ID = X_Category_Id
350: and OBJECT_VERSION_NUMBER = X_Object_Version_Number;
351:
352: if (SQL%NOTFOUND) then

Line 378: from JTF_PC_CATEGORIES_B B

374: -- delete from tl table if same category doesn't exist in base table
375: delete from JTF_PC_CATEGORIES_TL T
376: where not exists
377: (select NULL
378: from JTF_PC_CATEGORIES_B B
379: where B.CATEGORY_ID = T.CATEGORY_ID
380: );
381:
382: -- repair description in tl table

Line 473: from jtf_pc_categories_b

469: end if;
470:
471: select count(*)
472: into h_record_exists
473: from jtf_pc_categories_b
474: where category_id = X_Category_Id;
475:
476: if (h_record_exists > 0) then
477:

Line 480: from jtf_pc_categories_b

476: if (h_record_exists > 0) then
477:
478: select object_version_number
479: into v_object_version_number
480: from jtf_pc_categories_b
481: where category_id = X_Category_Id;
482:
483: jtf_pc_categories_pkg.Update_Row(
484: X_Category_Id => X_category_id,