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

Line 35: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();

31: l_msg_count number;
32: l_msg_data varchar2(2000);
33: l_temp varchar2(40);
34: l_assignment_id number;
35: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
36:
37: cursor lc_get_assignment (pc_itemtype varchar2,
38: pc_itemkey varchar2 ) is
39: select la.lead_assignment_id

Line 43: and la.status <> pv_assignment_pub.g_la_status_pt_created;

39: select la.lead_assignment_id
40: from pv_lead_assignments la
41: where la.wf_item_type = pc_itemtype
42: and la.wf_item_key = pc_itemkey
43: and la.status <> pv_assignment_pub.g_la_status_pt_created;
44:
45:
46: BEGIN
47:

Line 95: ,p_action => pv_assignment_pub.g_asgn_action_status_update

91: p_api_version_number => 1.0
92: ,p_init_msg_list => FND_API.G_FALSE
93: ,p_commit => FND_API.G_FALSE
94: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
95: ,p_action => pv_assignment_pub.g_asgn_action_status_update
96: ,p_lead_assignment_id => l_assignment_id_tbl(i)
97: ,p_status_date => sysdate
98: ,p_status => pv_assignment_pub.g_la_status_cm_bypassed
99: ,p_reason_code => NULL

Line 98: ,p_status => pv_assignment_pub.g_la_status_cm_bypassed

94: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
95: ,p_action => pv_assignment_pub.g_asgn_action_status_update
96: ,p_lead_assignment_id => l_assignment_id_tbl(i)
97: ,p_status_date => sysdate
98: ,p_status => pv_assignment_pub.g_la_status_cm_bypassed
99: ,p_reason_code => NULL
100: ,p_rank => NULL
101: ,x_msg_count => l_msg_count
102: ,x_msg_data => l_msg_data

Line 278: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();

274:
275: l_assignment_id number;
276: l_assign_status varchar2(30);
277:
278: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
279: l_assign_status_tbl pv_assignment_pub.g_varchar_table_type :=pv_assignment_pub.g_varchar_table_type();
280:
281: cursor lc_get_match_outcome (pc_itemtype varchar2,
282: pc_itemkey varchar2) is

Line 279: l_assign_status_tbl pv_assignment_pub.g_varchar_table_type :=pv_assignment_pub.g_varchar_table_type();

275: l_assignment_id number;
276: l_assign_status varchar2(30);
277:
278: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
279: l_assign_status_tbl pv_assignment_pub.g_varchar_table_type :=pv_assignment_pub.g_varchar_table_type();
280:
281: cursor lc_get_match_outcome (pc_itemtype varchar2,
282: pc_itemkey varchar2) is
283: select a.lead_assignment_id, a.status

Line 306: ,P_route_stage => pv_assignment_pub.g_r_status_matched

302: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
303: ,p_itemtype => itemType
304: ,p_itemkey => itemKey
305: ,p_activity_id => actid
306: ,P_route_stage => pv_assignment_pub.g_r_status_matched
307: ,p_partner_id => NULL
308: ,x_return_status => l_return_status
309: ,x_msg_count => l_msg_count
310: ,x_msg_data => l_msg_data);

Line 346: if l_assign_status_tbl(i) = pv_assignment_pub.g_la_status_assigned then

