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_PUB dependencies on PV_ASSIGNMENT_PUB

Line 1: package body PV_ASSIGNMENT_PUB as

1: package body PV_ASSIGNMENT_PUB as
2: /* $Header: pvxasgnb.pls 120.8 2006/08/24 20:58:04 amaram ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='PV_ASSIGNMENT_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='pvxasgnb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='PV_ASSIGNMENT_PUB';

1: package body PV_ASSIGNMENT_PUB as
2: /* $Header: pvxasgnb.pls 120.8 2006/08/24 20:58:04 amaram ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='PV_ASSIGNMENT_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12):='pvxasgnb.pls';
6:
7: -- ----------------------------------------------------------------------------------
8: -- ORA-00054: resource busy and acquire with NOWAIT specified

Line 463: p_routing_stage => pv_assignment_pub.g_r_status_active,

459: p_commit => FND_API.G_FALSE,
460: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
461: p_itemType => l_itemtype,
462: p_itemKey => l_itemKey,
463: p_routing_stage => pv_assignment_pub.g_r_status_active,
464: p_active_but_open_flag => 'N',
465: x_return_status => x_return_status,
466: x_msg_count => x_msg_count,
467: x_msg_data => x_msg_data);

Line 664: p_access_action => pv_assignment_pub.G_ADD_ACCESS,

660: p_current_username => p_creating_username,
661: p_lead_id => p_lead_id,
662: p_customer_id => l_customer_id,
663: p_address_id => l_address_id,
664: p_access_action => pv_assignment_pub.G_ADD_ACCESS,
665: p_resource_id => l_resource_id,
666: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
667: x_access_id => l_access_id,
668: x_return_status => x_return_status,

Line 666: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,

662: p_customer_id => l_customer_id,
663: p_address_id => l_address_id,
664: p_access_action => pv_assignment_pub.G_ADD_ACCESS,
665: p_resource_id => l_resource_id,
666: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
667: x_access_id => l_access_id,
668: x_return_status => x_return_status,
669: x_msg_count => x_msg_count,
670: x_msg_data => x_msg_data);

Line 753: l_lead_workflow_rec.routing_status := pv_assignment_pub.g_r_status_matched;

749: l_lead_workflow_rec.lead_id := p_lead_id;
750: l_lead_workflow_rec.entity := p_entity;
751: l_lead_workflow_rec.wf_item_type := l_itemtype;
752: l_lead_workflow_rec.routing_type := p_assignment_type;
753: l_lead_workflow_rec.routing_status := pv_assignment_pub.g_r_status_matched;
754: l_lead_workflow_rec.wf_status := pv_assignment_pub.g_wf_status_open;
755: l_lead_workflow_rec.bypass_cm_ok_flag := p_bypass_cm_ok_flag;
756: l_lead_workflow_rec.latest_routing_flag := 'Y';
757:

Line 754: l_lead_workflow_rec.wf_status := pv_assignment_pub.g_wf_status_open;

750: l_lead_workflow_rec.entity := p_entity;
751: l_lead_workflow_rec.wf_item_type := l_itemtype;
752: l_lead_workflow_rec.routing_type := p_assignment_type;
753: l_lead_workflow_rec.routing_status := pv_assignment_pub.g_r_status_matched;
754: l_lead_workflow_rec.wf_status := pv_assignment_pub.g_wf_status_open;
755: l_lead_workflow_rec.bypass_cm_ok_flag := p_bypass_cm_ok_flag;
756: l_lead_workflow_rec.latest_routing_flag := 'Y';
757:
758: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 955: l_assignment_rec.status := pv_assignment_pub.g_la_status_pt_created;

951: l_assignment_rec.status_date := SYSDATE;
952:
953: if nvl(l_vad_id, -9999) = l_partner_id_tbl(v_count) then
954:
955: l_assignment_rec.status := pv_assignment_pub.g_la_status_pt_created;
956: l_assignment_rec.partner_access_code := g_assign_access_update;
957:
958: else
959:

Line 960: l_assignment_rec.status := pv_assignment_pub.g_la_status_assigned;

956: l_assignment_rec.partner_access_code := g_assign_access_update;
957:
958: else
959:
960: l_assignment_rec.status := pv_assignment_pub.g_la_status_assigned;
961: l_assignment_rec.partner_access_code := g_assign_access_none;
962:
963: end if;
964:

Line 1068: if l_party_notify_rec_tbl.notification_type(i) = pv_assignment_pub.g_notify_type_matched_to then

1064: l_no_channel_mgrs := TRUE;
1065:
1066: for i in 1 .. l_party_notify_rec_tbl.RESOURCE_ID.count loop
1067:
1068: if l_party_notify_rec_tbl.notification_type(i) = pv_assignment_pub.g_notify_type_matched_to then
1069:
1070: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1071: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1072: fnd_message.Set_token('TEXT', 'Calling pv_assig_util_pvt.update access for CMs resource id:' || l_party_notify_rec_tbl.resource_id(i) );

Line 1087: p_access_action => pv_assignment_pub.G_ADD_ACCESS,

1083: p_current_username => p_creating_username,
1084: p_lead_id => p_lead_id,
1085: p_customer_id => l_customer_id,
1086: p_address_id => l_address_id,
1087: p_access_action => pv_assignment_pub.G_ADD_ACCESS,
1088: p_resource_id => l_party_notify_rec_tbl.resource_id(i),
1089: p_access_type => pv_assignment_pub.G_CM_ACCESS,
1090: x_access_id => l_temp_id,
1091: x_return_status => x_return_status,

Line 1089: p_access_type => pv_assignment_pub.G_CM_ACCESS,

1085: p_customer_id => l_customer_id,
1086: p_address_id => l_address_id,
1087: p_access_action => pv_assignment_pub.G_ADD_ACCESS,
1088: p_resource_id => l_party_notify_rec_tbl.resource_id(i),
1089: p_access_type => pv_assignment_pub.G_CM_ACCESS,
1090: x_access_id => l_temp_id,
1091: x_return_status => x_return_status,
1092: x_msg_count => x_msg_count,
1093: x_msg_data => x_msg_data);

Line 1385: if p_statusTbl(i) = PV_ASSIGNMENT_PUB.g_la_status_cm_rejected then

1381: if p_partyTbl.count > 1 then
1382:
1383: for i in 1 .. p_statusTbl.count loop
1384:
1385: if p_statusTbl(i) = PV_ASSIGNMENT_PUB.g_la_status_cm_rejected then
1386: l_rejected_cnt := l_rejected_cnt + 1;
1387: end if;
1388:
1389: end loop;

Line 1524: if p_statusTbl(i) in (pv_assignment_pub.g_la_status_cm_added, pv_assignment_pub.g_la_status_cm_add_app_for_pt) then

1520: end if;
1521:
1522: if l_assign_sequence <> p_rank_Tbl(i) then
1523:
1524: if p_statusTbl(i) in (pv_assignment_pub.g_la_status_cm_added, pv_assignment_pub.g_la_status_cm_add_app_for_pt) then
1525: l_response := pv_assignment_pub.g_la_status_cm_approved;
1526: else
1527: l_response := p_statusTbl(i);
1528: end if;

Line 1525: l_response := pv_assignment_pub.g_la_status_cm_approved;

1521:
1522: if l_assign_sequence <> p_rank_Tbl(i) then
1523:
1524: if p_statusTbl(i) in (pv_assignment_pub.g_la_status_cm_added, pv_assignment_pub.g_la_status_cm_add_app_for_pt) then
1525: l_response := pv_assignment_pub.g_la_status_cm_approved;
1526: else
1527: l_response := p_statusTbl(i);
1528: end if;
1529:

Line 1543: ,p_action => pv_assignment_pub.g_asgn_action_status_update

1539: p_api_version_number => 1.0
1540: ,p_init_msg_list => FND_API.G_FALSE
1541: ,p_commit => FND_API.G_FALSE
1542: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1543: ,p_action => pv_assignment_pub.g_asgn_action_status_update
1544: ,p_lead_assignment_id => l_assignment_id
1545: ,p_status_date => sysdate
1546: ,p_status => l_response
1547: ,p_reason_code => NULL

Line 2028: and la.status = pv_assignment_pub.g_la_status_pt_rejected

2024: jtf_rs_resource_extns b
2025: where
2026: la.wf_item_type = pc_itemtype
2027: and la.wf_item_key = pc_itemkey
2028: and la.status = pv_assignment_pub.g_la_status_pt_rejected
2029: and la.partner_id = b.source_id
2030: and b.category = 'PARTNER'
2031: and sysdate between b.start_date_active and nvl(b.end_date_active,sysdate);
2032: begin

Line 2358: if l_routing_status <> pv_assignment_pub.g_r_status_active then

2354: if l_assignment_type = pv_workflow_pub.g_wf_lkup_joint then
2355:
2356: -- someone else may have already accepted
2357:
2358: if l_routing_status <> pv_assignment_pub.g_r_status_active then
2359:
2360:
2361: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)
2362: THEN

Line 2364: fnd_message.Set_Token('TEXT', 'IN if l_routing_status <> pv_assignment_pub.g_r_status_active then');

2360:
2361: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)
2362: THEN
2363: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2364: fnd_message.Set_Token('TEXT', 'IN if l_routing_status <> pv_assignment_pub.g_r_status_active then');
2365: fnd_msg_pub.Add;
2366: END IF;
2367:
2368: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW)

Line 2382: p_routing_stage => pv_assignment_pub.g_r_status_active,

2378: p_commit => FND_API.G_FALSE,
2379: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2380: p_itemType => l_itemtype,
2381: p_itemKey => l_itemKey,
2382: p_routing_stage => pv_assignment_pub.g_r_status_active,
2383: p_active_but_open_flag => 'Y',
2384: x_return_status => x_return_status,
2385: x_msg_count => x_msg_count,
2386: x_msg_data => x_msg_data);

Line 2995: AND l_status not in (pv_assignment_pub.g_la_status_cm_added,

2991: fnd_msg_pub.Add;
2992: END IF;
2993:
2994: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)
2995: AND l_status not in (pv_assignment_pub.g_la_status_cm_added,
2996: pv_assignment_pub.g_la_status_cm_approved,
2997: pv_assignment_pub.g_la_status_cm_bypassed,
2998: pv_assignment_pub.g_la_status_assigned,
2999: pv_assignment_pub.g_la_status_cm_timeout)

Line 2996: pv_assignment_pub.g_la_status_cm_approved,

2992: END IF;
2993:
2994: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)
2995: AND l_status not in (pv_assignment_pub.g_la_status_cm_added,
2996: pv_assignment_pub.g_la_status_cm_approved,
2997: pv_assignment_pub.g_la_status_cm_bypassed,
2998: pv_assignment_pub.g_la_status_assigned,
2999: pv_assignment_pub.g_la_status_cm_timeout)
3000: THEN

Line 2997: pv_assignment_pub.g_la_status_cm_bypassed,

2993:
2994: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)
2995: AND l_status not in (pv_assignment_pub.g_la_status_cm_added,
2996: pv_assignment_pub.g_la_status_cm_approved,
2997: pv_assignment_pub.g_la_status_cm_bypassed,
2998: pv_assignment_pub.g_la_status_assigned,
2999: pv_assignment_pub.g_la_status_cm_timeout)
3000: THEN
3001:

Line 2998: pv_assignment_pub.g_la_status_assigned,

2994: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)
2995: AND l_status not in (pv_assignment_pub.g_la_status_cm_added,
2996: pv_assignment_pub.g_la_status_cm_approved,
2997: pv_assignment_pub.g_la_status_cm_bypassed,
2998: pv_assignment_pub.g_la_status_assigned,
2999: pv_assignment_pub.g_la_status_cm_timeout)
3000: THEN
3001:
3002: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2999: pv_assignment_pub.g_la_status_cm_timeout)

2995: AND l_status not in (pv_assignment_pub.g_la_status_cm_added,
2996: pv_assignment_pub.g_la_status_cm_approved,
2997: pv_assignment_pub.g_la_status_cm_bypassed,
2998: pv_assignment_pub.g_la_status_assigned,
2999: pv_assignment_pub.g_la_status_cm_timeout)
3000: THEN
3001:
3002: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3003: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 3051: AND l_status_tbl(i) in (pv_assignment_pub.g_la_status_pt_rejected,

3047:
3048: null;
3049:
3050: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)
3051: AND l_status_tbl(i) in (pv_assignment_pub.g_la_status_pt_rejected,
3052: pv_assignment_pub.g_la_status_cm_rejected,
3053: pv_assignment_pub.g_la_status_lost_chance)
3054: THEN
3055:

Line 3052: pv_assignment_pub.g_la_status_cm_rejected,

3048: null;
3049:
3050: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)
3051: AND l_status_tbl(i) in (pv_assignment_pub.g_la_status_pt_rejected,
3052: pv_assignment_pub.g_la_status_cm_rejected,
3053: pv_assignment_pub.g_la_status_lost_chance)
3054: THEN
3055:
3056: null;

Line 3053: pv_assignment_pub.g_la_status_lost_chance)

3049:
3050: ELSIF l_assignment_type in (pv_workflow_pub.g_wf_lkup_broadcast, pv_workflow_pub.g_wf_lkup_joint)
3051: AND l_status_tbl(i) in (pv_assignment_pub.g_la_status_pt_rejected,
3052: pv_assignment_pub.g_la_status_cm_rejected,
3053: pv_assignment_pub.g_la_status_lost_chance)
3054: THEN
3055:
3056: null;
3057:

Line 3251: p_routing_stage => pv_assignment_pub.g_r_status_withdrawn,

3247: p_commit => FND_API.G_FALSE,
3248: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3249: p_itemType => l_itemtype,
3250: p_itemKey => l_itemKey,
3251: p_routing_stage => pv_assignment_pub.g_r_status_withdrawn,
3252: p_active_but_open_flag => 'N',
3253: x_return_status => x_return_status,
3254: x_msg_count => x_msg_count,
3255: x_msg_data => x_msg_data);

Line 3752: p_routing_stage => pv_assignment_pub.g_r_status_abandoned,

3748: p_commit => FND_API.G_FALSE,
3749: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3750: p_itemType => l_itemtype,
3751: p_itemKey => l_itemKey,
3752: p_routing_stage => pv_assignment_pub.g_r_status_abandoned,
3753: p_active_but_open_flag => 'N',
3754: x_return_status => x_return_status,
3755: x_msg_count => x_msg_count,
3756: x_msg_data => x_msg_data);

Line 3877: end PV_ASSIGNMENT_PUB;

3873:
3874: end ABANDON_ASSIGNMENT;
3875:
3876:
3877: end PV_ASSIGNMENT_PUB;