97: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
98: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
99: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
100: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
101: /*Bug 13241358/12881115: instead of using fnd_global.org_id use
102: po_moac_utils_pvt.get_current_org_id*/
103: );
104: ELSIF p_caller = 'PO_MOD' OR p_caller = 'PO' THEN
105: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
105: l_context := EGO_COL_NAME_VALUE_PAIR_ARRAY(
106: EGO_COL_NAME_VALUE_PAIR_OBJ('DOCUMENT_TYPE', p_context_usage),
107: EGO_COL_NAME_VALUE_PAIR_OBJ('ISSUING_ORG_OWNED', l_source_org_owned),
108: EGO_COL_NAME_VALUE_PAIR_OBJ('ORG_ID', To_Char(l_org_id))
109: /*Bug 13241358/12881115: instead of using fnd_global.org_id use
110: po_moac_utils_pvt.get_current_org_id*/
111: );
112: END IF;
113:
2257: INTO x_dodaac
2258: FROM per_people_extra_info pei, fnd_user fu
2259: WHERE pei.information_type = 'CLM_CONTACT_TITLE'
2260: AND pei.person_id= fu.employee_id
2261: AND fu.user_id = fnd_global.user_id;
2262: EXCEPTION
2263: WHEN No_Data_Found THEN
2264: x_dodaac:='';
2265: fnd_message.set_name('PO', 'PO_CLM_DEFAULT_DODAAC_ND');
2810: INTO x_dodaac
2811: FROM per_people_extra_info pei, fnd_user fu
2812: WHERE pei.information_type = 'CLM_CONTACT_TITLE'
2813: AND pei.person_id= fu.employee_id
2814: AND fu.user_id = fnd_global.user_id;
2815: EXCEPTION
2816: WHEN No_Data_Found THEN
2817: x_return_status := FND_API.G_RET_STS_ERROR;
2818: x_errorcode := '-1';
3853: INTO x_call_order_number
3854: FROM per_people_extra_info pei, fnd_user fu
3855: WHERE pei.information_type = 'CLM_CONTACT_TITLE'
3856: AND pei.person_id= fu.employee_id
3857: AND fu.user_id = fnd_global.user_id;
3858: EXCEPTION
3859: WHEN No_Data_Found THEN
3860: x_call_order_number:='';
3861: END;
5191: INTO l_user_def_dodaac
5192: FROM per_people_extra_info pei, fnd_user fu
5193: WHERE pei.information_type = 'CLM_CONTACT_TITLE'
5194: AND pei.person_id= fu.employee_id
5195: AND fu.user_id = fnd_global.user_id;
5196: EXCEPTION
5197: WHEN OTHERS THEN
5198: RETURN 'N';
5199: END;