342: close lc_get_match_outcome;
343:
344: for i in 1 .. l_assignment_id_tbl.count loop
345:
346: if l_assign_status_tbl(i) = pv_assignment_pub.g_la_status_assigned then
347:
348: -- CM did not act and timeout happened
349:
350: pv_assignment_pvt.UpdateAssignment (

Line 355: ,p_action => pv_assignment_pub.g_asgn_action_status_update

351: p_api_version_number => 1.0
352: ,p_init_msg_list => FND_API.G_FALSE
353: ,p_commit => FND_API.G_FALSE
354: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
355: ,p_action => pv_assignment_pub.g_asgn_action_status_update
356: ,p_lead_assignment_id => l_assignment_id_tbl(i)
357: ,p_status_date => sysdate
358: ,p_status => pv_assignment_pub.g_la_status_cm_timeout
359: ,p_reason_code => NULL

Line 358: ,p_status => pv_assignment_pub.g_la_status_cm_timeout

354: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
355: ,p_action => pv_assignment_pub.g_asgn_action_status_update
356: ,p_lead_assignment_id => l_assignment_id_tbl(i)
357: ,p_status_date => sysdate
358: ,p_status => pv_assignment_pub.g_la_status_cm_timeout
359: ,p_reason_code => NULL
360: ,p_rank => NULL
361: ,x_msg_count => l_msg_count
362: ,x_msg_data => l_msg_data

Line 370: set resource_response = pv_assignment_pub.g_la_status_cm_timeout,

366: raise FND_API.G_EXC_ERROR;
367: end if;
368:
369: update pv_party_notifications
370: set resource_response = pv_assignment_pub.g_la_status_cm_timeout,
371: response_date = sysdate,
372: object_version_number = object_version_number + 1,
373: last_update_date = sysdate,
374: last_updated_by = FND_GLOBAL.user_id,

Line 378: and notification_type = pv_assignment_pub.g_notify_type_matched_to;

374: last_updated_by = FND_GLOBAL.user_id,
375: last_update_login = FND_GLOBAL.login_id
376: where lead_assignment_id = l_assignment_id_tbl(i)
377: and resource_response is null
378: and notification_type = pv_assignment_pub.g_notify_type_matched_to;
379:
380: end if;
381: end loop;
382:

Line 551: and status in (pv_assignment_pub.g_la_status_cm_approved,

547: select partner_id, assign_sequence
548: from pv_lead_assignments la
549: where la.wf_item_type = pc_itemtype
550: and la.wf_item_key = pc_itemkey
551: and status in (pv_assignment_pub.g_la_status_cm_approved,
552: pv_assignment_pub.g_la_status_cm_added,
553: pv_assignment_pub.g_la_status_cm_bypassed,
554: pv_assignment_pub.g_la_status_cm_app_for_pt,
555: pv_assignment_pub.g_la_status_cm_timeout)

Line 552: pv_assignment_pub.g_la_status_cm_added,

548: from pv_lead_assignments la
549: where la.wf_item_type = pc_itemtype
550: and la.wf_item_key = pc_itemkey
551: and status in (pv_assignment_pub.g_la_status_cm_approved,
552: pv_assignment_pub.g_la_status_cm_added,
553: pv_assignment_pub.g_la_status_cm_bypassed,
554: pv_assignment_pub.g_la_status_cm_app_for_pt,
555: pv_assignment_pub.g_la_status_cm_timeout)
556: order by assign_sequence;

Line 553: pv_assignment_pub.g_la_status_cm_bypassed,

549: where la.wf_item_type = pc_itemtype
550: and la.wf_item_key = pc_itemkey
551: and status in (pv_assignment_pub.g_la_status_cm_approved,
552: pv_assignment_pub.g_la_status_cm_added,
553: pv_assignment_pub.g_la_status_cm_bypassed,
554: pv_assignment_pub.g_la_status_cm_app_for_pt,
555: pv_assignment_pub.g_la_status_cm_timeout)
556: order by assign_sequence;
557:

Line 554: pv_assignment_pub.g_la_status_cm_app_for_pt,

550: and la.wf_item_key = pc_itemkey
551: and status in (pv_assignment_pub.g_la_status_cm_approved,
552: pv_assignment_pub.g_la_status_cm_added,
553: pv_assignment_pub.g_la_status_cm_bypassed,
554: pv_assignment_pub.g_la_status_cm_app_for_pt,
555: pv_assignment_pub.g_la_status_cm_timeout)
556: order by assign_sequence;
557:
558: BEGIN

Line 555: pv_assignment_pub.g_la_status_cm_timeout)

551: and status in (pv_assignment_pub.g_la_status_cm_approved,
552: pv_assignment_pub.g_la_status_cm_added,
553: pv_assignment_pub.g_la_status_cm_bypassed,
554: pv_assignment_pub.g_la_status_cm_app_for_pt,
555: pv_assignment_pub.g_la_status_cm_timeout)
556: order by assign_sequence;
557:
558: BEGIN
559:

Line 576: ,P_route_stage => pv_assignment_pub.g_r_status_matched

572: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
573: ,p_itemtype => itemType
574: ,p_itemkey => itemKey
575: ,p_activity_id => actid
576: ,P_route_stage => pv_assignment_pub.g_r_status_matched
577: ,p_partner_id => null
578: ,x_return_status => l_return_status
579: ,x_msg_count => l_msg_count
580: ,x_msg_data => l_msg_data);

Line 593: p_routing_stage => pv_assignment_pub.g_r_status_offered,

589: p_commit => FND_API.G_FALSE,
590: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
591: p_itemType => itemtype,
592: p_itemKey => itemKey,
593: p_routing_stage => pv_assignment_pub.g_r_status_offered,
594: p_active_but_open_flag => 'N',
595: x_return_status => l_return_status,
596: x_msg_count => l_msg_count,
597: x_msg_data => l_msg_data);

Line 803: and la.status in ( pv_assignment_pub.g_la_status_cm_approved,

799: from pv_lead_workflows a, pv_lead_assignments la
800: where la.wf_item_type = pc_itemtype
801: and la.wf_item_key = pc_itemkey
802: and la.assign_sequence >= pc_sequence
803: and la.status in ( pv_assignment_pub.g_la_status_cm_approved,
804: pv_assignment_pub.g_la_status_cm_app_for_pt,
805: pv_assignment_pub.g_la_status_cm_bypassed,
806: pv_assignment_pub.g_la_status_cm_timeout)
807: and la.wf_item_type = a.wf_item_type

Line 804: pv_assignment_pub.g_la_status_cm_app_for_pt,

800: where la.wf_item_type = pc_itemtype
801: and la.wf_item_key = pc_itemkey
802: and la.assign_sequence >= pc_sequence
803: and la.status in ( pv_assignment_pub.g_la_status_cm_approved,
804: pv_assignment_pub.g_la_status_cm_app_for_pt,
805: pv_assignment_pub.g_la_status_cm_bypassed,
806: pv_assignment_pub.g_la_status_cm_timeout)
807: and la.wf_item_type = a.wf_item_type
808: and la.wf_item_key = a.wf_item_key

Line 805: pv_assignment_pub.g_la_status_cm_bypassed,

801: and la.wf_item_key = pc_itemkey
802: and la.assign_sequence >= pc_sequence
803: and la.status in ( pv_assignment_pub.g_la_status_cm_approved,
804: pv_assignment_pub.g_la_status_cm_app_for_pt,
805: pv_assignment_pub.g_la_status_cm_bypassed,
806: pv_assignment_pub.g_la_status_cm_timeout)
807: and la.wf_item_type = a.wf_item_type
808: and la.wf_item_key = a.wf_item_key
809: order by assign_sequence;

Line 806: pv_assignment_pub.g_la_status_cm_timeout)

