DBA Data[Home] [Help]

APPS.BIL_DO_L1_BASE_GRP_PKG dependencies on FND_GLOBAL

Line 165: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();

161: *********************************************************************/
162: PROCEDURE Init_Globals IS
163:
164: BEGIN
165: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
166: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
167: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
168: G_user_id := FND_GLOBAL.USER_ID();
169: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();

Line 166: G_appl_id := FND_GLOBAL.PROG_APPL_ID();

162: PROCEDURE Init_Globals IS
163:
164: BEGIN
165: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
166: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
167: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
168: G_user_id := FND_GLOBAL.USER_ID();
169: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
170: END Init_Globals;

Line 167: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();

163:
164: BEGIN
165: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
166: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
167: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
168: G_user_id := FND_GLOBAL.USER_ID();
169: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
170: END Init_Globals;
171:

Line 168: G_user_id := FND_GLOBAL.USER_ID();

164: BEGIN
165: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
166: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
167: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
168: G_user_id := FND_GLOBAL.USER_ID();
169: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
170: END Init_Globals;
171:
172:

Line 169: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();

165: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
166: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
167: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
168: G_user_id := FND_GLOBAL.USER_ID();
169: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
170: END Init_Globals;
171:
172:
173:

Line 187: l_quote VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(39); -- single quote

183: l_level NUMBER := 1;
184:
185: l_insert_statement VARCHAR2(1000);
186: l_select_statement VARCHAR2(5000);
187: l_quote VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(39); -- single quote
188: l_parent_group VARCHAR2(50) := 'PARENT_GROUP';
189: l_sales VARCHAR2(20) := 'SALES';
190: l_stime DATE := sysdate;
191: BEGIN

Line 258: l_quote VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(39); -- single quote

254: l_sysdate DATE := sysdate;
255:
256: l_insert_statement VARCHAR2(1000);
257: l_select_statement VARCHAR2(5000);
258: l_quote VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(39); -- single quote
259: l_relation_type VARCHAR2(20) := 'PARENT_GROUP';
260: l_delete_flag_y VARCHAR2(1) := 'Y';
261: l_delete_flag_n VARCHAR2(1) := 'N';
262: l_sales VARCHAR2(20) := 'SALES';

Line 337: l_quote VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(39); -- single quote

333: l_sysdate DATE := sysdate;
334:
335: l_insert_statement VARCHAR2(1000);
336: l_select_statement VARCHAR2(5000);
337: l_quote VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(39); -- single quote
338: l_sales VARCHAR2(20) := 'SALES';
339: l_stime DATE := sysdate;
340: BEGIN
341: l_level := p_level + 1;