DBA Data[Home] [Help]

APPS.ARI_DB_UTILITIES dependencies on FND_GLOBAL

Line 558: and AcctSites.user_id=FND_GLOBAL.USER_ID()

554: from ar_payment_schedules ps,
555: ar_irec_user_acct_sites_all AcctSites,
556: ra_customer_trx ct
557: where ps.status = 'OP'
558: and AcctSites.user_id=FND_GLOBAL.USER_ID()
559: and AcctSites.customer_id=ps.customer_id
560: and AcctSites.customer_site_use_id=ps.customer_site_use_id
561: and AcctSites.session_id=p_session_id
562: and AcctSites.customer_id= p_customer_id

Line 715: and AcctSites.user_id=FND_GLOBAL.USER_ID()

711: from ar_payment_schedules ps,
712: ar_irec_user_acct_sites_all AcctSites,
713: ra_customer_trx ct
714: where ps.status = 'OP'
715: and AcctSites.user_id=FND_GLOBAL.USER_ID()
716: and AcctSites.customer_id=ps.customer_id
717: and AcctSites.customer_site_use_id=ps.customer_site_use_id
718: and AcctSites.session_id=p_session_id
719: and AcctSites.org_id = ps.org_id

Line 1087: l_created_by := FND_GLOBAL.USER_ID;

1083:
1084: AR_BPA_PRINT_CONC.process_print_request(p_id_list, x_req_id_list, p_list_type, p_description,l_template_id);
1085: l_req_id_list := x_req_id_list;
1086:
1087: l_created_by := FND_GLOBAL.USER_ID;
1088: l_creation_date := sysdate;
1089: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1090: l_last_update_date := sysdate;
1091: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 1089: l_last_update_login := FND_GLOBAL.LOGIN_ID;

1085: l_req_id_list := x_req_id_list;
1086:
1087: l_created_by := FND_GLOBAL.USER_ID;
1088: l_creation_date := sysdate;
1089: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1090: l_last_update_date := sysdate;
1091: l_last_updated_by := FND_GLOBAL.USER_ID;
1092:
1093: if(x_req_id_list <> '0') then

Line 1091: l_last_updated_by := FND_GLOBAL.USER_ID;

1087: l_created_by := FND_GLOBAL.USER_ID;
1088: l_creation_date := sysdate;
1089: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1090: l_last_update_date := sysdate;
1091: l_last_updated_by := FND_GLOBAL.USER_ID;
1092:
1093: if(x_req_id_list <> '0') then
1094:
1095: loop

Line 1176: -- Initialize FND Global

1172: l_server_id number(15);
1173: l_security_group_id NUMBER(15);
1174:
1175: BEGIN
1176: -- Initialize FND Global
1177: FND_MSG_PUB.INITIALIZE;
1178:
1179: l_created_by := FND_GLOBAL.USER_ID;
1180: l_creation_date := sysdate;

Line 1179: l_created_by := FND_GLOBAL.USER_ID;

1175: BEGIN
1176: -- Initialize FND Global
1177: FND_MSG_PUB.INITIALIZE;
1178:
1179: l_created_by := FND_GLOBAL.USER_ID;
1180: l_creation_date := sysdate;
1181: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1182: l_last_update_date := sysdate;
1183: l_last_updated_by := FND_GLOBAL.USER_ID;

Line 1181: l_last_update_login := FND_GLOBAL.LOGIN_ID;

1177: FND_MSG_PUB.INITIALIZE;
1178:
1179: l_created_by := FND_GLOBAL.USER_ID;
1180: l_creation_date := sysdate;
1181: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1182: l_last_update_date := sysdate;
1183: l_last_updated_by := FND_GLOBAL.USER_ID;
1184:
1185: /* Get the environment set up and profiles set for logging */

Line 1183: l_last_updated_by := FND_GLOBAL.USER_ID;

1179: l_created_by := FND_GLOBAL.USER_ID;
1180: l_creation_date := sysdate;
1181: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1182: l_last_update_date := sysdate;
1183: l_last_updated_by := FND_GLOBAL.USER_ID;
1184:
1185: /* Get the environment set up and profiles set for logging */
1186: select application_id, responsibility_id, responsibility_name
1187: into appl_id, resp_id, resp_name

Line 1196: l_server_id := FND_GLOBAL.server_id;

1192: into user_id, user_name
1193: from fnd_user
1194: where user_name = p_user_name;
1195:
1196: l_server_id := FND_GLOBAL.server_id;
1197: l_security_group_id := FND_GLOBAL.security_group_id;
1198:
1199: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1200: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME, 'oir_print_selected_invoices, l_server_id = ' || l_server_id||' l_security_group_id = '||l_security_group_id);

Line 1197: l_security_group_id := FND_GLOBAL.security_group_id;

1193: from fnd_user
1194: where user_name = p_user_name;
1195:
1196: l_server_id := FND_GLOBAL.server_id;
1197: l_security_group_id := FND_GLOBAL.security_group_id;
1198:
1199: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1200: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME, 'oir_print_selected_invoices, l_server_id = ' || l_server_id||' l_security_group_id = '||l_security_group_id);
1201: end if;

Line 1203: fnd_global.apps_initialize(user_id, resp_id, appl_id, l_security_group_id, l_server_id);

1199: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1200: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME, 'oir_print_selected_invoices, l_server_id = ' || l_server_id||' l_security_group_id = '||l_security_group_id);
1201: end if;
1202:
1203: fnd_global.apps_initialize(user_id, resp_id, appl_id, l_security_group_id, l_server_id);
1204: fnd_log_repository.init;
1205: fnd_request.set_org_id(p_org_id);
1206:
1207: -- arp_global.init_global;