APPS.FLM_KANBAN_SUMMARY_PKG dependencies on FLM_KANBAN_SUMMARY

Line 1: PACKAGE BODY FLM_KANBAN_SUMMARY_PKG as

1: PACKAGE BODY FLM_KANBAN_SUMMARY_PKG as
2: /* $Header: FLMKBNSB.pls 115.4 2002/11/27 11:04:08 nrajpal noship $ */
3:
4: PROCEDURE Insert_Row(X_rowid IN OUT NOCOPY VARCHAR2,
5: X_summary_id IN OUT NOCOPY NUMBER,

Line 20: CURSOR C1 IS SELECT rowid FROM FLM_KANBAN_SUMMARY

16: X_wip_line_id NUMBER,
17: X_x NUMBER,
18: X_y NUMBER) IS
19:
20: CURSOR C1 IS SELECT rowid FROM FLM_KANBAN_SUMMARY
21: WHERE summary_id = X_summary_id;
22: CURSOR C2 IS SELECT flm_kanban_summary_s.nextval FROM sys.dual;
23:
24: BEGIN

Line 22: CURSOR C2 IS SELECT flm_kanban_summary_s.nextval FROM sys.dual;

18: X_y NUMBER) IS
19:
20: CURSOR C1 IS SELECT rowid FROM FLM_KANBAN_SUMMARY
21: WHERE summary_id = X_summary_id;
22: CURSOR C2 IS SELECT flm_kanban_summary_s.nextval FROM sys.dual;
23:
24: BEGIN
25: if (X_summary_id is NULL) then
26: OPEN C2;

Line 30: INSERT INTO FLM_KANBAN_SUMMARY(

26: OPEN C2;
27: FETCH C2 INTO X_summary_id;
28: CLOSE C2;
29: end if;
30: INSERT INTO FLM_KANBAN_SUMMARY(
31: SUMMARY_ID
32: ,ORGANIZATION_ID
33: ,SUMMARY_TYPE
34: ,SUMMARY_CODE

Line 100: FROM FLM_KANBAN_SUMMARY

96: X_y NUMBER) IS
97:
98: CURSOR C IS
99: SELECT *
100: FROM FLM_KANBAN_SUMMARY
101: WHERE rowid = X_rowid
102: FOR UPDATE of summary_id NOWAIT;
103: Recinfo C%ROWTYPE;
104: BEGIN

Line 183: UPDATE FLM_KANBAN_SUMMARY

179: X_x NUMBER,
180: X_y NUMBER) IS
181:
182: BEGIN
183: UPDATE FLM_KANBAN_SUMMARY
184: SET
185: summary_id = X_summary_id,
186: organization_id = X_organization_id,
187: summary_type = X_summary_type,

Line 215: DELETE FROM FLM_KANBAN_SUMMARY

211:
212: PROCEDURE Delete_Row(X_rowid VARCHAR2) IS
213:
214: BEGIN
215: DELETE FROM FLM_KANBAN_SUMMARY
216: WHERE rowid = X_Rowid;
217:
218: if (SQL%NOTFOUND) then
219: Raise NO_DATA_FOUND;

Line 224: END FLM_KANBAN_SUMMARY_PKG;

220: end if;
221: END Delete_Row;
222:
223:
224: END FLM_KANBAN_SUMMARY_PKG;