APPS.JG_ZZ_TA_ALLOCATED_LINES_PKG dependencies on JG_ZZ_TA_ALLOCATED_LINES

Line 1: PACKAGE BODY JG_ZZ_TA_ALLOCATED_LINES_PKG AS

1: PACKAGE BODY JG_ZZ_TA_ALLOCATED_LINES_PKG AS
2: /* $Header: jgzzallb.pls 120.1 2006/02/21 15:16:24 farishol ship $ */
3: --
4: -- PUBLIC FUNCTIONS
5: --

Line 20: FROM JG_ZZ_TA_ALLOCATED_LINES

16: ,X_program_application_id NUMBER
17: ,X_program_id NUMBER
18: ,X_program_update_date DATE) IS
19: CURSOR C IS SELECT rowid
20: FROM JG_ZZ_TA_ALLOCATED_LINES
21: WHERE X_je_batch_id = je_batch_id AND
22: X_je_header_id = je_header_id AND
23: X_je_line_num = je_line_num;
24: BEGIN

Line 25: INSERT INTO JG_ZZ_TA_ALLOCATED_LINES

21: WHERE X_je_batch_id = je_batch_id AND
22: X_je_header_id = je_header_id AND
23: X_je_line_num = je_line_num;
24: BEGIN
25: INSERT INTO JG_ZZ_TA_ALLOCATED_LINES
26: (je_batch_id
27: ,je_header_id
28: ,je_line_num
29: ,creation_date

Line 62: DELETE FROM JG_ZZ_TA_ALLOCATED_LINES

58: END insert_row;
59:
60: PROCEDURE Delete_Row( X_rowid VARCHAR2 ) IS
61: BEGIN
62: DELETE FROM JG_ZZ_TA_ALLOCATED_LINES
63: WHERE ROWID = X_rowid;
64: IF (SQL%NOTFOUND) THEN
65: RAISE NO_DATA_FOUND;
66: END IF;

Line 69: END JG_ZZ_TA_ALLOCATED_LINES_PKG;

65: RAISE NO_DATA_FOUND;
66: END IF;
67: END Delete_Row;
68:
69: END JG_ZZ_TA_ALLOCATED_LINES_PKG;