802: and la.assign_sequence >= pc_sequence
803: and la.status in ( pv_assignment_pub.g_la_status_cm_approved,
804: pv_assignment_pub.g_la_status_cm_app_for_pt,
805: pv_assignment_pub.g_la_status_cm_bypassed,
806: pv_assignment_pub.g_la_status_cm_timeout)
807: and la.wf_item_type = a.wf_item_type
808: and la.wf_item_key = a.wf_item_key
809: order by assign_sequence;
810:

Line 979: and la.status = pv_assignment_pub.g_la_status_cm_app_for_pt

975: jtf_rs_resource_extns b
976: where
977: la.wf_item_type = pc_itemtype
978: and la.wf_item_key = pc_itemkey
979: and la.status = pv_assignment_pub.g_la_status_cm_app_for_pt
980: and la.partner_id = b.source_id
981: and b.category = 'PARTNER';
982:
983: BEGIN

Line 1004: ,P_route_stage => pv_assignment_pub.g_r_status_offered

1000: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1001: ,p_itemtype => itemType
1002: ,p_itemkey => itemKey
1003: ,p_activity_id => actid
1004: ,P_route_stage => pv_assignment_pub.g_r_status_offered
1005: ,p_partner_id => l_partner_id
1006: ,x_return_status => l_return_status
1007: ,x_msg_count => l_msg_count
1008: ,x_msg_data => l_msg_data);

Line 1054: p_access_action => pv_assignment_pub.G_ADD_ACCESS,

1050: p_current_username => NULL,
1051: p_lead_id => l_lead_id,
1052: p_customer_id => l_customer_id,
1053: p_address_id => l_address_id,
1054: p_access_action => pv_assignment_pub.G_ADD_ACCESS,
1055: p_resource_id => l_pt_org_rs_id,
1056: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
1057: x_access_id => l_access_id,
1058: x_return_status => l_return_status,

Line 1056: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,

1052: p_customer_id => l_customer_id,
1053: p_address_id => l_address_id,
1054: p_access_action => pv_assignment_pub.G_ADD_ACCESS,
1055: p_resource_id => l_pt_org_rs_id,
1056: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
1057: x_access_id => l_access_id,
1058: x_return_status => l_return_status,
1059: x_msg_count => l_msg_count,
1060: x_msg_data => l_msg_data);

Line 1078: p_routing_stage => pv_assignment_pub.g_r_status_active,

1074: p_commit => FND_API.G_FALSE,
1075: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1076: p_itemType => itemtype,
1077: p_itemKey => itemKey,
1078: p_routing_stage => pv_assignment_pub.g_r_status_active,
1079: p_active_but_open_flag => 'Y',
1080: x_return_status => l_return_status,
1081: x_msg_count => l_msg_count,
1082: x_msg_data => l_msg_data);

Line 1168: l_username_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();

1164: l_customer_id number;
1165: l_partner_org_rs_id number;
1166: l_address_id number;
1167: l_lc_partner_rs_id NUMBER;
1168: l_username_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1169: l_response_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1170: l_resource_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1171: l_partner_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1172: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();

Line 1169: l_response_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();

1165: l_partner_org_rs_id number;
1166: l_address_id number;
1167: l_lc_partner_rs_id NUMBER;
1168: l_username_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1169: l_response_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1170: l_resource_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1171: l_partner_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1172: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1173:

Line 1170: l_resource_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();

1166: l_address_id number;
1167: l_lc_partner_rs_id NUMBER;
1168: l_username_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1169: l_response_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1170: l_resource_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1171: l_partner_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1172: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1173:
1174: l_resultout varchar2(30);

Line 1171: l_partner_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();

1167: l_lc_partner_rs_id NUMBER;
1168: l_username_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1169: l_response_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1170: l_resource_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1171: l_partner_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1172: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1173:
1174: l_resultout varchar2(30);
1175: l_return_status varchar2(1);

Line 1172: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();

1168: l_username_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1169: l_response_tbl pv_assignment_pub.g_varchar_table_type := pv_assignment_pub.g_varchar_table_type();
1170: l_resource_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1171: l_partner_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1172: l_assignment_id_tbl pv_assignment_pub.g_number_table_type := pv_assignment_pub.g_number_table_type();
1173:
1174: l_resultout varchar2(30);
1175: l_return_status varchar2(1);
1176: l_msg_count number;

