APPS.GL_INTERFACE_CONTROL_PKG dependencies on GL_INTERFACE_CONTROL

Line 1: PACKAGE BODY gl_interface_control_pkg AS

1: PACKAGE BODY gl_interface_control_pkg AS
2: /* $Header: glijictb.pls 120.8 2005/06/17 23:21:53 djogg ship $ */
3:
4: --
5: -- PUBLIC FUNCTIONS

Line 11: SELECT gl_interface_control_s.NEXTVAL

7:
8: FUNCTION get_unique_id RETURN NUMBER IS
9: new_id number;
10: BEGIN
11: SELECT gl_interface_control_s.NEXTVAL
12: INTO new_id
13: FROM dual;
14:
15: return(new_id);

Line 36: FROM GL_INTERFACE_CONTROL ic

32: x_group_id NUMBER DEFAULT NULL,
33: row_id VARCHAR2) IS
34: CURSOR chk_duplicates is
35: SELECT 'Duplicate'
36: FROM GL_INTERFACE_CONTROL ic
37: WHERE ic.interface_run_id = x_interface_run_id
38: AND ic.je_source_name = x_je_source_name
39: AND ic.set_of_books_id = x_ledger_id
40: AND nvl(ic.group_id,-1) = nvl(x_group_id, -1)

Line 74: FROM GL_JE_SOURCES s, GL_INTERFACE_CONTROL ic

70: FUNCTION used_in_alternate_table(
71: x_int_je_source_name VARCHAR2) RETURN VARCHAR2 IS
72: CURSOR chk_usage is
73: SELECT 'Other table'
74: FROM GL_JE_SOURCES s, GL_INTERFACE_CONTROL ic
75: WHERE ( ( s.user_je_source_name = x_int_je_source_name
76: AND s.import_using_key_flag = 'N')
77: OR ( s.je_source_key = x_int_je_source_name
78: AND s.import_using_key_flag = 'Y'))

Line 102: 'gl_interface_control_pkg.used_in_alternate_table');

98: RAISE;
99: WHEN OTHERS THEN
100: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
101: fnd_message.set_token('PROCEDURE',
102: 'gl_interface_control_pkg.used_in_alternate_table');
103: RAISE;
104: END used_in_alternate_table;
105:
106: FUNCTION get_interface_table(

Line 111: FROM GL_JE_SOURCES s, GL_INTERFACE_CONTROL ic

107: x_int_je_source_name VARCHAR2,
108: x_group_id NUMBER) RETURN VARCHAR2 IS
109: CURSOR get_table is
110: SELECT interface_table_name
111: FROM GL_JE_SOURCES s, GL_INTERFACE_CONTROL ic
112: WHERE ( ( s.user_je_source_name = x_int_je_source_name
113: AND s.import_using_key_flag = 'N')
114: OR ( s.je_source_key = x_int_je_source_name
115: AND s.import_using_key_flag = 'Y'))

Line 139: 'gl_interface_control_pkg.get_interface_table');

135: RAISE;
136: WHEN OTHERS THEN
137: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
138: fnd_message.set_token('PROCEDURE',
139: 'gl_interface_control_pkg.get_interface_table');
140: RAISE;
141: END get_interface_table;
142:
143: PROCEDURE insert_row(xinterface_run_id NUMBER,

Line 150: FROM gl_interface_control

146: xgroup_id NUMBER,
147: xpacket_id NUMBER DEFAULT NULL) IS
148: CURSOR C IS
149: SELECT rowid
150: FROM gl_interface_control
151: WHERE interface_run_id = xinterface_run_id
152: AND je_source_name = xje_source_name
153: AND set_of_books_id = xledger_id
154: AND nvl(group_id, -1) = nvl(xgroup_id, -1);

Line 160: INSERT INTO gl_interface_control(

156: X_Rowid VARCHAR2(18);
157: BEGIN
158:
159: -- Do the insert
160: INSERT INTO gl_interface_control(
161: interface_run_id,
162: je_source_name,
163: set_of_books_id,
164: group_id,

Line 185: END gl_interface_control_pkg;

181: end if;
182: CLOSE C;
183: END insert_row;
184:
185: END gl_interface_control_pkg;