DBA Data[Home] [Help]

APPS.CSC_PROF_TABLE_COLUMNS_PKG dependencies on CSC_PROF_TABLE_COLUMNS_PKG

Line 1: PACKAGE BODY CSC_PROF_TABLE_COLUMNS_PKG as

1: PACKAGE BODY CSC_PROF_TABLE_COLUMNS_PKG as
2: /* $Header: csctptcb.pls 120.2 2005/09/18 23:33:50 vshastry noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_TABLE_COLUMNS_PKG
5: -- Purpose :

Line 4: -- Package name : CSC_PROF_TABLE_COLUMNS_PKG

1: PACKAGE BODY CSC_PROF_TABLE_COLUMNS_PKG as
2: /* $Header: csctptcb.pls 120.2 2005/09/18 23:33:50 vshastry noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_TABLE_COLUMNS_PKG
5: -- Purpose :
6: -- History : 25-Nov-02 JAmose Fnd_Api_G_MISS*,NOCOPY related changes
7: -- History : 24-Feb-2003, Introduced new procedure delete_existing_row to
8: -- delete before loading a row

Line 14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_TABLE_COLUMNS_PKG';

10: -- NOTE :
11: -- End of Comments
12:
13:
14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_TABLE_COLUMNS_PKG';
15: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csctuvab.pls';
16:
17: PROCEDURE Insert_Row(
18: px_TABLE_COLUMN_ID IN OUT NOCOPY NUMBER,

Line 345: Csc_Prof_Table_Columns_Pkg.Update_Row(

341: l_table_column_id number := p_table_column_id;
342: Begin
343:
344:
345: Csc_Prof_Table_Columns_Pkg.Update_Row(
346: p_TABLE_COLUMN_ID => P_TABLE_COLUMN_ID,
347: p_BLOCK_ID => P_BLOCK_ID,
348: p_TABLE_NAME => P_TABLE_NAME,
349: p_COLUMN_NAME => P_COLUMN_NAME,

Line 369: Csc_Prof_Table_Columns_Pkg.Delete_Existing_Row(

365: records with new sequence number. So in the customer site it will
366: introduce new set of records with diff sequence numbers. So the following
367: procedure will check and will remove the existing record first before
368: uploading new set of records -jamose */
369: Csc_Prof_Table_Columns_Pkg.Delete_Existing_Row(
370: p_BLOCK_ID =>p_block_id,
371: p_TABLE_NAME =>p_table_name,
372: p_COLUMN_NAME =>p_column_name
373: );

Line 375: Csc_Prof_Table_Columns_Pkg.Insert_Row(

371: p_TABLE_NAME =>p_table_name,
372: p_COLUMN_NAME =>p_column_name
373: );
374:
375: Csc_Prof_Table_Columns_Pkg.Insert_Row(
376: px_TABLE_COLUMN_ID => l_table_column_id,
377: p_BLOCK_ID => P_block_id,
378: p_TABLE_NAME => P_table_name,
379: p_COLUMN_NAME => P_column_name,

Line 395: End CSC_PROF_TABLE_COLUMNS_PKG;

391:
392: End LOAD_ROW;
393:
394:
395: End CSC_PROF_TABLE_COLUMNS_PKG;