Line 1253: and la2.status in (pv_assignment_pub.g_la_status_cm_timeout,

1249: pv_party_notifications pn2
1250: where la2.wf_item_type = pc_itemtype
1251: and la2.wf_item_key = pc_itemkey
1252: and la2.partner_id <> la.partner_id
1253: and la2.status in (pv_assignment_pub.g_la_status_cm_timeout,
1254: pv_assignment_pub.g_la_status_cm_approved,
1255: pv_assignment_pub.g_la_status_cm_bypassed,
1256: pv_assignment_pub.g_la_status_cm_app_for_pt,
1257: pv_assignment_pub.g_la_status_pt_approved)

Line 1254: pv_assignment_pub.g_la_status_cm_approved,

1250: where la2.wf_item_type = pc_itemtype
1251: and la2.wf_item_key = pc_itemkey
1252: and la2.partner_id <> la.partner_id
1253: and la2.status in (pv_assignment_pub.g_la_status_cm_timeout,
1254: pv_assignment_pub.g_la_status_cm_approved,
1255: pv_assignment_pub.g_la_status_cm_bypassed,
1256: pv_assignment_pub.g_la_status_cm_app_for_pt,
1257: pv_assignment_pub.g_la_status_pt_approved)
1258: and la2.lead_assignment_id = pn2.lead_assignment_id

Line 1255: pv_assignment_pub.g_la_status_cm_bypassed,

1251: and la2.wf_item_key = pc_itemkey
1252: and la2.partner_id <> la.partner_id
1253: and la2.status in (pv_assignment_pub.g_la_status_cm_timeout,
1254: pv_assignment_pub.g_la_status_cm_approved,
1255: pv_assignment_pub.g_la_status_cm_bypassed,
1256: pv_assignment_pub.g_la_status_cm_app_for_pt,
1257: pv_assignment_pub.g_la_status_pt_approved)
1258: and la2.lead_assignment_id = pn2.lead_assignment_id
1259: and pn2.notification_type = pc_notify_type

Line 1256: pv_assignment_pub.g_la_status_cm_app_for_pt,

1252: and la2.partner_id <> la.partner_id
1253: and la2.status in (pv_assignment_pub.g_la_status_cm_timeout,
1254: pv_assignment_pub.g_la_status_cm_approved,
1255: pv_assignment_pub.g_la_status_cm_bypassed,
1256: pv_assignment_pub.g_la_status_cm_app_for_pt,
1257: pv_assignment_pub.g_la_status_pt_approved)
1258: and la2.lead_assignment_id = pn2.lead_assignment_id
1259: and pn2.notification_type = pc_notify_type
1260: and pn2.user_id = pn.user_id );

Line 1257: pv_assignment_pub.g_la_status_pt_approved)

1253: and la2.status in (pv_assignment_pub.g_la_status_cm_timeout,
1254: pv_assignment_pub.g_la_status_cm_approved,
1255: pv_assignment_pub.g_la_status_cm_bypassed,
1256: pv_assignment_pub.g_la_status_cm_app_for_pt,
1257: pv_assignment_pub.g_la_status_pt_approved)
1258: and la2.lead_assignment_id = pn2.lead_assignment_id
1259: and pn2.notification_type = pc_notify_type
1260: and pn2.user_id = pn.user_id );
1261:

Line 1271: and la.status = pv_assignment_pub.g_la_status_pt_timeout

1267: jtf_rs_resource_extns b
1268: where
1269: la.wf_item_type = pc_itemtype
1270: and la.wf_item_key = pc_itemkey
1271: and la.status = pv_assignment_pub.g_la_status_pt_timeout
1272: and la.partner_id = b.source_id
1273: and b.category = 'PARTNER';
1274:
1275: -- for removing sales team partners when lost chance

Line 1284: and la.status = pv_assignment_pub.g_la_status_lost_chance

