APPS.JTF_MSITE_PRTY_ACCSS_PKG dependencies on JTF_MSITE_PRTY_ACCSS

Line 1: PACKAGE BODY Jtf_Msite_Prty_Accss_Pkg AS

1: PACKAGE BODY Jtf_Msite_Prty_Accss_Pkg AS
2: /* $Header: JTFTMPRB.pls 115.1 2001/03/02 19:07:10 pkm ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_MSITE_PRTY_ACCSS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12):= 'JTFTMPRB.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_MSITE_PRTY_ACCSS_PKG';

1: PACKAGE BODY Jtf_Msite_Prty_Accss_Pkg AS
2: /* $Header: JTFTMPRB.pls 115.1 2001/03/02 19:07:10 pkm ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_MSITE_PRTY_ACCSS_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12):= 'JTFTMPRB.pls';
6:
7: PROCEDURE insert_row
8: (

Line 25: CURSOR c IS SELECT rowid FROM jtf_msite_prty_accss

21: x_rowid OUT VARCHAR2,
22: x_msite_prty_accss_id OUT NUMBER
23: )
24: IS
25: CURSOR c IS SELECT rowid FROM jtf_msite_prty_accss
26: WHERE msite_prty_accss_id = x_msite_prty_accss_id;
27: CURSOR c2 IS SELECT jtf_msite_prty_accss_s1.nextval FROM dual;
28:
29: BEGIN

Line 27: CURSOR c2 IS SELECT jtf_msite_prty_accss_s1.nextval FROM dual;

23: )
24: IS
25: CURSOR c IS SELECT rowid FROM jtf_msite_prty_accss
26: WHERE msite_prty_accss_id = x_msite_prty_accss_id;
27: CURSOR c2 IS SELECT jtf_msite_prty_accss_s1.nextval FROM dual;
28:
29: BEGIN
30:
31: -- Primary key validation check

Line 42: INSERT INTO jtf_msite_prty_accss

38: CLOSE c2;
39: END IF;
40:
41: -- insert base
42: INSERT INTO jtf_msite_prty_accss
43: (
44: msite_prty_accss_id,
45: object_version_number,
46: msite_id,

Line 104: UPDATE jtf_msite_prty_accss SET

100: IS
101: BEGIN
102:
103: -- update base
104: UPDATE jtf_msite_prty_accss SET
105: object_version_number = object_version_number + 1,
106: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
107: start_date_active, p_start_date_active),
108: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

Line 141: DELETE FROM jtf_msite_prty_accss

137: )
138: IS
139: BEGIN
140:
141: DELETE FROM jtf_msite_prty_accss
142: WHERE msite_prty_accss_id = p_msite_prty_accss_id;
143:
144: IF (sql%NOTFOUND) THEN
145: RAISE NO_DATA_FOUND;

Line 150: END Jtf_Msite_Prty_Accss_Pkg;

146: END IF;
147:
148: END delete_row;
149:
150: END Jtf_Msite_Prty_Accss_Pkg;