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_WF_STANDARD dependencies on XNP_STANDARD

Line 261: -- Calls XNP_STANDARD.SMS_CREATE_PORTED_NUMBER

257: -- Called when: there is a Create Ported Number
258: -- request from NRC
259: -- Description:
260: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
261: -- Calls XNP_STANDARD.SMS_CREATE_PORTED_NUMBER
262: ------------------------------------------------------------------
263: PROCEDURE SMS_CREATE_PORTED_NUMBER
264: (ITEMTYPE IN VARCHAR2
265: ,ITEMKEY IN VARCHAR2

Line 304: XNP_STANDARD.SMS_CREATE_PORTED_NUMBER

300:
301: l_ORDER_ID := g_ORDER_ID;
302: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
303:
304: XNP_STANDARD.SMS_CREATE_PORTED_NUMBER
305: (l_ORDER_ID ,
306: l_LINEITEM_ID ,
307: l_WORKITEM_INSTANCE_ID,
308: l_FA_INSTANCE_ID,

Line 370: -- Calls XNP_STANDARD.SMS_DELETE_PORTED_NUMBER

366: -- Called when: there is a Delete Ported Number request
367: -- from NRC
368: -- Description:
369: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
370: -- Calls XNP_STANDARD.SMS_DELETE_PORTED_NUMBER
371: ------------------------------------------------------------------
372: PROCEDURE SMS_DELETE_PORTED_NUMBER
373: (ITEMTYPE IN VARCHAR2
374: ,ITEMKEY IN VARCHAR2

Line 408: XNP_STANDARD.SMS_DELETE_PORTED_NUMBER

404: -- The run code
405:
406: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
407:
408: XNP_STANDARD.SMS_DELETE_PORTED_NUMBER
409: (l_WORKITEM_INSTANCE_ID
410: ,l_error_code
411: ,l_error_message
412: );

Line 469: -- Calls XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE

465: --------------------------------------------------------------------
466: -- Called when: response to OMS's portin req to peer +B1
467: -- Description:
468: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
469: -- Calls XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE
470: ------------------------------------------------------------------
471: PROCEDURE SOA_UPDATE_CUTOFF_DATE
472: (ITEMTYPE IN VARCHAR2
473: ,ITEMKEY IN VARCHAR2

Line 520: XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE

516: itemkey => itemkey,
517: actid => actid,
518: aname => 'CUR_STATUS_TYPE_CODE');
519:
520: XNP_STANDARD.SOA_UPDATE_CUTOFF_DATE
521: (l_ORDER_ID ,
522: L_LINEITEM_ID,
523: l_WORKITEM_INSTANCE_ID,
524: l_FA_INSTANCE_ID,

Line 587: -- Calls XNP_STANDARD.SOA_CREATE_PORTING_ORDER

583: -- Called when: When there is a Porting Order from OMS
584: -- and the
585: -- Description:
586: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
587: -- Calls XNP_STANDARD.SOA_CREATE_PORTING_ORDER
588: ------------------------------------------------------------------
589: PROCEDURE SOA_CREATE_PORTING_ORDER
590: (ITEMTYPE IN VARCHAR2
591: ,ITEMKEY IN VARCHAR2

Line 640: XNP_STANDARD.SOA_CREATE_PORTING_ORDER

636: IF (l_sp_role IS NULL) THEN
637: raise e_SOA_CREATE_PORTING_ORDER;
638: END IF;
639:
640: XNP_STANDARD.SOA_CREATE_PORTING_ORDER
641: (l_ORDER_ID,
642: l_LINEITEM_ID,
643: l_WORKITEM_INSTANCE_ID,
644: l_FA_INSTANCE_ID,

Line 708: -- Calls XNP_STANDARD.SOA_UPDATE_SV_STATUS

704: -- Called when: need to update the SV status according
705: -- to the activity parameter SV_STATUS
706: -- Description:
707: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
708: -- Calls XNP_STANDARD.SOA_UPDATE_SV_STATUS
709: ------------------------------------------------------------------
710: PROCEDURE SOA_UPDATE_SV_STATUS
711: (ITEMTYPE IN VARCHAR2
712: ,ITEMKEY IN VARCHAR2

Line 766: XNP_STANDARD.SOA_UPDATE_SV_STATUS

762: itemkey => itemkey,
763: actid => actid,
764: aname => 'STATUS_CHANGE_CAUSE_CODE');
765:
766: XNP_STANDARD.SOA_UPDATE_SV_STATUS
767: (p_ORDER_ID => l_ORDER_ID ,
768: p_LINEITEM_ID => l_LINEITEM_ID,
769: p_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID,
770: p_FA_INSTANCE_ID => l_FA_INSTANCE_ID,

Line 835: -- Calls XNP_STANDARD.SOA_CHECK_IF_INITIAL_DONOR

831: -- Called when: donor needs to check if initial donor
832: -- for the TN range
833: -- Description:
834: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
835: -- Calls XNP_STANDARD.SOA_CHECK_IF_INITIAL_DONOR
836: -- Sets the RESULTOUT based on the result
837: ------------------------------------------------------------------
838: PROCEDURE DETERMINE_SP_ROLE
839: (ITEMTYPE IN VARCHAR2

Line 874: XNP_STANDARD.DETERMINE_SP_ROLE

870: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
871:
872: -- Check to see if initial donor
873:
874: XNP_STANDARD.DETERMINE_SP_ROLE
875: (l_WORKITEM_INSTANCE_ID
876: ,l_SP_ROLE
877: ,l_error_code
878: ,l_error_message

Line 1044: XNP_STANDARD.SUBSCRIBE_FOR_EVENT

1040:
1041: ------------------------------------------------------------------
1042: -- Subscribe for this event
1043: ------------------------------------------------------------------
1044: XNP_STANDARD.SUBSCRIBE_FOR_EVENT
1045: (p_MESSAGE_TYPE=>l_MESSAGE_TYPE
1046: ,p_WORKITEM_INSTANCE_ID=>l_WORKITEM_INSTANCE_ID
1047: ,p_CALLBACK_REF_ID=>l_CALLBACK_REF_ID
1048: ,p_PROCESS_REFERENCE=>l_PROCESS_REFERENCE

Line 1112: -- Calls XNP_STANDARD SUBSCRIBE_FOR_ACKS

1108:
1109:
1110: ------------------------------------------------------------------
1111: -- Registers for Acks corr to sent message
1112: -- Calls XNP_STANDARD SUBSCRIBE_FOR_ACKS
1113: ------------------------------------------------------------------
1114: PROCEDURE SUBSCRIBE_FOR_ACKS
1115: (ITEMTYPE IN VARCHAR2
1116: ,ITEMKEY IN VARCHAR2

Line 1749: -- calls XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS

1745:
1746: --------------------------------------------------------------------
1747: -- Description:
1748: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
1749: -- calls XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS
1750: -- Completes the path based on the result
1751: ------------------------------------------------------------------
1752: PROCEDURE SOA_CHECK_NOTIFY_DIR_SVS
1753: (ITEMTYPE IN VARCHAR2

Line 1788: XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS

1784: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
1785:
1786: -- Get the value of to flag
1787:
1788: XNP_STANDARD.SOA_CHECK_NOTIFY_DIR_SVS
1789: (l_WORKITEM_INSTANCE_ID
1790: ,l_check_status
1791: ,l_error_code
1792: ,l_error_message

Line 1862: -- calls XNP_STANDARD.UPDATE_CHARGING_INFO

1858: --------------------------------------------------------------------
1859: -- Called at: Recipient side when charging info is recd
1860: -- Description:
1861: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
1862: -- calls XNP_STANDARD.UPDATE_CHARGING_INFO
1863: ------------------------------------------------------------------
1864: PROCEDURE SOA_UPDATE_CHARGING_INFO
1865: (ITEMTYPE IN VARCHAR2
1866: ,ITEMKEY IN VARCHAR2

Line 1906: XNP_STANDARD.SOA_UPDATE_CHARGING_INFO

1902: l_ORDER_ID := g_ORDER_ID;
1903: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
1904:
1905: -- Update the charging info
1906: XNP_STANDARD.SOA_UPDATE_CHARGING_INFO
1907: (l_ORDER_ID ,
1908: l_LINEITEM_ID,
1909: l_WORKITEM_INSTANCE_ID,
1910: l_FA_INSTANCE_ID,

Line 2038: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2034: actid => actid,
2035: aname => 'FEATURE_TYPE');
2036:
2037: l_STARTING_NUMBER :=
2038: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2039: (l_WORKITEM_INSTANCE_ID
2040: ,'STARTING_NUMBER'
2041: );
2042:

Line 2044: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

2040: ,'STARTING_NUMBER'
2041: );
2042:
2043: l_ENDING_NUMBER :=
2044: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
2045: (l_WORKITEM_INSTANCE_ID
2046: ,'ENDING_NUMBER'
2047: );
2048:

Line 2203: -- calls XNP_STANDARD.SOA_CHECK_ORDER_STATUS

2199:
2200: --------------------------------------------------------------------
2201: -- Called when: Checks the order/inquiry response
2202: -- Description:
2203: -- calls XNP_STANDARD.SOA_CHECK_ORDER_STATUS
2204: -- and completes the activityn based on the result
2205: ------------------------------------------------------------------
2206:
2207: PROCEDURE SOA_CHECK_ORDER_STATUS

Line 2242: XNP_STANDARD.SOA_CHECK_ORDER_STATUS

2238:
2239: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
2240:
2241: -- Get the order status value
2242: XNP_STANDARD.SOA_CHECK_ORDER_STATUS
2243: (l_WORKITEM_INSTANCE_ID
2244: ,l_ORDER_STATUS
2245: ,l_error_code
2246: ,l_error_message

Line 2419: XNP_STANDARD.PUBLISH_EVENT

2415: end if;
2416:
2417: -- Invoke publish event
2418:
2419: XNP_STANDARD.PUBLISH_EVENT
2420: (p_ORDER_ID => l_ORDER_ID
2421: ,p_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID
2422: ,p_FA_INSTANCE_ID => l_FA_INSTANCE_ID
2423: ,p_EVENT_TYPE => l_EVENT_TYPE

Line 2537: XNP_STANDARD.CHECK_SOA_STATUS_EXISTS

2533: actid => actid,
2534: aname => 'STATUS_TYPE_CODE');
2535:
2536: -- Get the order status value
2537: XNP_STANDARD.CHECK_SOA_STATUS_EXISTS
2538: (l_WORKITEM_INSTANCE_ID
2539: ,l_STATUS_TYPE_CODE
2540: ,l_CHECK_STATUS
2541: ,l_error_code

Line 2656: XNP_STANDARD.SET_ORDER_RESULT

2652: l_ORDER_STATUS := g_ORDER_ID;
2653:
2654:
2655: -- Set the order result value
2656: XNP_STANDARD.SET_ORDER_RESULT
2657: (l_WORKITEM_INSTANCE_ID
2658: ,l_ORDER_STATUS
2659: ,l_ORDER_REJECT_CODE
2660: ,l_ORDER_REJECT_EXPLN

Line 2758: XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT

2754: -- The run code
2755:
2756: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
2757:
2758: XNP_STANDARD.SOA_IS_SUBSEQUENT_PORT
2759: (l_WORKITEM_INSTANCE_ID
2760: ,l_CHECK_STATUS
2761: ,l_error_code
2762: ,l_error_message

Line 3008: XNP_STANDARD.SEND_MESSAGE

3004:
3005: ------------------------------------------------------------------
3006: -- If send succeedes then increment version number
3007: ------------------------------------------------------------------
3008: XNP_STANDARD.SEND_MESSAGE
3009: (l_ORDER_ID
3010: ,l_WORKITEM_INSTANCE_ID
3011: ,l_FA_INSTANCE_ID
3012: ,l_EVENT_TYPE

Line 3166: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3162: ,aname => 'FEATURE_TYPE'
3163: );
3164:
3165: l_STARTING_NUMBER :=
3166: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3167: (l_WORKITEM_INSTANCE_ID
3168: ,'STARTING_NUMBER'
3169: );
3170:

Line 3172: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

3168: ,'STARTING_NUMBER'
3169: );
3170:
3171: l_ENDING_NUMBER :=
3172: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
3173: (l_WORKITEM_INSTANCE_ID
3174: ,'ENDING_NUMBER'
3175: );
3176:

Line 3304: -- and fe id and calls XNP_STANDARD.SMS_DELETE_FE_MAP

3300: -- Description:
3301: -- Deletes mapping rows from the SMS sv id and the fe id
3302: -- for the feature type
3303: -- Gets values of the item attributes workitem instance id
3304: -- and fe id and calls XNP_STANDARD.SMS_DELETE_FE_MAP
3305: ------------------------------------------------------------------
3306: PROCEDURE SMS_DELETE_FE_MAP
3307: (ITEMTYPE IN VARCHAR2
3308: ,ITEMKEY IN VARCHAR2

Line 3357: XNP_STANDARD.SMS_DELETE_FE_MAP

3353: actid => actid,
3354: aname => 'FEATURE_TYPE');
3355:
3356: -- Delete the fe map
3357: XNP_STANDARD.SMS_DELETE_FE_MAP
3358: (l_WORKITEM_INSTANCE_ID
3359: ,l_FE_ID
3360: ,l_FEATURE_TYPE
3361: ,l_error_code

Line 3425: -- calls XNP_STANDARD.CHECK_PHASE_FOR_ROLE

3421: -- Description: Checks if there exists a
3422: -- SV for the given TN range in that phase
3423: -- and in for the given SP Role i.e. as donor
3424: -- or recipient
3425: -- calls XNP_STANDARD.CHECK_PHASE_FOR_ROLE
3426: -- Completes activity with 'Y' or 'N'
3427: ------------------------------------------------------------------
3428: PROCEDURE CHECK_PHASE_FOR_ROLE
3429: (ITEMTYPE IN VARCHAR2

Line 3485: XNP_STANDARD.CHECK_PHASE_FOR_ROLE

3481: ,aname => 'PHASE'
3482: );
3483:
3484: -- Check if an SV exists in that phase
3485: XNP_STANDARD.CHECK_PHASE_FOR_ROLE
3486: (l_WORKITEM_INSTANCE_ID
3487: ,l_SP_ROLE
3488: ,l_PHASE_INDICATOR
3489: ,l_CHECK_STATUS

Line 3627: XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS

3623: itemkey => itemkey,
3624: actid => actid,
3625: aname => 'PROV_STATUS');
3626:
3627: XNP_STANDARD.SMS_UPDATE_FE_MAP_STATUS
3628: (l_ORDER_ID ,
3629: l_LINEITEM_ID,
3630: l_WORKITEM_INSTANCE_ID,
3631: l_FA_INSTANCE_ID,

Line 4031: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4027: l_ORDER_ID := g_WORKITEM_INSTANCE_ID;
4028: l_WORKITEM_INSTANCE_ID := g_ORDER_ID;
4029:
4030: l_PORTING_ID :=
4031: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4032: (l_WORKITEM_INSTANCE_ID
4033: ,'PORTING_ID'
4034: );
4035:

Line 4037: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4033: ,'PORTING_ID'
4034: );
4035:
4036: l_sp_name :=
4037: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4038: (l_WORKITEM_INSTANCE_ID
4039: ,'SP_NAME'
4040: );
4041:

Line 4163: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4159:
4160: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
4161:
4162: l_PORTING_ID :=
4163: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4164: (l_WORKITEM_INSTANCE_ID
4165: ,'PORTING_ID'
4166: );
4167:

Line 4169: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4165: ,'PORTING_ID'
4166: );
4167:
4168: l_sp_name :=
4169: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4170: (l_WORKITEM_INSTANCE_ID
4171: ,'SP_NAME'
4172: );
4173:

Line 4285: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4281:
4282: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
4283:
4284: l_PORTING_ID :=
4285: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4286: (l_WORKITEM_INSTANCE_ID
4287: ,'PORTING_ID'
4288: );
4289:

Line 4300: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4296: );
4297:
4298:
4299: l_sp_name :=
4300: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4301: (l_WORKITEM_INSTANCE_ID
4302: ,'SP_NAME'
4303: );
4304:

Line 4415: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4411:
4412: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
4413:
4414: l_PORTING_ID :=
4415: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4416: (l_WORKITEM_INSTANCE_ID
4417: ,'PORTING_ID'
4418: );
4419:

Line 4422: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4418: );
4419:
4420:
4421: l_sp_name :=
4422: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4423: (l_WORKITEM_INSTANCE_ID
4424: ,'SP_NAME'
4425: );
4426:

Line 4565: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4561: ,aname => 'FEATURE_TYPE'
4562: );
4563:
4564: l_STARTING_NUMBER :=
4565: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4566: (l_WORKITEM_INSTANCE_ID
4567: ,'STARTING_NUMBER'
4568: );
4569:

Line 4571: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4567: ,'STARTING_NUMBER'
4568: );
4569:
4570: l_ENDING_NUMBER :=
4571: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4572: (l_WORKITEM_INSTANCE_ID
4573: ,'ENDING_NUMBER'
4574: );
4575:

Line 4698: -- Calls XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER

4694: -- Called when: there is a Modify Ported Number
4695: -- request from NRC
4696: -- Description:
4697: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
4698: -- Calls XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER
4699: ------------------------------------------------------------------
4700: PROCEDURE SMS_MODIFY_PORTED_NUMBER
4701: (ITEMTYPE IN VARCHAR2
4702: ,ITEMKEY IN VARCHAR2

Line 4740: XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER

4736: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
4737:
4738: -- The run code
4739:
4740: XNP_STANDARD.SMS_MODIFY_PORTED_NUMBER
4741: (l_ORDER_ID ,
4742: l_LINEITEM_ID,
4743: l_WORKITEM_INSTANCE_ID,
4744: l_FA_INSTANCE_ID,

Line 4851: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4847: l_ORDER_ID := g_ORDER_ID;
4848: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
4849:
4850: l_PORTING_ID :=
4851: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4852: (l_WORKITEM_INSTANCE_ID
4853: ,'PORTING_ID'
4854: );
4855:

Line 4857: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4853: ,'PORTING_ID'
4854: );
4855:
4856: l_NEW_SP_DUE_DATE :=
4857: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4858: (l_WORKITEM_INSTANCE_ID
4859: ,'NEW_SP_DUE_DATE'
4860: );
4861:

Line 4863: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4859: ,'NEW_SP_DUE_DATE'
4860: );
4861:
4862: l_sp_name :=
4863: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4864: (l_WORKITEM_INSTANCE_ID
4865: ,'SP_NAME'
4866: );
4867:

Line 4983: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4979: l_ORDER_ID := g_ORDER_ID;
4980: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
4981:
4982: l_PORTING_ID :=
4983: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4984: (l_WORKITEM_INSTANCE_ID
4985: ,'PORTING_ID'
4986: );
4987:

Line 4989: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4985: ,'PORTING_ID'
4986: );
4987:
4988: l_OLD_SP_DUE_DATE :=
4989: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4990: (l_WORKITEM_INSTANCE_ID
4991: ,'OLD_SP_DUE_DATE'
4992: );
4993:

Line 4996: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

4992: );
4993:
4994:
4995: l_sp_name :=
4996: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
4997: (l_WORKITEM_INSTANCE_ID
4998: ,'SP_NAME'
4999: );
5000:

Line 5114: XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS

5110: ,actid => actid
5111: ,aname => 'STATUS_TO_COMPARE_WITH'
5112: );
5113:
5114: XNP_STANDARD.SOA_CHECK_DON_STATUS_EXISTS
5115: (p_WORKITEM_INSTANCE_ID =>l_workitem_instance_id
5116: ,p_status_to_check_with =>l_status_to_compare_with
5117: ,x_CHECK_STATUS =>x_check_status
5118: ,x_ERROR_CODE =>l_error_code

Line 5225: XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS

5221: ,actid => actid
5222: ,aname => 'STATUS_TO_COMPARE_WITH'
5223: );
5224:
5225: XNP_STANDARD.SOA_CHECK_REC_STATUS_EXISTS
5226: (p_WORKITEM_INSTANCE_ID =>l_workitem_instance_id
5227: ,p_status_to_check_with =>l_status_to_compare_with
5228: ,x_CHECK_STATUS =>x_check_status
5229: ,x_ERROR_CODE =>l_error_code

Line 5354: XNP_STANDARD.SOA_UPDATE_SV_STATUS

5350: itemkey => itemkey,
5351: actid => actid,
5352: aname => 'STATUS_CHANGE_CAUSE_CODE');
5353:
5354: XNP_STANDARD.SOA_UPDATE_SV_STATUS
5355: (p_ORDER_ID => l_ORDER_ID ,
5356: p_LINEITEM_ID => l_LINEITEM_ID ,
5357: p_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID,
5358: p_FA_INSTANCE_ID => l_FA_INSTANCE_ID ,

Line 5472: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5468: l_ORDER_ID := g_ORDER_ID;
5469: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
5470:
5471: l_PORTING_ID :=
5472: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5473: (l_WORKITEM_INSTANCE_ID
5474: ,'PORTING_ID'
5475: );
5476:

Line 5478: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5474: ,'PORTING_ID'
5475: );
5476:
5477: l_sp_name :=
5478: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5479: (l_WORKITEM_INSTANCE_ID
5480: ,'SP_NAME'
5481: );
5482:

Line 5667: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5663:
5664: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
5665:
5666: l_PORTING_ID :=
5667: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5668: (l_WORKITEM_INSTANCE_ID
5669: ,'PORTING_ID'
5670: );
5671:

Line 5673: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5669: ,'PORTING_ID'
5670: );
5671:
5672: l_sp_name :=
5673: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5674: (l_WORKITEM_INSTANCE_ID
5675: ,'SP_NAME'
5676: );
5677:

Line 5844: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5840: l_ORDER_ID := g_ORDER_ID;
5841: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
5842:
5843: l_PORTING_ID :=
5844: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5845: (l_WORKITEM_INSTANCE_ID
5846: ,'PORTING_ID'
5847: );
5848:

Line 5850: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5846: ,'PORTING_ID'
5847: );
5848:
5849: l_sp_name :=
5850: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5851: (l_WORKITEM_INSTANCE_ID
5852: ,'SP_NAME'
5853: );
5854:

Line 5866: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5862:
5863: if (l_date_name = 'NEW_SP_DUE_DATE') then
5864:
5865: l_date_value :=
5866: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5867: (l_WORKITEM_INSTANCE_ID
5868: ,'NEW_SP_DUE_DATE'
5869: );
5870:

Line 5886: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5882:
5883: elsif (l_date_name = 'OLD_SP_DUE_DATE') then
5884:
5885: l_date_value :=
5886: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5887: (l_WORKITEM_INSTANCE_ID
5888: ,'OLD_SP_DUE_DATE'
5889: );
5890:

Line 5906: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5902:
5903: elsif (l_date_name = 'ACTIVATION_DUE_DATE') then
5904:
5905: l_date_value :=
5906: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5907: (l_WORKITEM_INSTANCE_ID
5908: ,'ACTIVATION_DUE_DATE'
5909: );
5910:

Line 5926: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5922:
5923: elsif (l_date_name = 'DISCONNECT_DUE_DATE') then
5924:
5925: l_date_value :=
5926: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5927: (l_WORKITEM_INSTANCE_ID
5928: ,'DISCONNECT_DUE_DATE'
5929: );
5930:

Line 5945: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5941:
5942: elsif (l_date_name = 'EFFECTIVE_RELEASE_DUE_DATE') then
5943:
5944: l_date_value :=
5945: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5946: (l_WORKITEM_INSTANCE_ID
5947: ,'EFFECTIVE_RELEASE_DUE_DATE'
5948: );
5949:

Line 5964: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

5960:
5961: elsif (l_date_name = 'NUMBER_RETURNED_DUE_DATE') then
5962:
5963: l_date_value :=
5964: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
5965: (l_WORKITEM_INSTANCE_ID
5966: ,'NUMBER_RETURNED_DUE_DATE'
5967: );
5968:

Line 6082: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6078:
6079: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6080:
6081: l_STARTING_NUMBER :=
6082: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6083: (l_WORKITEM_INSTANCE_ID
6084: ,'STARTING_NUMBER'
6085: );
6086:

Line 6088: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6084: ,'STARTING_NUMBER'
6085: );
6086:
6087: l_ENDING_NUMBER :=
6088: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6089: (l_WORKITEM_INSTANCE_ID
6090: ,'ENDING_NUMBER'
6091: );
6092:

Line 6094: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6090: ,'ENDING_NUMBER'
6091: );
6092:
6093: l_DONOR_SP_NAME :=
6094: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6095: (l_WORKITEM_INSTANCE_ID
6096: ,'DONOR_SP_ID'
6097: );
6098:

Line 6227: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6223:
6224: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6225:
6226: l_STARTING_NUMBER :=
6227: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6228: (l_WORKITEM_INSTANCE_ID
6229: ,'STARTING_NUMBER'
6230: );
6231:

Line 6233: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6229: ,'STARTING_NUMBER'
6230: );
6231:
6232: l_ENDING_NUMBER :=
6233: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6234: (l_WORKITEM_INSTANCE_ID
6235: ,'ENDING_NUMBER'
6236: );
6237:

Line 6239: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6235: ,'ENDING_NUMBER'
6236: );
6237:
6238: l_DONOR_SP_NAME :=
6239: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6240: (l_WORKITEM_INSTANCE_ID
6241: ,'DONOR_SP_ID'
6242: );
6243:

Line 6364: XNP_STANDARD.SOA_UPDATE_NOTES_INFO

6360:
6361: l_ORDER_ID := g_ORDER_ID;
6362: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6363:
6364: XNP_STANDARD.SOA_UPDATE_NOTES_INFO
6365: (l_order_id,
6366: l_lineitem_id,
6367: l_WORKITEM_INSTANCE_ID,
6368: l_fa_instance_id,

Line 6464: XNP_STANDARD.SOA_UPDATE_NETWORK_INFO

6460:
6461: l_ORDER_ID := g_ORDER_ID;
6462: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6463:
6464: XNP_STANDARD.SOA_UPDATE_NETWORK_INFO
6465: (l_order_id,
6466: l_lineitem_id,
6467: l_WORKITEM_INSTANCE_ID,
6468: l_fa_instance_id,

Line 6565: XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO

6561:
6562: l_ORDER_ID := g_ORDER_ID;
6563: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6564:
6565: XNP_STANDARD.SOA_UPDATE_CUSTOMER_INFO
6566: (l_order_id,
6567: l_lineitem_id,
6568: l_workitem_instance_id,
6569: l_fa_instance_id,

Line 6745: -- Calls XNP_STANDARD.SOA_UPDATE_SV_STATUS

6741: -- Called when: need to update the SV status according
6742: -- to the activity parameter SV_STATUS
6743: -- Description:
6744: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
6745: -- Calls XNP_STANDARD.SOA_UPDATE_SV_STATUS
6746: ------------------------------------------------------------------
6747: PROCEDURE SOA_UPDATE_CUR_SV_STATUS
6748: (ITEMTYPE IN VARCHAR2
6749: ,ITEMKEY IN VARCHAR2

Line 6807: XNP_STANDARD.SOA_UPDATE_SV_STATUS

6803: itemkey => itemkey,
6804: actid => actid,
6805: aname => 'STATUS_CHANGE_CAUSE_CODE');
6806:
6807: XNP_STANDARD.SOA_UPDATE_SV_STATUS
6808: (p_ORDER_ID => L_ORDER_ID,
6809: p_LINEITEM_ID =>l_LINEITEM_ID,
6810: p_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID,
6811: p_FA_INSTANCE_ID => l_FA_INSTANCE_ID,

Line 6910: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6906: l_ORDER_ID := g_ORDER_ID;
6907: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
6908:
6909: l_STARTING_NUMBER :=
6910: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6911: (l_WORKITEM_INSTANCE_ID
6912: ,'STARTING_NUMBER'
6913: );
6914:

Line 6916: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE

6912: ,'STARTING_NUMBER'
6913: );
6914:
6915: l_ENDING_NUMBER :=
6916: XNP_STANDARD.GET_MANDATORY_WI_PARAM_VALUE
6917: (l_WORKITEM_INSTANCE_ID
6918: ,'ENDING_NUMBER'
6919: );
6920:

Line 7032: XNP_STANDARD.RUNTIME_VALIDATION

7028: wf_engine.GetItemAttrNumber (itemtype => itemtype,
7029: itemkey => itemkey,
7030: aname => 'LINE_ITEM_ID');
7031:
7032: XNP_STANDARD.RUNTIME_VALIDATION
7033: (p_ORDER_ID => l_ORDER_ID
7034: ,p_LINE_ITEM_ID => l_lIne_Item_ID
7035: ,p_WORKITEM_INSTANCE_ID =>l_WORKITEM_INSTANCE_ID
7036: ,x_ERROR_CODE => l_error_code

Line 7538: XNP_STANDARD.DEREGISTER_ALL

7534: -- The run code
7535:
7536: -- Get the event type to publish
7537:
7538: XNP_STANDARD.DEREGISTER_ALL
7539: (
7540: p_order_id => l_order_id
7541: ,x_error_code => l_error_code
7542: ,x_error_message => l_error_message