1280: jtf_rs_resource_extns b
1281: where
1282: la.wf_item_type = pc_itemtype
1283: and la.wf_item_key = pc_itemkey
1284: and la.status = pv_assignment_pub.g_la_status_lost_chance
1285: and la.partner_id = b.source_id
1286: and b.category = 'PARTNER';
1287:
1288: cursor lc_get_partner_org (pc_itemtype varchar2,

Line 1297: and la.status in (pv_assignment_pub.g_la_status_cm_app_for_pt,

1293: jtf_rs_resource_extns b
1294: where
1295: la.wf_item_type = pc_itemtype
1296: and la.wf_item_key = pc_itemkey
1297: and la.status in (pv_assignment_pub.g_la_status_cm_app_for_pt,
1298: pv_assignment_pub.g_la_status_pt_approved)
1299: and la.partner_id = b.source_id
1300: and b.category = 'PARTNER';
1301:

Line 1298: pv_assignment_pub.g_la_status_pt_approved)

1294: where
1295: la.wf_item_type = pc_itemtype
1296: and la.wf_item_key = pc_itemkey
1297: and la.status in (pv_assignment_pub.g_la_status_cm_app_for_pt,
1298: pv_assignment_pub.g_la_status_pt_approved)
1299: and la.partner_id = b.source_id
1300: and b.category = 'PARTNER';
1301:
1302: cursor lc_get_lost_chance_pt (pc_itemtype varchar2,

Line 1310: and la.status in (pv_assignment_pub.g_la_status_cm_timeout,

1306: from pv_lead_assignments la
1307: where la.wf_item_type = pc_itemtype
1308: and la.wf_item_key = pc_itemkey
1309: and la.assign_sequence > pc_rank
1310: and la.status in (pv_assignment_pub.g_la_status_cm_timeout,
1311: pv_assignment_pub.g_la_status_cm_bypassed,
1312: pv_assignment_pub.g_la_status_cm_app_for_pt,
1313: pv_assignment_pub.g_la_status_cm_approved);
1314:

Line 1311: pv_assignment_pub.g_la_status_cm_bypassed,

1307: where la.wf_item_type = pc_itemtype
1308: and la.wf_item_key = pc_itemkey
1309: and la.assign_sequence > pc_rank
1310: and la.status in (pv_assignment_pub.g_la_status_cm_timeout,
1311: pv_assignment_pub.g_la_status_cm_bypassed,
1312: pv_assignment_pub.g_la_status_cm_app_for_pt,
1313: pv_assignment_pub.g_la_status_cm_approved);
1314:
1315: BEGIN

Line 1312: pv_assignment_pub.g_la_status_cm_app_for_pt,

1308: and la.wf_item_key = pc_itemkey
1309: and la.assign_sequence > pc_rank
1310: and la.status in (pv_assignment_pub.g_la_status_cm_timeout,
1311: pv_assignment_pub.g_la_status_cm_bypassed,
1312: pv_assignment_pub.g_la_status_cm_app_for_pt,
1313: pv_assignment_pub.g_la_status_cm_approved);
1314:
1315: BEGIN
1316: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 1313: pv_assignment_pub.g_la_status_cm_approved);

1309: and la.assign_sequence > pc_rank
1310: and la.status in (pv_assignment_pub.g_la_status_cm_timeout,
1311: pv_assignment_pub.g_la_status_cm_bypassed,
1312: pv_assignment_pub.g_la_status_cm_app_for_pt,
1313: pv_assignment_pub.g_la_status_cm_approved);
1314:
1315: BEGIN
1316: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1317: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 1419: if l_response_tbl(i) in (pv_assignment_pub.g_la_status_cm_approved,

1415: for i in 1 .. l_response_tbl.count loop
1416:
1417: -- for single and serial, this loop should only be executed once
1418:
1419: if l_response_tbl(i) in (pv_assignment_pub.g_la_status_cm_approved,
1420: pv_assignment_pub.g_la_status_cm_bypassed,
1421: pv_assignment_pub.g_la_status_cm_timeout) then
1422:
1423: -- partner timed out because status was not changed

Line 1420: pv_assignment_pub.g_la_status_cm_bypassed,

1416:
1417: -- for single and serial, this loop should only be executed once
1418:
1419: if l_response_tbl(i) in (pv_assignment_pub.g_la_status_cm_approved,
1420: pv_assignment_pub.g_la_status_cm_bypassed,
1421: pv_assignment_pub.g_la_status_cm_timeout) then
1422:
1423: -- partner timed out because status was not changed
1424:

Line 1421: pv_assignment_pub.g_la_status_cm_timeout) then

1417: -- for single and serial, this loop should only be executed once
1418:
1419: if l_response_tbl(i) in (pv_assignment_pub.g_la_status_cm_approved,
1420: pv_assignment_pub.g_la_status_cm_bypassed,
1421: pv_assignment_pub.g_la_status_cm_timeout) then
1422:
1423: -- partner timed out because status was not changed
1424:
1425: pv_assignment_pvt.UpdateAssignment (

Line 1430: ,p_action => pv_assignment_pub.g_asgn_action_status_update

1426: p_api_version_number => 1.0
1427: ,p_init_msg_list => FND_API.G_FALSE
1428: ,p_commit => FND_API.G_FALSE
1429: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1430: ,p_action => pv_assignment_pub.g_asgn_action_status_update
1431: ,p_lead_assignment_id => l_assignment_id_tbl(i)
1432: ,p_status_date => sysdate
1433: ,p_status => pv_assignment_pub.g_la_status_pt_timeout
1434: ,p_reason_code => NULL

Line 1433: ,p_status => pv_assignment_pub.g_la_status_pt_timeout

1429: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1430: ,p_action => pv_assignment_pub.g_asgn_action_status_update
1431: ,p_lead_assignment_id => l_assignment_id_tbl(i)
1432: ,p_status_date => sysdate
1433: ,p_status => pv_assignment_pub.g_la_status_pt_timeout
1434: ,p_reason_code => NULL
1435: ,p_rank => NULL
1436: ,x_msg_count => l_msg_count
1437: ,x_msg_data => l_msg_data

Line 1452: pc_notify_type => pv_assignment_pub.g_notify_type_offered_to);

1448:
1449: open lc_get_offered_to_for_pt (pc_itemtype => itemtype,
1450: pc_itemkey => itemkey,
1451: pc_partner_id => l_partner_id_tbl(i),
1452: pc_notify_type => pv_assignment_pub.g_notify_type_offered_to);
1453:
1454: loop
1455: fetch lc_get_offered_to_for_pt into l_username, l_resource_id;
1456: exit when lc_get_offered_to_for_pt%notfound;

Line 1479: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,

1475: p_current_username => l_username_tbl(i),
1476: p_lead_id => l_lead_id,
1477: p_customer_id => null,
1478: p_address_id => null,
1479: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1480: p_resource_id => l_resource_id_tbl(i),
1481: p_access_type => pv_assignment_pub.g_pt_access,
1482: x_access_id => l_access_id,
1483: x_return_status => l_return_status,

Line 1481: p_access_type => pv_assignment_pub.g_pt_access,

1477: p_customer_id => null,
1478: p_address_id => null,
1479: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1480: p_resource_id => l_resource_id_tbl(i),
1481: p_access_type => pv_assignment_pub.g_pt_access,
1482: x_access_id => l_access_id,
1483: x_return_status => l_return_status,
1484: x_msg_count => l_msg_count,
1485: x_msg_data => l_msg_data);

Line 1501: pc_notify_type => pv_assignment_pub.g_notify_type_matched_to);

1497:
1498: open lc_get_uniq_cm_for_pt (pc_itemtype => itemtype,
1499: pc_itemkey => itemkey,
1500: pc_partner_id => l_partner_id_tbl(i),
1501: pc_notify_type => pv_assignment_pub.g_notify_type_matched_to);
1502: loop
1503: fetch lc_get_uniq_cm_for_pt into l_username, l_resource_id;
1504: exit when lc_get_uniq_cm_for_pt%notfound;
1505:

