APPS.CSC_PLAN_LINES_PKG dependencies on CSC_PLAN_LINES

Line 1: PACKAGE BODY CSC_PLAN_LINES_PKG as

1: PACKAGE BODY CSC_PLAN_LINES_PKG as
2: /* $Header: csctplnb.pls 120.3 2005/09/18 23:57:09 vshastry noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_LINES_PKG
5: -- Purpose : Table handler package to performs Inserts, Updates, Deletes and

Line 4: -- Package name : CSC_PLAN_LINES_PKG

1: PACKAGE BODY CSC_PLAN_LINES_PKG as
2: /* $Header: csctplnb.pls 120.3 2005/09/18 23:57:09 vshastry noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_LINES_PKG
5: -- Purpose : Table handler package to performs Inserts, Updates, Deletes and
6: -- row operations on the CSC_PLAN_LINES table.
7: -- History :
8: -- MM-DD-YYYY NAME MODIFICATIONS

Line 6: -- row operations on the CSC_PLAN_LINES table.

2: /* $Header: csctplnb.pls 120.3 2005/09/18 23:57:09 vshastry noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_LINES_PKG
5: -- Purpose : Table handler package to performs Inserts, Updates, Deletes and
6: -- row operations on the CSC_PLAN_LINES table.
7: -- History :
8: -- MM-DD-YYYY NAME MODIFICATIONS
9: -- 10-21-1999 dejoseph Created.
10: -- 12-08-1999 dejoseph 'Arcs'ed in for first code freeze.

Line 34: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_PLAN_LINES_PKG';

30: -- NOTE :
31: -- End of Comments
32:
33:
34: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_PLAN_LINES_PKG';
35: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csctplnb.pls';
36:
37: PROCEDURE Insert_Row(
38: px_LINE_ID IN OUT NOCOPY NUMBER,

Line 66: SELECT CSC_PLAN_LINES_S.nextval

62: p_APPLICATION_ID IN NUMBER,
63: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER)
64: IS
65: CURSOR C2 IS
66: SELECT CSC_PLAN_LINES_S.nextval
67: FROM sys.dual;
68:
69: l_seeded_flag VARCHAR2(3);
70:

Line 85: INSERT INTO CSC_PLAN_LINES(

81: else
82: l_seeded_flag := 'N';
83: end if;
84:
85: INSERT INTO CSC_PLAN_LINES(
86: LINE_ID,
87: PLAN_ID,
88: CONDITION_ID,
89: LAST_UPDATE_DATE,

Line 183: Update CSC_PLAN_LINES

179: else
180: l_seeded_flag := 'N';
181: end if;
182:
183: Update CSC_PLAN_LINES
184: SET
185: PLAN_ID = decode( p_PLAN_ID, FND_API.G_MISS_NUM, PLAN_ID, p_PLAN_ID),
186: CONDITION_ID = decode( p_CONDITION_ID, FND_API.G_MISS_NUM,
187: CONDITION_ID, p_CONDITION_ID),

Line 229: DELETE FROM CSC_PLAN_LINES

225: P_LINE_ID IN NUMBER,
226: P_PLAN_ID IN NUMBER)
227: IS
228: BEGIN
229: DELETE FROM CSC_PLAN_LINES
230: WHERE LINE_ID = nvl(p_line_id, LINE_ID)
231: and PLAN_ID = nvl(p_plan_id, PLAN_ID);
232:
233: If (SQL%NOTFOUND) then

Line 268: FROM CSC_PLAN_LINES

264: p_OBJECT_VERSION_NUMBER IN NUMBER)
265: IS
266: CURSOR C IS
267: SELECT *
268: FROM CSC_PLAN_LINES
269: WHERE LINE_ID = p_LINE_ID
270: FOR UPDATE of LINE_ID NOWAIT;
271: Recinfo C%ROWTYPE;
272: BEGIN

Line 459: End CSC_PLAN_LINES_PKG;

455: X_OBJECT_VERSION_NUMBER => l_object_version_number);
456:
457: END LOAD_ROW;
458:
459: End CSC_PLAN_LINES_PKG;