APPS.CSC_PLAN_HEADERS_B_PKG dependencies on CSC_PLAN_HEADERS_B

Line 1: PACKAGE BODY CSC_PLAN_HEADERS_B_PKG as

1: PACKAGE BODY CSC_PLAN_HEADERS_B_PKG as
2: /* $Header: csctrlpb.pls 120.3 2005/09/19 00:01:34 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_HEADERS_B_PKG
5: -- Purpose : Table handler for CSC_PLAN_HEADERS_B. Contains procedure to INSERT,

Line 4: -- Package name : CSC_PLAN_HEADERS_B_PKG

1: PACKAGE BODY CSC_PLAN_HEADERS_B_PKG as
2: /* $Header: csctrlpb.pls 120.3 2005/09/19 00:01:34 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_HEADERS_B_PKG
5: -- Purpose : Table handler for CSC_PLAN_HEADERS_B. Contains procedure to INSERT,
6: -- UPDATE, DISABLE, LOCK records in CSC_PLAN_HEADERS_B table.
7: -- History :
8: -- MM-DD-YYYY NAME MODIFICATIONS

Line 5: -- Purpose : Table handler for CSC_PLAN_HEADERS_B. Contains procedure to INSERT,

1: PACKAGE BODY CSC_PLAN_HEADERS_B_PKG as
2: /* $Header: csctrlpb.pls 120.3 2005/09/19 00:01:34 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_HEADERS_B_PKG
5: -- Purpose : Table handler for CSC_PLAN_HEADERS_B. Contains procedure to INSERT,
6: -- UPDATE, DISABLE, LOCK records in CSC_PLAN_HEADERS_B table.
7: -- History :
8: -- MM-DD-YYYY NAME MODIFICATIONS
9: -- 10-14-1999 dejoseph Created.

Line 6: -- UPDATE, DISABLE, LOCK records in CSC_PLAN_HEADERS_B table.

2: /* $Header: csctrlpb.pls 120.3 2005/09/19 00:01:34 vshastry ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_HEADERS_B_PKG
5: -- Purpose : Table handler for CSC_PLAN_HEADERS_B. Contains procedure to INSERT,
6: -- UPDATE, DISABLE, LOCK records in CSC_PLAN_HEADERS_B table.
7: -- History :
8: -- MM-DD-YYYY NAME MODIFICATIONS
9: -- 10-14-1999 dejoseph Created.
10: -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.

Line 48: -- 05-24-2004 bhroy Commetend Application ID update for CSC_PLAN_HEADERS_B table, fixed bug# 3643065

44: -- Added the dbdrv command.
45: -- 05-23-2002 dejoseph Added checkfile syntax.
46: -- 11-12-2002 bhroy NOCOPY changes made
47: -- 11-25-2002 bhroy FND_API default removed, added WHENEVER OSERROR EXIT FAILURE ROLLBACK
48: -- 05-24-2004 bhroy Commetend Application ID update for CSC_PLAN_HEADERS_B table, fixed bug# 3643065
49: -- 19-july-2005 tpalaniv Modified the translate_row and load_row APIs to fetch last_updated_by using FND API
50: --
51: -- NOTE :
52: -- End of Comments

Line 55: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PLAN_HEADERS_B_PKG';

51: -- NOTE :
52: -- End of Comments
53:
54:
55: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PLAN_HEADERS_B_PKG';
56: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csctrlpb.pls';
57:
58: /* PROCEDURE TO DO INSERTS INTO THE MLSED TABLES */
59:

Line 101: from CSC_PLAN_HEADERS_B

97: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER )
98: IS
99: cursor C is
100: select rowid
101: from CSC_PLAN_HEADERS_B
102: where PLAN_ID = PX_PLAN_ID ;
103:
104:
105: CURSOR C2 IS

Line 133: INSERT INTO CSC_PLAN_HEADERS_B (

129: else
130: l_application_id := p_application_id;
131: end if;
132:
133: INSERT INTO CSC_PLAN_HEADERS_B (
134: PLAN_ID,
135: ORIGINAL_PLAN_ID,
136: PLAN_GROUP_CODE,
137: START_DATE_ACTIVE,

Line 298: update CSC_PLAN_HEADERS_B set

294: else
295: l_application_id := p_application_id;
296: end if;
297:
298: update CSC_PLAN_HEADERS_B set
299: ORIGINAL_PLAN_ID = P_ORIGINAL_PLAN_ID,
300: PLAN_GROUP_CODE = P_PLAN_GROUP_CODE,
301: START_DATE_ACTIVE = P_START_DATE_ACTIVE,
302: END_DATE_ACTIVE = P_END_DATE_ACTIVE,

Line 360: update CSC_PLAN_HEADERS_B

356:
357: procedure DISABLE_ROW (
358: P_PLAN_ID IN NUMBER) is
359: begin
360: update CSC_PLAN_HEADERS_B
361: set end_date_active = sysdate+1
362: where plan_id = p_plan_id;
363:
364: If (SQL%NOTFOUND) then

Line 420: from CSC_PLAN_HEADERS_B B

416: begin
417: delete from CSC_PLAN_HEADERS_TL T
418: where not exists
419: (select NULL
420: from CSC_PLAN_HEADERS_B B
421: where B.PLAN_ID = T.PLAN_ID
422: );
423:
424: update CSC_PLAN_HEADERS_TL T set (

Line 624: End CSC_PLAN_HEADERS_B_PKG;

620:
621: END LOAD_ROW;
622:
623:
624: End CSC_PLAN_HEADERS_B_PKG;