Line 1527: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,

1523: p_current_username => l_username_tbl(i),
1524: p_lead_id => l_lead_id,
1525: p_customer_id => null,
1526: p_address_id => null,
1527: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1528: p_resource_id => l_resource_id_tbl(i),
1529: p_access_type => pv_assignment_pub.g_cm_access,
1530: x_access_id => l_access_id,
1531: x_return_status => l_return_status,

Line 1529: p_access_type => pv_assignment_pub.g_cm_access,

1525: p_customer_id => null,
1526: p_address_id => null,
1527: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1528: p_resource_id => l_resource_id_tbl(i),
1529: p_access_type => pv_assignment_pub.g_cm_access,
1530: x_access_id => l_access_id,
1531: x_return_status => l_return_status,
1532: x_msg_count => l_msg_count,
1533: x_msg_data => l_msg_data);

Line 1568: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,

1564: p_current_username => NULL,
1565: p_lead_id => l_lead_id,
1566: p_customer_id => l_customer_id,
1567: p_address_id => l_address_id,
1568: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1569: p_resource_id => l_partner_org_rs_id,
1570: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
1571: x_access_id => l_access_id,
1572: x_return_status => l_return_status,

Line 1570: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,

1566: p_customer_id => l_customer_id,
1567: p_address_id => l_address_id,
1568: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1569: p_resource_id => l_partner_org_rs_id,
1570: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
1571: x_access_id => l_access_id,
1572: x_return_status => l_return_status,
1573: x_msg_count => l_msg_count,
1574: x_msg_data => l_msg_data);

Line 1640: ,p_action => pv_assignment_pub.g_asgn_action_status_update

1636: p_api_version_number => 1.0
1637: ,p_init_msg_list => FND_API.G_FALSE
1638: ,p_commit => FND_API.G_FALSE
1639: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1640: ,p_action => pv_assignment_pub.g_asgn_action_status_update
1641: ,p_lead_assignment_id => l_assignment_id_tbl(i)
1642: ,p_status_date => sysdate
1643: ,p_status => pv_assignment_pub.g_la_status_lost_chance
1644: ,p_reason_code => NULL

Line 1643: ,p_status => pv_assignment_pub.g_la_status_lost_chance

1639: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1640: ,p_action => pv_assignment_pub.g_asgn_action_status_update
1641: ,p_lead_assignment_id => l_assignment_id_tbl(i)
1642: ,p_status_date => sysdate
1643: ,p_status => pv_assignment_pub.g_la_status_lost_chance
1644: ,p_reason_code => NULL
1645: ,p_rank => NULL
1646: ,x_msg_count => l_msg_count
1647: ,x_msg_data => l_msg_data

Line 1662: pc_notify_type => pv_assignment_pub.g_notify_type_offered_to);

1658:
1659: open lc_get_offered_to_for_pt (pc_itemtype => itemtype,
1660: pc_itemkey => itemkey,
1661: pc_partner_id => l_partner_id_tbl(i),
1662: pc_notify_type => pv_assignment_pub.g_notify_type_offered_to);
1663:
1664: loop
1665: l_username_tbl.extend;
1666: l_resource_id_tbl.extend;

Line 1691: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,

1687: p_current_username => l_username_tbl(i),
1688: p_lead_id => l_lead_id,
1689: p_customer_id => null,
1690: p_address_id => null,
1691: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1692: p_resource_id => l_resource_id_tbl(i),
1693: p_access_type => pv_assignment_pub.G_PT_ACCESS,
1694: x_access_id => l_access_id,
1695: x_return_status => l_return_status,

Line 1693: p_access_type => pv_assignment_pub.G_PT_ACCESS,

1689: p_customer_id => null,
1690: p_address_id => null,
1691: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1692: p_resource_id => l_resource_id_tbl(i),
1693: p_access_type => pv_assignment_pub.G_PT_ACCESS,
1694: x_access_id => l_access_id,
1695: x_return_status => l_return_status,
1696: x_msg_count => l_msg_count,
1697: x_msg_data => l_msg_data);

Line 1713: pc_notify_type => pv_assignment_pub.g_notify_type_matched_to);

1709:
1710: open lc_get_uniq_cm_for_pt (pc_itemtype => itemtype,
1711: pc_itemkey => itemkey,
1712: pc_partner_id => l_partner_id_tbl(i),
1713: pc_notify_type => pv_assignment_pub.g_notify_type_matched_to);
1714: loop
1715: l_username_tbl.extend;
1716: l_resource_id_tbl.extend;
1717:

Line 1741: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,

1737: p_current_username => l_username_tbl(i),
1738: p_lead_id => l_lead_id,
1739: p_customer_id => null,
1740: p_address_id => null,
1741: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1742: p_resource_id => l_resource_id_tbl(i),
1743: p_access_type => pv_assignment_pub.G_CM_ACCESS,
1744: x_access_id => l_access_id,
1745: x_return_status => l_return_status,

Line 1743: p_access_type => pv_assignment_pub.G_CM_ACCESS,

1739: p_customer_id => null,
1740: p_address_id => null,
1741: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1742: p_resource_id => l_resource_id_tbl(i),
1743: p_access_type => pv_assignment_pub.G_CM_ACCESS,
1744: x_access_id => l_access_id,
1745: x_return_status => l_return_status,
1746: x_msg_count => l_msg_count,
1747: x_msg_data => l_msg_data);

