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.XNP_UTILS dependencies on STANDARD

Line 219: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

215: -- directly. If not found there then get it from
216: -- the SOA table
217: ------------------------------------------------------------------
218: l_DONOR_SP_CODE :=
219: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
220: (p_WI_INSTANCE_ID
221: ,'DONOR_SP_ID'
222: );
223:

Line 229: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

225: THEN
226:
227: -- Get the Porting ID from the WI params table
228: l_PORTING_ID :=
229: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
230: (p_WI_INSTANCE_ID
231: ,'PORTING_ID'
232: );
233:

Line 306: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

302: x_RETURN_CODE := 0;
303: x_ERROR_DESCRIPTION := NULL;
304:
305: l_STARTING_NUMBER :=
306: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
307: (p_WI_INSTANCE_ID
308: ,'STARTING_NUMBER'
309: );
310:

Line 312: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

308: ,'STARTING_NUMBER'
309: );
310:
311: l_ENDING_NUMBER :=
312: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
313: (p_WI_INSTANCE_ID
314: ,'ENDING_NUMBER'
315: );
316:

Line 382: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

378: x_ERROR_DESCRIPTION := NULL;
379:
380: -- Get the NRC id for this range
381: l_STARTING_NUMBER :=
382: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
383: (p_WI_INSTANCE_ID
384: ,'STARTING_NUMBER'
385: );
386:

Line 388: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

384: ,'STARTING_NUMBER'
385: );
386:
387: l_ENDING_NUMBER :=
388: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
389: (p_WI_INSTANCE_ID
390: ,'ENDING_NUMBER'
391: );
392:

Line 458: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

454: -- directly. If not found there then get it from
455: -- the SOA table
456: ------------------------------------------------------------------
457: l_RECIPIENT_SP_CODE :=
458: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
459: (p_WI_INSTANCE_ID
460: ,'RECIPIENT_SP_ID'
461: );
462:

Line 467: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

463: IF l_RECIPIENT_SP_CODE = NULL
464: THEN
465: -- Get the Porting ID from the WI params table
466: l_PORTING_ID :=
467: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
468: (p_WI_INSTANCE_ID
469: ,'PORTING_ID'
470: );
471:

Line 540: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

536: -- directly. If not found there then get it from
537: -- the SOA table
538: ------------------------------------------------------------------
539: l_SENDER_SP_CODE :=
540: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
541: (p_WI_INSTANCE_ID
542: ,'SENDER_NAME'
543: );
544:

Line 706: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

702: IS
703: BEGIN
704:
705: x_RECIPIENT_NAME :=
706: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
707: (p_WI_INSTANCE_ID
708: ,'DONOR_SP_ID'
709: );
710:

Line 737: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

733: IS
734: BEGIN
735:
736: x_RECIPIENT_NAME :=
737: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
738: (p_WI_INSTANCE_ID
739: ,'SENDER_NAME'
740: );
741:

Line 773: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

769: BEGIN
770: x_RETURN_CODE := 0;
771:
772: l_STARTING_NUMBER :=
773: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
774: (p_WI_INSTANCE_ID
775: ,'STARTING_NUMBER'
776: );
777:

Line 779: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

775: ,'STARTING_NUMBER'
776: );
777:
778: l_ENDING_NUMBER :=
779: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
780: (p_WI_INSTANCE_ID
781: ,'ENDING_NUMBER'
782: );
783:

Line 831: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

827: l_GEO_ID NUMBER := 0;
828: l_NRC_ID NUMBER := 0;
829: BEGIN
830: l_starting_number :=
831: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
832: (p_WI_INSTANCE_ID
833: ,'STARTING_NUMBER'
834: );
835:

Line 837: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

833: ,'STARTING_NUMBER'
834: );
835:
836: l_ending_number :=
837: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
838: (p_WI_INSTANCE_ID
839: ,'ENDING_NUMBER'
840: );
841:

Line 891: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

887: )
888: IS
889: BEGIN
890: x_RECIPIENT_NAME :=
891: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
892: (p_WI_INSTANCE_ID
893: ,'RECIPIENT_SP_ID'
894: );
895: exception

Line 1205: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1201: BEGIN
1202: fnd_message.set_name('XNP',p_msg_name);
1203:
1204: l_STARTING_NUMBER :=
1205: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1206: (P_WORKITEM_INSTANCE_ID
1207: ,'STARTING_NUMBER'
1208: );
1209:

Line 1211: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE

1207: ,'STARTING_NUMBER'
1208: );
1209:
1210: l_ENDING_NUMBER :=
1211: XNP_STANDARD.GET_WORKITEM_PARAM_VALUE
1212: (P_WORKITEM_INSTANCE_ID
1213: ,'ENDING_NUMBER'
1214: );
1215: fnd_message.set_token('NUMRANGE'

Line 1431: x_reference_id := xnp_standard.get_mandatory_wi_param_value

1427: ,aname => l_custom_callback_ref_id
1428: );
1429: else
1430: -- get the reference id value from the workitem parameter value
1431: x_reference_id := xnp_standard.get_mandatory_wi_param_value
1432: (p_workitem_instance_id
1433: ,l_wi_param_name
1434: );
1435:

Line 1452: l_param_value := xnp_standard.get_workitem_param_value

1448: )
1449: IS
1450: l_param_value varchar2(200) := null;
1451: BEGIN
1452: l_param_value := xnp_standard.get_workitem_param_value
1453: (p_workitem_instance_id => p_src_wi_id
1454: ,p_parameter_name => p_param_name
1455: );
1456:

Line 1458: xnp_standard.set_workitem_param_value

1454: ,p_parameter_name => p_param_name
1455: );
1456:
1457: -- Set the value in the destination workitem
1458: xnp_standard.set_workitem_param_value
1459: (p_workitem_instance_id=>p_dest_wi_id
1460: ,p_parameter_name=>p_param_name
1461: ,p_parameter_value=>l_param_value
1462: );

Line 1566: l_value := xnp_standard.get_workitem_param_value

1562: l_posn := 0;
1563:
1564: token := replace(token,' ','');
1565:
1566: l_value := xnp_standard.get_workitem_param_value
1567: (p_workitem_instance_id
1568: ,token
1569: );
1570: