DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on FND_GLOBAL

Line 251: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);

247: aname => 'RESPONSIBILITY_ID',
248: avalue => l_responsibility_id);
249:
250: /* Set the context for the doc manager */
251: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
252: end if;
253:
254: IF (g_asn_debug = 'Y') THEN
255: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 900: p_user_id => fnd_global.user_id ,

896: p_request_id => 0,
897: p_program_application_id => 0,
898: p_program_id =>0 ,
899: p_program_date => sysdate ,
900: p_user_id => fnd_global.user_id ,
901: p_login_id => fnd_global.login_id);
902:
903: ELSE --}{
904: l_sequence_num := l_sequence_num - 1;

Line 901: p_login_id => fnd_global.login_id);

897: p_program_application_id => 0,
898: p_program_id =>0 ,
899: p_program_date => sysdate ,
900: p_user_id => fnd_global.user_id ,
901: p_login_id => fnd_global.login_id);
902:
903: ELSE --}{
904: l_sequence_num := l_sequence_num - 1;
905:

Line 919: p_user_id => fnd_global.user_id ,

915: p_object_type_code =>'WC',
916: p_employee_id => null, --l_wc_preparer_id,
917: p_sequence_num => l_sequence_num,
918: p_action_code => 'SUBMIT',
919: p_user_id => fnd_global.user_id ,
920: p_login_id =>fnd_global.login_id );
921:
922: END IF; --}
923:

Line 920: p_login_id =>fnd_global.login_id );

916: p_employee_id => null, --l_wc_preparer_id,
917: p_sequence_num => l_sequence_num,
918: p_action_code => 'SUBMIT',
919: p_user_id => fnd_global.user_id ,
920: p_login_id =>fnd_global.login_id );
921:
922: END IF; --}
923:
924: /* Insert the null action code*/

Line 948: p_user_id => fnd_global.user_id ,

944: p_request_id => 0,
945: p_program_application_id => 0,
946: p_program_id =>0 ,
947: p_program_date => sysdate ,
948: p_user_id => fnd_global.user_id ,
949: p_login_id => fnd_global.login_id); */
950:
951:
952:

Line 949: p_login_id => fnd_global.login_id); */

945: p_program_application_id => 0,
946: p_program_id =>0 ,
947: p_program_date => sysdate ,
948: p_user_id => fnd_global.user_id ,
949: p_login_id => fnd_global.login_id); */
950:
951:
952:
953:

Line 1520: p_user_id => fnd_global.user_id,

1516: p_object_type_code => Recinfo.object_type_code,
1517: p_employee_id => Recinfo.employee_id,
1518: p_action_code => 'FORWARD',
1519: p_note => NULL,
1520: p_user_id => fnd_global.user_id,
1521: p_login_id => fnd_global.login_id);
1522:
1523:
1524: End if;

Line 1521: p_login_id => fnd_global.login_id);

1517: p_employee_id => Recinfo.employee_id,
1518: p_action_code => 'FORWARD',
1519: p_note => NULL,
1520: p_user_id => fnd_global.user_id,
1521: p_login_id => fnd_global.login_id);
1522:
1523:
1524: End if;
1525:

Line 1555: p_user_id => fnd_global.user_id ,

1551: p_request_id => Recinfo.request_id,
1552: p_program_application_id => Recinfo.program_application_id,
1553: p_program_id =>Recinfo.program_id ,
1554: p_program_date => Recinfo.program_date ,
1555: p_user_id => fnd_global.user_id ,
1556: p_login_id => fnd_global.login_id);
1557:
1558: End if;--}
1559:

Line 1556: p_login_id => fnd_global.login_id);

1552: p_program_application_id => Recinfo.program_application_id,
1553: p_program_id =>Recinfo.program_id ,
1554: p_program_date => Recinfo.program_date ,
1555: p_user_id => fnd_global.user_id ,
1556: p_login_id => fnd_global.login_id);
1557:
1558: End if;--}
1559:
1560:

Line 1950: avalue => fnd_global.USER_ID);

1946:
1947: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1948: itemkey => p_itemkey,
1949: aname => 'RESPONDER_USER_ID',
1950: avalue => fnd_global.USER_ID);
1951:
1952: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1953: itemkey => p_itemkey,
1954: aname => 'RESPONDER_RESP_ID',

Line 1955: avalue => fnd_global.RESP_ID);

1951:
1952: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1953: itemkey => p_itemkey,
1954: aname => 'RESPONDER_RESP_ID',
1955: avalue => fnd_global.RESP_ID);
1956:
1957: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1958: itemkey => p_itemkey,
1959: aname => 'RESPONDER_APPL_ID',

Line 1960: avalue => fnd_global.RESP_APPL_ID);

1956:
1957: wf_engine.SetItemAttrNumber ( itemtype => p_itemType,
1958: itemkey => p_itemkey,
1959: aname => 'RESPONDER_APPL_ID',
1960: avalue => fnd_global.RESP_APPL_ID);
1961:
1962: OPEN c_group_id(p_itemtype, p_itemkey, 'WC_APPROVE');
1963:
1964: FETCH c_group_id INTO l_group_id;

Line 2656: p_user_id => fnd_global.user_id ,

2652: p_request_id => Recinfo.request_id,
2653: p_program_application_id => Recinfo.program_application_id,
2654: p_program_id =>Recinfo.program_id ,
2655: p_program_date => Recinfo.program_date ,
2656: p_user_id => fnd_global.user_id ,
2657: p_login_id => fnd_global.login_id);
2658:
2659:
2660: end if; --}

Line 2657: p_login_id => fnd_global.login_id);

2653: p_program_application_id => Recinfo.program_application_id,
2654: p_program_id =>Recinfo.program_id ,
2655: p_program_date => Recinfo.program_date ,
2656: p_user_id => fnd_global.user_id ,
2657: p_login_id => fnd_global.login_id);
2658:
2659:
2660: end if; --}
2661:

Line 2693: p_user_id => fnd_global.user_id,

2689: p_object_type_code => Recinfo.object_type_code,
2690: p_employee_id => p_more_info_id,
2691: p_action_code => 'NO ACTION',
2692: p_note => NULL,
2693: p_user_id => fnd_global.user_id,
2694: p_login_id => fnd_global.login_id);
2695:
2696:
2697:

Line 2694: p_login_id => fnd_global.login_id);

2690: p_employee_id => p_more_info_id,
2691: p_action_code => 'NO ACTION',
2692: p_note => NULL,
2693: p_user_id => fnd_global.user_id,
2694: p_login_id => fnd_global.login_id);
2695:
2696:
2697:
2698: /*

Line 2720: p_user_id => fnd_global.user_id ,

2716: p_request_id => Recinfo.request_id,
2717: p_program_application_id => Recinfo.program_application_id,
2718: p_program_id =>Recinfo.program_id ,
2719: p_program_date => Recinfo.program_date ,
2720: p_user_id => fnd_global.user_id ,
2721: p_login_id => fnd_global.login_id);
2722:
2723:
2724: end if; --}

Line 2721: p_login_id => fnd_global.login_id);

2717: p_program_application_id => Recinfo.program_application_id,
2718: p_program_id =>Recinfo.program_id ,
2719: p_program_date => Recinfo.program_date ,
2720: p_user_id => fnd_global.user_id ,
2721: p_login_id => fnd_global.login_id);
2722:
2723:
2724: end if; --}
2725:

Line 2749: p_user_id => fnd_global.user_id,

2745: p_object_type_code => Recinfo.object_type_code,
2746: p_employee_id => Recinfo.employee_id,
2747: p_action_code => p_action_code,
2748: p_note =>substrb(p_comments,1,4000),
2749: p_user_id => fnd_global.user_id,
2750: p_login_id => fnd_global.login_id);
2751:
2752:
2753: END IF;

Line 2750: p_login_id => fnd_global.login_id);

2746: p_employee_id => Recinfo.employee_id,
2747: p_action_code => p_action_code,
2748: p_note =>substrb(p_comments,1,4000),
2749: p_user_id => fnd_global.user_id,
2750: p_login_id => fnd_global.login_id);
2751:
2752:
2753: END IF;
2754:

Line 2872: WHERE FND.USER_ID = NVL(p_user_id, fnd_global.user_id)

2868:
2869: SELECT HR.EMPLOYEE_ID
2870: INTO l_employee_id
2871: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
2872: WHERE FND.USER_ID = NVL(p_user_id, fnd_global.user_id)
2873: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID;
2874: IF (g_asn_debug = 'Y') THEN
2875: debug_log(FND_LOG.LEVEL_STATEMENT,
2876: l_api_name,'l_employee_id '

Line 3201: p_user_id => fnd_global.user_id,

3197: p_object_type_code => Recinfo.object_type_code,
3198: p_employee_id => Recinfo.employee_id,
3199: p_action_code => l_action,
3200: p_note => wf_engine.context_user_comment,
3201: p_user_id => fnd_global.user_id,
3202: p_login_id => fnd_global.login_id);
3203:
3204:
3205: InsertPOActionHistory( p_object_id => Recinfo.object_id,

Line 3202: p_login_id => fnd_global.login_id);

3198: p_employee_id => Recinfo.employee_id,
3199: p_action_code => l_action,
3200: p_note => wf_engine.context_user_comment,
3201: p_user_id => fnd_global.user_id,
3202: p_login_id => fnd_global.login_id);
3203:
3204:
3205: InsertPOActionHistory( p_object_id => Recinfo.object_id,
3206: p_object_type_code=>Recinfo.object_type_code,

Line 3220: p_user_id => fnd_global.user_id ,

3216: p_request_id => Recinfo.request_id,
3217: p_program_application_id => Recinfo.program_application_id,
3218: p_program_id =>Recinfo.program_id ,
3219: p_program_date => Recinfo.program_date ,
3220: p_user_id => fnd_global.user_id ,
3221: p_login_id => fnd_global.login_id);
3222:
3223: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
3224: return;

Line 3221: p_login_id => fnd_global.login_id);

3217: p_program_application_id => Recinfo.program_application_id,
3218: p_program_id =>Recinfo.program_id ,
3219: p_program_date => Recinfo.program_date ,
3220: p_user_id => fnd_global.user_id ,
3221: p_login_id => fnd_global.login_id);
3222:
3223: x_resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
3224: return;
3225: end if;

Line 3288: l_session_user_id := fnd_global.user_id;

3284: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_responder_id ' ||l_responder_id);
3285: END IF;
3286: --
3287:
3288: l_session_user_id := fnd_global.user_id;
3289: l_session_resp_id := fnd_global.resp_id;
3290: l_session_appl_id := fnd_global.resp_appl_id;
3291:
3292: --

Line 3289: l_session_resp_id := fnd_global.resp_id;

3285: END IF;
3286: --
3287:
3288: l_session_user_id := fnd_global.user_id;
3289: l_session_resp_id := fnd_global.resp_id;
3290: l_session_appl_id := fnd_global.resp_appl_id;
3291:
3292: --
3293: IF (g_asn_debug = 'Y') THEN

Line 3290: l_session_appl_id := fnd_global.resp_appl_id;

3286: --
3287:
3288: l_session_user_id := fnd_global.user_id;
3289: l_session_resp_id := fnd_global.resp_id;
3290: l_session_appl_id := fnd_global.resp_appl_id;
3291:
3292: --
3293: IF (g_asn_debug = 'Y') THEN
3294: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,'l_session_user_id ' ||l_session_user_id);

Line 4488: fnd_global.user_id, --last_updated_by,

4484: (l_row_id,
4485: l_interface_id,--interface_id
4486: l_group_id, --group_id
4487: sysdate, --last_updated_date
4488: fnd_global.user_id, --last_updated_by,
4489: sysdate, --creation_date,
4490: fnd_global.login_id, --created_by,
4491: fnd_global.login_id, -- last_update_login,
4492: NULL, --request_id,

Line 4490: fnd_global.login_id, --created_by,

4486: l_group_id, --group_id
4487: sysdate, --last_updated_date
4488: fnd_global.user_id, --last_updated_by,
4489: sysdate, --creation_date,
4490: fnd_global.login_id, --created_by,
4491: fnd_global.login_id, -- last_update_login,
4492: NULL, --request_id,
4493: null, --program_application_id,
4494: null, --program_id,

Line 4491: fnd_global.login_id, -- last_update_login,

4487: sysdate, --last_updated_date
4488: fnd_global.user_id, --last_updated_by,
4489: sysdate, --creation_date,
4490: fnd_global.login_id, --created_by,
4491: fnd_global.login_id, -- last_update_login,
4492: NULL, --request_id,
4493: null, --program_application_id,
4494: null, --program_id,
4495: null, --program_update_date,

Line 4822: last_updated_by = fnd_global.user_id,

4818:
4819: update rcv_shipment_headers
4820: set receipt_num= l_receipt_num,
4821: last_update_date = sysdate,
4822: last_updated_by = fnd_global.user_id,
4823: last_update_login = fnd_global.login_id
4824: where shipment_header_id = l_shipment_header_id;
4825:
4826: IF (g_asn_debug = 'Y') THEN

Line 4823: last_update_login = fnd_global.login_id

4819: update rcv_shipment_headers
4820: set receipt_num= l_receipt_num,
4821: last_update_date = sysdate,
4822: last_updated_by = fnd_global.user_id,
4823: last_update_login = fnd_global.login_id
4824: where shipment_header_id = l_shipment_header_id;
4825:
4826: IF (g_asn_debug = 'Y') THEN
4827: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 5012: last_updated_by = fnd_global.user_id,

5008:
5009: UPDATE rcv_shipment_headers
5010: SET WF_ITEM_TYPE = p_itemtype,
5011: WF_ITEM_KEY = p_itemkey,
5012: last_updated_by = fnd_global.user_id,
5013: last_update_login = fnd_global.login_id,
5014: last_update_date = sysdate
5015: WHERE shipment_header_id = p_shipment_header_id;
5016:

Line 5013: last_update_login = fnd_global.login_id,

5009: UPDATE rcv_shipment_headers
5010: SET WF_ITEM_TYPE = p_itemtype,
5011: WF_ITEM_KEY = p_itemkey,
5012: last_updated_by = fnd_global.user_id,
5013: last_update_login = fnd_global.login_id,
5014: last_update_date = sysdate
5015: WHERE shipment_header_id = p_shipment_header_id;
5016:
5017:

Line 5563: l_session_user_id := fnd_global.user_id;

5559:
5560: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5561: itemkey => p_itemkey,
5562: aname => 'ORG_ID');
5563: l_session_user_id := fnd_global.user_id;
5564: l_session_resp_id := fnd_global.resp_id;
5565:
5566: IF (l_session_user_id = -1) THEN
5567: l_session_user_id := NULL;

Line 5564: l_session_resp_id := fnd_global.resp_id;

5560: l_org_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
5561: itemkey => p_itemkey,
5562: aname => 'ORG_ID');
5563: l_session_user_id := fnd_global.user_id;
5564: l_session_resp_id := fnd_global.resp_id;
5565:
5566: IF (l_session_user_id = -1) THEN
5567: l_session_user_id := NULL;
5568: END IF;

Line 5681: fnd_global.apps_initialize(l_user_id_to_set, l_resp_id_to_set,l_appl_id_to_set);

5677: END IF;
5678: --
5679: end if;
5680:
5681: fnd_global.apps_initialize(l_user_id_to_set, l_resp_id_to_set,l_appl_id_to_set);
5682:
5683: -- obvious place to make such a call, since we are using an apps_initialize,
5684: -- this is required since the responsibility might have a different OU attached
5685: -- than what is required.