1: Package Body JTF_PC_CATEGORIES_PKG AS
2: /*$Header: jtfpjpcb.pls 120.2 2005/08/18 22:54:49 stopiwal ship $*/
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5: X_Category_Id 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,
485: X_Internal_Name => X_Internal_Name,
486: X_Start_Date_Effective => X_Start_Date_Effective,
487: X_End_Date_Effective => X_End_Date_Effective,
508: X_Last_Updated_By => user_id,
509: X_Last_Update_Login => 0
510: );
511: else
512: jtf_pc_categories_pkg.Insert_Row(
513: X_Rowid => row_id,
514: X_Category_Id => X_category_id,
515: X_Internal_Name => X_Internal_Name,
516: X_Start_Date_Effective => X_Start_Date_Effective,
563: and CATEGORY_ID = X_Category_ID;
564:
565: end TRANSLATE_ROW;
566:
567: END JTF_PC_CATEGORIES_PKG;