APPS.GL_PERIOD_STATUS_SYNC_PUB dependencies on GL_LEDGERS

Line 30: | p_ledger_short_name IN short_name from gl_ledgers table. |

26: | PROCEDURE period_status_sync |
27: | |
28: | PARAMETER DESCRIPTION |
29: | --------------------- |
30: | p_ledger_short_name IN short_name from gl_ledgers table. |
31: | p_start_date IN start_date of the period from gl_period_statuses |
32: | p_end_date IN end_date of the period from gl_period_statuses |
33: | errbuf OUT Default out parameter to capture error message |
34: | retcode OUT Default out parameter to capture error code |

Line 65: FROM gl_ledgers

61: c_relationship_enabled_flag VARCHAR2
62: )
63: IS
64: SELECT *
65: FROM gl_ledgers
66: WHERE ledger_id IN (
67: SELECT gll2.ledger_id
68: FROM gl_ledgers gll1,
69: gl_ledgers gll2,

Line 68: FROM gl_ledgers gll1,

64: SELECT *
65: FROM gl_ledgers
66: WHERE ledger_id IN (
67: SELECT gll2.ledger_id
68: FROM gl_ledgers gll1,
69: gl_ledgers gll2,
70: gl_ledger_relationships glrs
71: WHERE gll1.short_name = c_ledger_short_name
72: AND glrs.primary_ledger_id = gll1.ledger_id

Line 69: gl_ledgers gll2,

65: FROM gl_ledgers
66: WHERE ledger_id IN (
67: SELECT gll2.ledger_id
68: FROM gl_ledgers gll1,
69: gl_ledgers gll2,
70: gl_ledger_relationships glrs
71: WHERE gll1.short_name = c_ledger_short_name
72: AND glrs.primary_ledger_id = gll1.ledger_id
73: AND gll2.object_type_code = c_object_type_code

Line 131: FROM gl_ledgers

127: IS
128: SELECT 'Y'
129: FROM DUAL
130: WHERE EXISTS (SELECT short_name
131: FROM gl_ledgers
132: WHERE short_name = p_ledger_short_name);
133:
134: --Cursor to fetch the start_date
135: CURSOR c_start_date (

Line 145: FROM gl_period_statuses gps, gl_ledgers gl

141: SELECT 'Y'
142: FROM DUAL
143: WHERE EXISTS (
144: SELECT 1
145: FROM gl_period_statuses gps, gl_ledgers gl
146: WHERE gl.ledger_id = gps.ledger_id
147: AND gps.application_id = c_application_id
148: AND gl.short_name = c_ledger_short_name
149: AND gps.start_date = c_start_date);

Line 162: FROM gl_period_statuses gps, gl_ledgers gl

158: SELECT 'Y'
159: FROM DUAL
160: WHERE EXISTS (
161: SELECT 1
162: FROM gl_period_statuses gps, gl_ledgers gl
163: WHERE gl.ledger_id = gps.ledger_id
164: AND gps.application_id = c_application_id
165: AND gl.short_name = c_ledger_short_name
166: AND gps.end_date = c_end_date);

Line 196: l_rec_type gl_ledgers%ROWTYPE;

192: l_con_status VARCHAR2 (30);
193: l_process_status_msg VARCHAR2 (1000);
194: l_be_message VARCHAR2 (1000);
195: l_business_event_type VARCHAR2 (30);
196: l_rec_type gl_ledgers%ROWTYPE;
197: l_start_date VARCHAR2 (1);
198: l_end_date VARCHAR2 (1);
199: BEGIN
200: --Initializing Concurrent Parameteres