Line 1779: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,

1775: p_current_username => NULL,
1776: p_lead_id => l_lead_id,
1777: p_customer_id => l_customer_id,
1778: p_address_id => l_address_id,
1779: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1780: p_resource_id => l_lc_partner_rs_id,
1781: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
1782: x_access_id => l_access_id,
1783: x_return_status => l_return_status,

Line 1781: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,

1777: p_customer_id => l_customer_id,
1778: p_address_id => l_address_id,
1779: p_access_action => pv_assignment_pub.G_REMOVE_ACCESS,
1780: p_resource_id => l_lc_partner_rs_id,
1781: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
1782: x_access_id => l_access_id,
1783: x_return_status => l_return_status,
1784: x_msg_count => l_msg_count,
1785: x_msg_data => l_msg_data);

Line 1817: p_access_action => pv_assignment_pub.G_ADD_ACCESS,

1813: p_current_username => NULL,
1814: p_lead_id => l_lead_id,
1815: p_customer_id => l_customer_id,
1816: p_address_id => l_address_id,
1817: p_access_action => pv_assignment_pub.G_ADD_ACCESS,
1818: p_resource_id => l_partner_org_rs_id,
1819: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
1820: x_access_id => l_access_id,
1821: x_return_status => l_return_status,

Line 1819: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,

1815: p_customer_id => l_customer_id,
1816: p_address_id => l_address_id,
1817: p_access_action => pv_assignment_pub.G_ADD_ACCESS,
1818: p_resource_id => l_partner_org_rs_id,
1819: p_access_type => pv_assignment_pub.G_PT_ORG_ACCESS,
1820: x_access_id => l_access_id,
1821: x_return_status => l_return_status,
1822: x_msg_count => l_msg_count,
1823: x_msg_data => l_msg_data);

Line 1851: ,P_route_stage => pv_assignment_pub.g_r_status_offered

1847: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1848: ,p_itemtype => itemType
1849: ,p_itemkey => itemKey
1850: ,p_activity_id => actid
1851: ,P_route_stage => pv_assignment_pub.g_r_status_offered
1852: ,p_partner_id => l_partner_id
1853: ,x_return_status => l_return_status
1854: ,x_msg_count => l_msg_count
1855: ,x_msg_data => l_msg_data);

Line 1960: and la.status = pv_assignment_pub.g_la_status_cm_app_for_pt;

1956: select la.status
1957: from pv_lead_assignments la
1958: where la.wf_item_type = pc_itemtype
1959: and la.wf_item_key = pc_itemkey
1960: and la.status = pv_assignment_pub.g_la_status_cm_app_for_pt;
1961:
1962:
1963: BEGIN
1964:

Line 2025: if l_status = pv_assignment_pub.g_la_status_cm_app_for_pt then

2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2022:
2023: end if;
2024:
2025: if l_status = pv_assignment_pub.g_la_status_cm_app_for_pt then
2026: l_resultout := 'COMPLETE:' || g_wf_lkup_yes;
2027: else
2028: l_resultout := 'COMPLETE:' || g_wf_lkup_no;
2029: end if;

Line 2104: and la.status in (pv_assignment_pub.g_la_status_cm_approved,

2100: select la.status
2101: from pv_lead_assignments la
2102: where la.wf_item_type = pc_itemtype
2103: and la.wf_item_key = pc_itemkey
2104: and la.status in (pv_assignment_pub.g_la_status_cm_approved,
2105: pv_assignment_pub.g_la_status_cm_added,
2106: pv_assignment_pub.g_la_status_cm_bypassed,
2107: pv_assignment_pub.g_la_status_cm_timeout);
2108: BEGIN

Line 2105: pv_assignment_pub.g_la_status_cm_added,

2101: from pv_lead_assignments la
2102: where la.wf_item_type = pc_itemtype
2103: and la.wf_item_key = pc_itemkey
2104: and la.status in (pv_assignment_pub.g_la_status_cm_approved,
2105: pv_assignment_pub.g_la_status_cm_added,
2106: pv_assignment_pub.g_la_status_cm_bypassed,
2107: pv_assignment_pub.g_la_status_cm_timeout);
2108: BEGIN
2109:

Line 2106: pv_assignment_pub.g_la_status_cm_bypassed,

2102: where la.wf_item_type = pc_itemtype
2103: and la.wf_item_key = pc_itemkey
2104: and la.status in (pv_assignment_pub.g_la_status_cm_approved,
2105: pv_assignment_pub.g_la_status_cm_added,
2106: pv_assignment_pub.g_la_status_cm_bypassed,
2107: pv_assignment_pub.g_la_status_cm_timeout);
2108: BEGIN
2109:
2110: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2107: pv_assignment_pub.g_la_status_cm_timeout);

2103: and la.wf_item_key = pc_itemkey
2104: and la.status in (pv_assignment_pub.g_la_status_cm_approved,
2105: pv_assignment_pub.g_la_status_cm_added,
2106: pv_assignment_pub.g_la_status_cm_bypassed,
2107: pv_assignment_pub.g_la_status_cm_timeout);
2108: BEGIN
2109:
2110: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2111: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 2234: lc_ref_cursor pv_assignment_pub.g_ref_cursor_type;

2230: l_notify_am_flag varchar2(1);
2231: l_notify_ot_flag varchar2(1);
2232: l_notify_enabled_flag varchar2(1);
2233: l_combination_count pls_integer := 0;
2234: lc_ref_cursor pv_assignment_pub.g_ref_cursor_type;
2235:
2236: BEGIN
2237:
2238: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2259: l_routing_stage := pv_assignment_pub.g_r_status_recycled;

