DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on FND_GLOBAL

Line 505: l_user_id := nvl(fnd_global.user_id, 0) ;

501:
502: -- initialize return status
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505: l_user_id := nvl(fnd_global.user_id, 0) ;
506: fnd_profile.get('RESP_ID',orig_resp_id);
507: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
508:
509: BEGIN

Line 607: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);

603:
604: IF new_resp_id is not null and
605: new_user_id is not null and
606: new_resp_appl_id is not null THEN
607: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
608: mo_global.set_policy_context('S',l_source_operating_unit);
609: ELSE
610: --dbms_application_info.set_client_info(l_source_operating_unit);
611: mo_global.set_policy_context('S',l_source_operating_unit);

Line 691: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);

687:
688: IF new_resp_id is not null and
689: new_user_id is not null and
690: new_resp_appl_id is not null THEN
691: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
692: mo_global.set_policy_context('S',l_source_operating_unit);
693: ELSE
694: --dbms_application_info.set_client_info(l_source_operating_unit);
695: mo_global.set_policy_context('S',l_source_operating_unit);

Line 815: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);

811: oe_debug_pub.debug_off;
812: end if;
813:
814: IF (l_source_operating_unit <> l_org_id) THEN
815: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);
816: mo_global.set_policy_context('S',l_org_id);
817: END If;
818:
819: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 880: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);

876: IF (p_header_rec.order_header_id IS NOT NULL) THEN
877: IF (l_source_operating_unit <> l_org_id) THEN
878: IF new_resp_id is not null and
879: new_resp_appl_id is not null THEN
880: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
881: ELSE
882: --dbms_application_info.set_client_info(l_source_operating_unit);
883: mo_global.set_policy_context('S',l_source_operating_unit);
884: END IF;

Line 974: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);

970: oe_debug_pub.debug_off;
971: end if;
972:
973: IF (l_source_operating_unit <> l_org_id) THEN
974: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);
975: mo_global.set_policy_context('S',l_org_id);
976: END If;
977:
978: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1620: l_user_id := nvl(fnd_global.user_id, 0) ;

1616:
1617: -- initialize return status
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619:
1620: l_user_id := nvl(fnd_global.user_id, 0) ;
1621: fnd_profile.get('RESP_ID',orig_resp_id);
1622: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
1623:
1624: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1653: l_user_id := nvl(fnd_global.user_id, 0) ;

1649: end if;
1650:
1651: -- get all the values required to insert into po_requisition_header table
1652: SELECT Sysdate INTO l_today FROM dual;
1653: l_user_id := nvl(fnd_global.user_id, 0) ;
1654: l_login_id := nvl(fnd_global.login_id, -1);
1655:
1656: -- operating unit
1657: BEGIN

Line 1654: l_login_id := nvl(fnd_global.login_id, -1);

1650:
1651: -- get all the values required to insert into po_requisition_header table
1652: SELECT Sysdate INTO l_today FROM dual;
1653: l_user_id := nvl(fnd_global.user_id, 0) ;
1654: l_login_id := nvl(fnd_global.login_id, -1);
1655:
1656: -- operating unit
1657: BEGIN
1658: /*SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))

Line 2129: fnd_global.user_id,

2125: 'REQUISITION',
2126: 'INTERNAL',
2127: 0,
2128: sysdate,
2129: fnd_global.user_id,
2130: sysdate,
2131: fnd_global.user_id,
2132: 'SUBMIT',
2133: sysdate,

Line 2131: fnd_global.user_id,

2127: 0,
2128: sysdate,
2129: fnd_global.user_id,
2130: sysdate,
2131: fnd_global.user_id,
2132: 'SUBMIT',
2133: sysdate,
2134: l_employee_id,
2135: null,

Line 2137: fnd_global.login_id,

2133: sysdate,
2134: l_employee_id,
2135: null,
2136: null,
2137: fnd_global.login_id,
2138: 0,
2139: 0,
2140: 0,
2141: '',

Line 2178: fnd_global.user_id,

2174: 'REQUISITION',
2175: 'INTERNAL',
2176: 1,
2177: sysdate,
2178: fnd_global.user_id,
2179: sysdate,
2180: fnd_global.user_id,
2181: 'APPROVE',
2182: sysdate,

Line 2180: fnd_global.user_id,

2176: 1,
2177: sysdate,
2178: fnd_global.user_id,
2179: sysdate,
2180: fnd_global.user_id,
2181: 'APPROVE',
2182: sysdate,
2183: l_employee_id,
2184: null,

Line 2186: fnd_global.login_id,

2182: sysdate,
2183: l_employee_id,
2184: null,
2185: null,
2186: fnd_global.login_id,
2187: 0,
2188: 0,
2189: 0,
2190: '',

Line 3854: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);

3850:
3851: IF new_resp_id is not null and
3852: new_user_id is not null and
3853: new_resp_appl_id is not null THEN
3854: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
3855: mo_global.set_policy_context('S', l_source_operating_unit);
3856: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.
3857: IF l_source_operating_unit <> new_org_id THEN
3858: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_NOT_MATCH'); --to be seeded.

Line 4149: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);

4145: end if;
4146:
4147: -- dbms_application_info.set_client_info(l_org_id);
4148: --IF (l_source_operating_unit <> l_org_id) THEN
4149: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);
4150:
4151: if l_first_org_id is not null then
4152: mo_global.set_org_context(l_first_org_id,null,'CSF');
4153: end if;

Line 4421: l_user_id := nvl(fnd_global.user_id, 0) ;

4417: l_line_tbl := px_line_table;
4418:
4419: -- Get data for populating who columns
4420: SELECT Sysdate INTO l_today FROM dual;
4421: l_user_id := nvl(fnd_global.user_id, 0) ;
4422: l_login_id := nvl(fnd_global.login_id, -1);
4423:
4424: -- operating unit
4425: -- changed for bug 11847583

Line 4422: l_login_id := nvl(fnd_global.login_id, -1);

4418:
4419: -- Get data for populating who columns
4420: SELECT Sysdate INTO l_today FROM dual;
4421: l_user_id := nvl(fnd_global.user_id, 0) ;
4422: l_login_id := nvl(fnd_global.login_id, -1);
4423:
4424: -- operating unit
4425: -- changed for bug 11847583
4426: BEGIN