eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ASSIGNMENT_PVT dependencies on FND_GLOBAL

Line 277: fnd_global.user_id,

273: STATUS_CHANGE_COMMENTS
274: ) values (
275: l_assignment_log_id,
276: sysdate,
277: fnd_global.user_id,
278: sysdate,
279: fnd_global.user_id,
280: fnd_global.conc_login_id,
281: 1,

Line 279: fnd_global.user_id,

275: l_assignment_log_id,
276: sysdate,
277: fnd_global.user_id,
278: sysdate,
279: fnd_global.user_id,
280: fnd_global.conc_login_id,
281: 1,
282: p_assignment_log_rec.LEAD_ASSIGNMENT_ID,
283: p_assignment_log_rec.PARTNER_ID,

Line 280: fnd_global.conc_login_id,

276: sysdate,
277: fnd_global.user_id,
278: sysdate,
279: fnd_global.user_id,
280: fnd_global.conc_login_id,
281: 1,
282: p_assignment_log_rec.LEAD_ASSIGNMENT_ID,
283: p_assignment_log_rec.PARTNER_ID,
284: p_assignment_log_rec.ASSIGN_SEQUENCE,

Line 404: last_updated_by = FND_GLOBAL.user_id,

400: set resource_response = p_response,
401: response_date = sysdate,
402: object_version_number = object_version_number + 1,
403: last_update_date = sysdate,
404: last_updated_by = FND_GLOBAL.user_id,
405: last_update_login = FND_GLOBAL.login_id
406: where rowid = p_rowid
407: returning lead_assignment_id, resource_id
408: into l_lead_assignment_id, l_party_resource_id;

Line 405: last_update_login = FND_GLOBAL.login_id

401: response_date = sysdate,
402: object_version_number = object_version_number + 1,
403: last_update_date = sysdate,
404: last_updated_by = FND_GLOBAL.user_id,
405: last_update_login = FND_GLOBAL.login_id
406: where rowid = p_rowid
407: returning lead_assignment_id, resource_id
408: into l_lead_assignment_id, l_party_resource_id;
409:

Line 594: last_updated_by = FND_GLOBAL.user_id,

590: update pv_party_notifications
591: set notification_id = l_notify_id_tbl(j),
592: object_version_number = object_version_number + 1,
593: last_update_date = sysdate,
594: last_updated_by = FND_GLOBAL.user_id,
595: last_update_login = FND_GLOBAL.login_id
596: where party_notification_id = l_party_notify_id_tbl(j);
597:
598: end if;

Line 595: last_update_login = FND_GLOBAL.login_id

591: set notification_id = l_notify_id_tbl(j),
592: object_version_number = object_version_number + 1,
593: last_update_date = sysdate,
594: last_updated_by = FND_GLOBAL.user_id,
595: last_update_login = FND_GLOBAL.login_id
596: where party_notification_id = l_party_notify_id_tbl(j);
597:
598: end if;
599:

Line 711: AND a.user_id = fnd_global.user_id

707: SELECT notification_type
708: FROM pv_party_notifications a
709: WHERE a.wf_item_key = pc_wf_item_key
710: AND a.wf_item_type = pc_wf_item_type
711: AND a.user_id = fnd_global.user_id
712: AND a.notification_type= pv_assignment_pub.g_notify_type_matched_to;
713:
714: /*SELECT notification_type
715: FROM pv_party_notifications a, pv_assignment_logs c

Line 889: last_updated_by = FND_GLOBAL.user_id,

885: partner_access_code = l_partner_access_code,
886: related_party_access_code = decode(nvl(related_party_id,-999), -999, null, l_related_party_access_code),
887: object_version_number = object_version_number + 1,
888: last_update_date = sysdate,
889: last_updated_by = FND_GLOBAL.user_id,
890: last_update_login = FND_GLOBAL.login_id
891: where rowid = l_rowid;
892:
893: IF (SQL%NOTFOUND) THEN

Line 890: last_update_login = FND_GLOBAL.login_id

886: related_party_access_code = decode(nvl(related_party_id,-999), -999, null, l_related_party_access_code),
887: object_version_number = object_version_number + 1,
888: last_update_date = sysdate,
889: last_updated_by = FND_GLOBAL.user_id,
890: last_update_login = FND_GLOBAL.login_id
891: where rowid = l_rowid;
892:
893: IF (SQL%NOTFOUND) THEN
894: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

Line 969: OPEN lc_get_user_type (FND_GLOBAL.user_id);

965: l_oppty_routing_log_rec.event_date := p_status_date;
966: l_oppty_routing_log_rec.user_response := p_status;
967:
968: -- Setting Vendor and Partner User ID
969: OPEN lc_get_user_type (FND_GLOBAL.user_id);
970: FETCH lc_get_user_type INTO l_user_category;
971: CLOSE lc_get_user_type;
972:
973: IF l_user_category = PV_ASSIGNMENT_PUB.g_resource_employee THEN

Line 974: l_oppty_routing_log_rec.vendor_user_id := FND_GLOBAL.user_id;

970: FETCH lc_get_user_type INTO l_user_category;
971: CLOSE lc_get_user_type;
972:
973: IF l_user_category = PV_ASSIGNMENT_PUB.g_resource_employee THEN
974: l_oppty_routing_log_rec.vendor_user_id := FND_GLOBAL.user_id;
975: l_oppty_routing_log_rec.pt_contact_user_id := NULL;
976: ELSIF l_user_category = PV_ASSIGNMENT_PUB.g_resource_party THEN
977: l_oppty_routing_log_rec.vendor_user_id := NULL;
978: l_oppty_routing_log_rec.pt_contact_user_id := FND_GLOBAL.user_id;

Line 978: l_oppty_routing_log_rec.pt_contact_user_id := FND_GLOBAL.user_id;

974: l_oppty_routing_log_rec.vendor_user_id := FND_GLOBAL.user_id;
975: l_oppty_routing_log_rec.pt_contact_user_id := NULL;
976: ELSIF l_user_category = PV_ASSIGNMENT_PUB.g_resource_party THEN
977: l_oppty_routing_log_rec.vendor_user_id := NULL;
978: l_oppty_routing_log_rec.pt_contact_user_id := FND_GLOBAL.user_id;
979: END IF;
980: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
981: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
982: fnd_message.Set_Token('TEXT', 'Vendor User ID '||l_oppty_routing_log_rec.vendor_user_id);

Line 1072: p_Last_Updated_By => FND_GLOBAL.USER_ID,

1068: pv_leadlog_pvt.InsertAssignLogRow (
1069: X_Rowid => l_rowid,
1070: x_assignlog_ID => l_assignment_log_id,
1071: p_Lead_assignment_ID => p_lead_assignment_ID,
1072: p_Last_Updated_By => FND_GLOBAL.USER_ID,
1073: p_Last_Update_Date => SYSDATE,
1074: p_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1075: p_Created_By => FND_GLOBAL.USER_ID,
1076: p_Creation_Date => SYSDATE,

Line 1074: p_Last_Update_Login => FND_GLOBAL.LOGIN_ID,

1070: x_assignlog_ID => l_assignment_log_id,
1071: p_Lead_assignment_ID => p_lead_assignment_ID,
1072: p_Last_Updated_By => FND_GLOBAL.USER_ID,
1073: p_Last_Update_Date => SYSDATE,
1074: p_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1075: p_Created_By => FND_GLOBAL.USER_ID,
1076: p_Creation_Date => SYSDATE,
1077: p_Object_Version_Number => l_object_version_number,
1078: p_lead_id => l_lead_id,

Line 1075: p_Created_By => FND_GLOBAL.USER_ID,

1071: p_Lead_assignment_ID => p_lead_assignment_ID,
1072: p_Last_Updated_By => FND_GLOBAL.USER_ID,
1073: p_Last_Update_Date => SYSDATE,
1074: p_Last_Update_Login => FND_GLOBAL.LOGIN_ID,
1075: p_Created_By => FND_GLOBAL.USER_ID,
1076: p_Creation_Date => SYSDATE,
1077: p_Object_Version_Number => l_object_version_number,
1078: p_lead_id => l_lead_id,
1079: p_partner_id => l_partner_id,

Line 2316: last_updated_by = FND_GLOBAL.user_id,

2312: update pv_partner_profiles
2313: set oppty_last_offered_date = sysdate,
2314: object_version_number = object_version_number + 1,
2315: last_update_date = sysdate,
2316: last_updated_by = FND_GLOBAL.user_id,
2317: last_update_login = FND_GLOBAL.login_id
2318: where partner_id = p_partner_id;
2319:
2320: else

Line 2317: last_update_login = FND_GLOBAL.login_id

2313: set oppty_last_offered_date = sysdate,
2314: object_version_number = object_version_number + 1,
2315: last_update_date = sysdate,
2316: last_updated_by = FND_GLOBAL.user_id,
2317: last_update_login = FND_GLOBAL.login_id
2318: where partner_id = p_partner_id;
2319:
2320: else
2321: -- broadcast and joint

Line 2327: last_updated_by = FND_GLOBAL.user_id,

2323: update pv_partner_profiles
2324: set oppty_last_offered_date = sysdate,
2325: object_version_number = object_version_number + 1,
2326: last_update_date = sysdate,
2327: last_updated_by = FND_GLOBAL.user_id,
2328: last_update_login = FND_GLOBAL.login_id
2329: where partner_id in (select partner_id from pv_lead_assignments
2330: where wf_item_type = p_itemtype
2331: and wf_item_key = p_itemkey

Line 2328: last_update_login = FND_GLOBAL.login_id

2324: set oppty_last_offered_date = sysdate,
2325: object_version_number = object_version_number + 1,
2326: last_update_date = sysdate,
2327: last_updated_by = FND_GLOBAL.user_id,
2328: last_update_login = FND_GLOBAL.login_id
2329: where partner_id in (select partner_id from pv_lead_assignments
2330: where wf_item_type = p_itemtype
2331: and wf_item_key = p_itemkey
2332: and status in

Line 2356: last_updated_by = FND_GLOBAL.user_id,

2352: pv_assignment_pub.g_la_status_cm_app_for_pt, pv_assignment_pub.g_assign_access_update,
2353: pv_assignment_pub.g_assign_access_view),
2354: object_version_number = object_version_number + 1,
2355: last_update_date = sysdate,
2356: last_updated_by = FND_GLOBAL.user_id,
2357: last_update_login = FND_GLOBAL.login_id
2358: where wf_item_type = p_itemtype
2359: and wf_item_key = p_itemkey
2360: and partner_id = p_partner_id;

Line 2357: last_update_login = FND_GLOBAL.login_id

2353: pv_assignment_pub.g_assign_access_view),
2354: object_version_number = object_version_number + 1,
2355: last_update_date = sysdate,
2356: last_updated_by = FND_GLOBAL.user_id,
2357: last_update_login = FND_GLOBAL.login_id
2358: where wf_item_type = p_itemtype
2359: and wf_item_key = p_itemkey
2360: and partner_id = p_partner_id;
2361:

Line 2371: last_updated_by = FND_GLOBAL.user_id,

2367: pv_assignment_pub.g_la_status_cm_app_for_pt, pv_assignment_pub.g_assign_access_update,
2368: pv_assignment_pub.g_assign_access_view),
2369: object_version_number = object_version_number + 1,
2370: last_update_date = sysdate,
2371: last_updated_by = FND_GLOBAL.user_id,
2372: last_update_login = FND_GLOBAL.login_id
2373: where rowid in (select rowid from pv_lead_assignments
2374: where wf_item_type = p_itemtype
2375: and wf_item_key = p_itemkey

Line 2372: last_update_login = FND_GLOBAL.login_id

2368: pv_assignment_pub.g_assign_access_view),
2369: object_version_number = object_version_number + 1,
2370: last_update_date = sysdate,
2371: last_updated_by = FND_GLOBAL.user_id,
2372: last_update_login = FND_GLOBAL.login_id
2373: where rowid in (select rowid from pv_lead_assignments
2374: where wf_item_type = p_itemtype
2375: and wf_item_key = p_itemkey
2376: and status in

Line 2627: last_updated_by = FND_GLOBAL.user_id,

2623: set routing_status = p_routing_stage,
2624: wf_status = l_wf_status,
2625: object_version_number = object_version_number + 1,
2626: last_update_date = sysdate,
2627: last_updated_by = FND_GLOBAL.user_id,
2628: last_update_login = FND_GLOBAL.login_id
2629: where rowid = l_rowid returning entity into l_entity;
2630:
2631: l_assignment_log_rec.LEAD_ID := l_lead_id;

Line 2628: last_update_login = FND_GLOBAL.login_id

2624: wf_status = l_wf_status,
2625: object_version_number = object_version_number + 1,
2626: last_update_date = sysdate,
2627: last_updated_by = FND_GLOBAL.user_id,
2628: last_update_login = FND_GLOBAL.login_id
2629: where rowid = l_rowid returning entity into l_entity;
2630:
2631: l_assignment_log_rec.LEAD_ID := l_lead_id;
2632: l_assignment_log_rec.FROM_LEAD_STATUS := l_prior_routing;

Line 3344: fnd_global.user_id,

3340: DECISION_MAKER_FLAG
3341: ) values (
3342: l_party_notify_id_tbl(i),
3343: sysdate,
3344: fnd_global.user_id,
3345: sysdate,
3346: 1,
3347: fnd_global.user_id,
3348: fnd_global.conc_login_id,

Line 3347: fnd_global.user_id,

3343: sysdate,
3344: fnd_global.user_id,
3345: sysdate,
3346: 1,
3347: fnd_global.user_id,
3348: fnd_global.conc_login_id,
3349: p_party_notify_rec_tbl.wf_item_type(i),
3350: p_party_notify_rec_tbl.wf_item_key(i),
3351: p_party_notify_rec_tbl.notification_type(i),

Line 3348: fnd_global.conc_login_id,

3344: fnd_global.user_id,
3345: sysdate,
3346: 1,
3347: fnd_global.user_id,
3348: fnd_global.conc_login_id,
3349: p_party_notify_rec_tbl.wf_item_type(i),
3350: p_party_notify_rec_tbl.wf_item_key(i),
3351: p_party_notify_rec_tbl.notification_type(i),
3352: p_party_notify_rec_tbl.lead_assignment_id(i),