2255: if l_routing_outcome in (pv_workflow_pub.g_wf_lkup_match_rejected,
2256: pv_workflow_pub.g_wf_lkup_offer_rejected,
2257: pv_workflow_pub.g_wf_lkup_offer_timedout) then
2258:
2259: l_routing_stage := pv_assignment_pub.g_r_status_recycled;
2260:
2261: --000000000000000000000000000000000000000000000000000000000000000000000000
2262: -- In a joint routing, if at least one of the partners has approved the
2263: -- routing, the routing status should remain ACTIVE even though the

Line 2280: status IN (pv_assignment_pub.g_la_status_cm_add_app_for_pt,

2276: FOR x IN (SELECT COUNT(*) approved_count
2277: FROM pv_lead_assignments
2278: WHERE wf_item_type = itemtype AND
2279: wf_item_key = itemkey AND
2280: status IN (pv_assignment_pub.g_la_status_cm_add_app_for_pt,
2281: pv_assignment_pub.g_la_status_cm_app_for_pt,
2282: pv_assignment_pub.g_la_status_pt_approved))
2283: LOOP
2284: IF (x.approved_count > 0) THEN

Line 2281: pv_assignment_pub.g_la_status_cm_app_for_pt,

2277: FROM pv_lead_assignments
2278: WHERE wf_item_type = itemtype AND
2279: wf_item_key = itemkey AND
2280: status IN (pv_assignment_pub.g_la_status_cm_add_app_for_pt,
2281: pv_assignment_pub.g_la_status_cm_app_for_pt,
2282: pv_assignment_pub.g_la_status_pt_approved))
2283: LOOP
2284: IF (x.approved_count > 0) THEN
2285: l_routing_stage := PV_ASSIGNMENT_PUB.g_r_status_active;

Line 2282: pv_assignment_pub.g_la_status_pt_approved))

2278: WHERE wf_item_type = itemtype AND
2279: wf_item_key = itemkey AND
2280: status IN (pv_assignment_pub.g_la_status_cm_add_app_for_pt,
2281: pv_assignment_pub.g_la_status_cm_app_for_pt,
2282: pv_assignment_pub.g_la_status_pt_approved))
2283: LOOP
2284: IF (x.approved_count > 0) THEN
2285: l_routing_stage := PV_ASSIGNMENT_PUB.g_r_status_active;
2286: END IF;

Line 2285: l_routing_stage := PV_ASSIGNMENT_PUB.g_r_status_active;

2281: pv_assignment_pub.g_la_status_cm_app_for_pt,
2282: pv_assignment_pub.g_la_status_pt_approved))
2283: LOOP
2284: IF (x.approved_count > 0) THEN
2285: l_routing_stage := PV_ASSIGNMENT_PUB.g_r_status_active;
2286: END IF;
2287: END LOOP;
2288: END IF;
2289: --000000000000000000000000000000000000000000000000000000000000000000000000

Line 2295: l_routing_stage := pv_assignment_pub.g_r_status_withdrawn;

2291:
2292: elsif l_routing_outcome in (pv_workflow_pub.g_wf_lkup_match_withdrawn,
2293: pv_workflow_pub.g_wf_lkup_offer_withdrawn) then
2294:
2295: l_routing_stage := pv_assignment_pub.g_r_status_withdrawn;
2296:
2297: IF l_routing_outcome = pv_workflow_pub.g_wf_lkup_offer_withdrawn THEN
2298:
2299: l_assignment_type := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 2317: l_routing_stage := pv_assignment_pub.g_r_status_active;

2313: END IF;
2314:
2315: elsif l_routing_outcome in (pv_workflow_pub.g_wf_lkup_offer_approved) then
2316:
2317: l_routing_stage := pv_assignment_pub.g_r_status_active;
2318:
2319: else
2320:
2321: fnd_message.SET_NAME('PV', 'Invalid routing outcome: ' || l_routing_outcome);

Line 2326: IF l_routing_stage <> pv_assignment_pub.g_r_status_active THEN

2322: fnd_msg_pub.ADD;
2323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2324:
2325: end if;
2326: IF l_routing_stage <> pv_assignment_pub.g_r_status_active THEN
2327: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2328: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2329: fnd_message.Set_Token('TEXT', 'checking and removing preferred partner');
2330: fnd_msg_pub.Add;

Line 2478: ,P_route_stage => pv_assignment_pub.g_r_status_abandoned

2474: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2475: ,p_itemtype => itemType
2476: ,p_itemkey => itemKey
2477: ,p_activity_id => actid
2478: ,P_route_stage => pv_assignment_pub.g_r_status_abandoned
2479: ,p_partner_id => l_partner_id
2480: ,x_return_status => l_return_status
2481: ,x_msg_count => l_msg_count
2482: ,x_msg_data => l_msg_data);

Line 2572: ,P_route_stage => pv_assignment_pub.g_r_status_withdrawn

2568: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2569: ,p_itemtype => itemType
2570: ,p_itemkey => itemKey
2571: ,p_activity_id => actid
2572: ,P_route_stage => pv_assignment_pub.g_r_status_withdrawn
2573: ,p_partner_id => NULL
2574: ,x_return_status => l_return_status
2575: ,x_msg_count => l_msg_count
2576: ,x_msg_data => l_msg_data);