DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on FND_GLOBAL

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

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

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

565: CLOSE get_new_context;
566:
567: IF new_resp_id is not null and
568: new_resp_appl_id is not null THEN
569: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
570: ELSE
571: dbms_application_info.set_client_info(l_source_operating_unit);
572: END IF;
573: END If;

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

632: CLOSE get_new_context;
633:
634: IF new_resp_id is not null and
635: new_resp_appl_id is not null THEN
636: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
637: ELSE
638: dbms_application_info.set_client_info(l_source_operating_unit);
639: END IF;
640: END If;

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

734: ,x_msg_data => l_msg_data
735: );
736:
737: IF (l_source_operating_unit <> l_org_id) THEN
738: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);
739: END If;
740:
741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742: for counter in REVERSE 1..l_msg_count Loop

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

797: IF (p_header_rec.order_header_id IS NOT NULL) THEN
798: IF (l_source_operating_unit <> l_org_id) THEN
799: IF new_resp_id is not null and
800: new_resp_appl_id is not null THEN
801: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
802: ELSE
803: dbms_application_info.set_client_info(l_source_operating_unit);
804: END IF;
805: END If;

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

869: ,x_msg_data => l_msg_data
870: );
871:
872: IF (l_source_operating_unit <> l_org_id) THEN
873: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);
874: END If;
875:
876: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
877: for counter in REVERSE 1..l_msg_count Loop

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

1274:
1275: -- initialize return status
1276: x_return_status := FND_API.G_RET_STS_SUCCESS;
1277:
1278: l_user_id := nvl(fnd_global.user_id, 0) ;
1279: fnd_profile.get('RESP_ID',orig_resp_id);
1280: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
1281:
1282: l_header_rec := px_header_rec;

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

1287: END IF;
1288:
1289: -- get all the values required to insert into po_requisition_header table
1290: SELECT Sysdate INTO l_today FROM dual;
1291: l_user_id := nvl(fnd_global.user_id, 0) ;
1292: l_login_id := nvl(fnd_global.login_id, -1);
1293:
1294: -- operating unit
1295: BEGIN

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

1288:
1289: -- get all the values required to insert into po_requisition_header table
1290: SELECT Sysdate INTO l_today FROM dual;
1291: l_user_id := nvl(fnd_global.user_id, 0) ;
1292: l_login_id := nvl(fnd_global.login_id, -1);
1293:
1294: -- operating unit
1295: BEGIN
1296: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))

Line 1650: fnd_global.user_id,

1646: 'REQUISITION',
1647: 'INTERNAL',
1648: 0,
1649: sysdate,
1650: fnd_global.user_id,
1651: sysdate,
1652: fnd_global.user_id,
1653: 'SUBMIT',
1654: sysdate,

Line 1652: fnd_global.user_id,

1648: 0,
1649: sysdate,
1650: fnd_global.user_id,
1651: sysdate,
1652: fnd_global.user_id,
1653: 'SUBMIT',
1654: sysdate,
1655: l_employee_id,
1656: null,

Line 1658: fnd_global.login_id,

1654: sysdate,
1655: l_employee_id,
1656: null,
1657: null,
1658: fnd_global.login_id,
1659: 0,
1660: 0,
1661: 0,
1662: '',

Line 1699: fnd_global.user_id,

1695: 'REQUISITION',
1696: 'INTERNAL',
1697: 1,
1698: sysdate,
1699: fnd_global.user_id,
1700: sysdate,
1701: fnd_global.user_id,
1702: 'APPROVE',
1703: sysdate,

Line 1701: fnd_global.user_id,

1697: 1,
1698: sysdate,
1699: fnd_global.user_id,
1700: sysdate,
1701: fnd_global.user_id,
1702: 'APPROVE',
1703: sysdate,
1704: l_employee_id,
1705: null,

Line 1707: fnd_global.login_id,

1703: sysdate,
1704: l_employee_id,
1705: null,
1706: null,
1707: fnd_global.login_id,
1708: 0,
1709: 0,
1710: 0,
1711: '',

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

2576: end if;
2577:
2578: IF new_resp_id is not null and
2579: new_resp_appl_id is not null THEN
2580: fnd_global.apps_initialize(new_user_id,new_resp_id,new_resp_appl_id);
2581: mo_global.set_org_context(l_source_operating_unit,null,'CSF');
2582: /* fnd_profile.get('ORG_ID',new_org_id); --Operating Unit for the new context.
2583: IF l_source_operating_unit <> new_org_id THEN
2584: FND_MESSAGE.Set_Name('CS','CS_CHG_NEW_CONTEXT_OU_NOT_MATCH'); --to be seeded.

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

2683: );
2684: END IF;
2685: -- dbms_application_info.set_client_info(l_org_id);
2686: IF (l_source_operating_unit <> l_org_id) THEN
2687: fnd_global.apps_initialize(l_user_id,orig_resp_id,orig_resp_appl_id);
2688: mo_global.set_org_context(l_org_id,null,'CSF');
2689:
2690: END If;
2691:

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

2925: l_line_tbl := px_line_table;
2926:
2927: -- Get data for populating who columns
2928: SELECT Sysdate INTO l_today FROM dual;
2929: l_user_id := nvl(fnd_global.user_id, 0) ;
2930: l_login_id := nvl(fnd_global.login_id, -1);
2931:
2932: -- operating unit
2933: BEGIN

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

2926:
2927: -- Get data for populating who columns
2928: SELECT Sysdate INTO l_today FROM dual;
2929: l_user_id := nvl(fnd_global.user_id, 0) ;
2930: l_login_id := nvl(fnd_global.login_id, -1);
2931:
2932: -- operating unit
2933: BEGIN
2934: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))