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_CORE

Line 2051: XNP_CORE.GET_NUMBER_RANGE_ID

2047: );
2048:
2049: -- Determine the number range id
2050:
2051: XNP_CORE.GET_NUMBER_RANGE_ID
2052: (l_STARTING_NUMBER
2053: ,l_ENDING_NUMBER
2054: ,l_NUMBER_RANGE_ID
2055: ,l_ERROR_CODE

Line 2080: XNP_CORE.SMS_INSERT_FE_MAP

2076: -- Insert the FE MAP for the FE to be provisioned
2077:
2078: /***Changed Call to proc to solve Bug # 2104648 -- 11/21/2001 mviswana***/
2079:
2080: XNP_CORE.SMS_INSERT_FE_MAP
2081: (p_ORDER_ID => l_ORDER_ID,
2082: p_LINEITEM_ID => l_LINEITEM_ID,
2083: p_WORKITEM_INSTANCE_ID => l_WORKITEM_INSTANCE_ID,
2084: p_FA_INSTANCE_ID => l_FA_INSTANCE_ID,

Line 3985: -- Calls XNP_CORE.SOA_SET_LOCKED_FLAG

3981: -- Values: 'Y' or 'N'
3982: -- Item Attr: Gets the Item Attributes WORKITEM_INSTANCE
3983: -- Activity Attr : Gets the value of Activity Attribute FLAG_VALUE
3984: -- Workitem Paramters : PORTING_ID
3985: -- Calls XNP_CORE.SOA_SET_LOCKED_FLAG
3986: --
3987: ------------------------------------------------------------------
3988: PROCEDURE SOA_SET_LOCKED_FLAG
3989: (ITEMTYPE IN VARCHAR2

Line 4050: XNP_CORE.SOA_SET_LOCKED_FLAG

4046: aname => 'FLAG_VALUE');
4047:
4048: -- Set the locked flag
4049:
4050: XNP_CORE.SOA_SET_LOCKED_FLAG
4051: (p_order_id => l_order_id ,
4052: p_lineitem_id => l_lineitem_id,
4053: p_workitem_instance_id => l_workitem_instance_id,
4054: p_fa_instance_id => l_fa_instance_id,

Line 4123: -- Calls XNP_CORE.SOA_GET_LOCKED_FLAG

4119: -- The activity is completed with the flag value
4120: -- Values: 'Y' or 'N'
4121: -- Item Attr: Gets the Item Attributes WORKITEM_INSTANCE
4122: -- Workitem Paramters : PORTING_ID
4123: -- Calls XNP_CORE.SOA_GET_LOCKED_FLAG
4124: --
4125: ------------------------------------------------------------------
4126: PROCEDURE SOA_GET_LOCKED_FLAG
4127: (ITEMTYPE IN VARCHAR2

Line 4175: XNP_CORE.SOA_GET_LOCKED_FLAG

4171: ,'SP_NAME'
4172: );
4173:
4174: -- Get the locked flag
4175: XNP_CORE.SOA_GET_LOCKED_FLAG
4176: (p_porting_id=>l_porting_id
4177: ,p_local_sp_id=>l_local_sp_id
4178: ,x_locked_flag=>l_flag_value
4179: ,x_error_code=>l_error_code

Line 4244: -- Calls XNP_CORE.SOA_CHECK_SV_STATUS

4240: -- Returns: 'T' if statuses match, 'F' if they don't
4241: -- Item Attr: Gets the Item Attributes WORKITEM_INSTANCE
4242: -- Activity Attribute : STATUS_TO_COMPARE_WITH
4243: -- Workitem Paramters : PORTING_ID
4244: -- Calls XNP_CORE.SOA_CHECK_SV_STATUS
4245: --
4246: ------------------------------------------------------------------
4247: PROCEDURE SOA_CHECK_SV_STATUS
4248: (ITEMTYPE IN VARCHAR2

Line 4306: XNP_CORE.SOA_CHECK_SV_STATUS

4302: ,'SP_NAME'
4303: );
4304:
4305: -- Check to see if Statuses matech
4306: XNP_CORE.SOA_CHECK_SV_STATUS
4307: (p_porting_id=>l_porting_id
4308: ,p_local_sp_id=>l_local_sp_id
4309: ,p_STATUS_TYPE_CODE=>l_STATUS_TO_COMPARE_WITH
4310: ,x_STATUS_MATCHED_FLAG=>l_status_matched

Line 4375: -- Calls XNP_CORE.SOA_GET_SV_STATUS

4371: -- PORTING_ID
4372: -- Workitem Parameter: PORTING_ID
4373: -- Item Attr: Gets the Item Attributes WORKITEM_INSTANCE
4374: -- Workitem Paramters : PORTING_ID
4375: -- Calls XNP_CORE.SOA_GET_SV_STATUS
4376: --
4377: ------------------------------------------------------------------
4378: PROCEDURE SOA_GET_SV_STATUS
4379: (ITEMTYPE IN VARCHAR2

Line 4428: XNP_CORE.SOA_GET_SV_STATUS

4424: ,'SP_NAME'
4425: );
4426:
4427: -- Check to see if Statuses matech
4428: XNP_CORE.SOA_GET_SV_STATUS
4429: (p_porting_id=>l_porting_id
4430: ,p_local_sp_id=>l_local_sp_id
4431: ,x_SV_STATUS=>l_sv_status
4432: ,x_error_code=>l_error_code

Line 4807: -- Calls XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE

4803: -- given the PORTING_ID
4804: -- Workitem Parameter: PORTING_ID
4805: -- Item Attr: Gets the Item Attributes WORKITEM_INSTANCE
4806: -- Workitem Paramters : PORTING_ID
4807: -- Calls XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE
4808: --
4809: ------------------------------------------------------------------
4810:
4811: PROCEDURE SOA_UPDATE_NEW_SP_DUE_DATE

Line 4869: XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE

4865: ,'SP_NAME'
4866: );
4867:
4868: -- Set the duedate
4869: XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE
4870: (p_order_id => l_order_id ,
4871: p_lineitem_id => l_lineitem_id,
4872: p_workitem_instance_id => l_workitem_instance_id,
4873: p_fa_instance_id => l_fa_instance_id,

Line 4939: -- Calls XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE

4935: -- given the PORTING_ID
4936: -- Workitem Parameter: PORTING_ID
4937: -- Item Attr: Gets the Item Attributes WORKITEM_INSTANCE
4938: -- Workitem Paramters : PORTING_ID
4939: -- Calls XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE
4940: --
4941: ------------------------------------------------------------------
4942:
4943: PROCEDURE SOA_UPDATE_OLD_SP_DUE_DATE

Line 5002: XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE

4998: ,'SP_NAME'
4999: );
5000:
5001: -- Set the duedate
5002: XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE
5003: (p_order_id => l_order_id ,
5004: p_lineitem_id => l_lineitem_id ,
5005: p_workitem_instance_id => l_workitem_instance_id ,
5006: p_fa_instance_id => l_fa_instance_id ,

Line 5293: -- Calls XNP_CORE.SOA_UPDATE_SV_STATUS

5289: ------------------------------------------------------------------
5290: -- Called when: need to update the SV status according
5291: -- to the activity parameter SV_STATUS
5292: -- Gets the Item Attributes WORKITEM_INSTANCE
5293: -- Calls XNP_CORE.SOA_UPDATE_SV_STATUS
5294: -- Description: Procedure to update the status of
5295: -- the Porting Order Records to the new status
5296: -- for the given PORTING_ID
5297: -- (a.k.a OBJECT_REFERENCE) and

Line 5500: XNP_CORE.SOA_SET_LOCKED_FLAG

5496:
5497: if (l_flag_name = 'LOCKED_FLAG') then
5498: -- Set the locked flag
5499:
5500: XNP_CORE.SOA_SET_LOCKED_FLAG
5501: (p_order_id => l_order_id ,
5502: p_lineitem_id => l_lineitem_id,
5503: p_workitem_instance_id => l_workitem_instance_id,
5504: p_fa_instance_id => l_fa_instance_id,

Line 5512: XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG

5508: x_error_code => l_error_code,
5509: x_error_message => l_error_message
5510: );
5511: elsif (l_flag_name = 'NEW_SP_AUTHORIZATION_FLAG') then
5512: XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG
5513: (p_order_id => l_order_id ,
5514: p_lineitem_id => l_lineitem_id,
5515: p_workitem_instance_id => l_workitem_instance_id,
5516: p_fa_instance_id => l_fa_instance_id,

Line 5524: XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG

5520: x_error_code => l_error_code,
5521: x_error_message => l_error_message
5522: );
5523: elsif (l_flag_name = 'OLD_SP_AUTHORIZATION_FLAG') then
5524: XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG
5525: (p_order_id => l_order_id ,
5526: p_lineitem_id => l_lineitem_id,
5527: p_workitem_instance_id => l_workitem_instance_id,
5528: p_fa_instance_id => l_fa_instance_id,

Line 5537: XNP_CORE.SOA_SET_BLOCKED_FLAG

5533: x_error_message => l_error_message
5534: );
5535: elsif (l_flag_name = 'BLOCKED_FLAG') then
5536: -- Set the blocked flag
5537: XNP_CORE.SOA_SET_BLOCKED_FLAG
5538: (p_order_id => l_order_id ,
5539: p_lineitem_id => l_lineitem_id,
5540: p_workitem_instance_id => l_workitem_instance_id,
5541: p_fa_instance_id => l_fa_instance_id,

Line 5551: XNP_CORE.SOA_SET_CONCURRENCE_FLAG

5547: );
5548: elsif (l_flag_name = 'CONCURRENCE_FLAG') then
5549: -- Set the concurrence flag
5550:
5551: XNP_CORE.SOA_SET_CONCURRENCE_FLAG
5552: (p_order_id => l_order_id ,
5553: p_lineitem_id => l_lineitem_id,
5554: p_workitem_instance_id => l_workitem_instance_id,
5555: p_fa_instance_id => l_fa_instance_id,

Line 5688: XNP_CORE.SOA_GET_LOCKED_FLAG

5684: );
5685:
5686: if (l_flag_name = 'LOCKED_FLAG') then
5687: -- Get the locked flag
5688: XNP_CORE.SOA_GET_LOCKED_FLAG
5689: (p_porting_id=>l_porting_id
5690: ,p_local_sp_id=>l_local_sp_id
5691: ,x_locked_flag=>l_flag_value
5692: ,x_error_code=>l_error_code

Line 5697: XNP_CORE.SOA_GET_BLOCKED_FLAG

5693: ,x_error_message=>l_error_message
5694: );
5695: elsif (l_flag_name = 'BLOCKED_FLAG') then
5696: -- Get the blocked flag
5697: XNP_CORE.SOA_GET_BLOCKED_FLAG
5698: (p_porting_id=>l_porting_id
5699: ,p_local_sp_id=>l_local_sp_id
5700: ,x_blocked_flag=>l_flag_value
5701: ,x_error_code=>l_error_code

Line 5706: XNP_CORE.SOA_GET_NEW_SP_AUTH_FLAG

5702: ,x_error_message=>l_error_message
5703: );
5704: elsif (l_flag_name = 'NEW_SP_AUTHORIZATION_FLAG') then
5705: -- Get the new_sp_auth flag
5706: XNP_CORE.SOA_GET_NEW_SP_AUTH_FLAG
5707: (p_porting_id=>l_porting_id
5708: ,p_local_sp_id=>l_local_sp_id
5709: ,x_new_sp_auth_flag=>l_flag_value
5710: ,x_error_code=>l_error_code

Line 5715: XNP_CORE.SOA_GET_OLD_SP_AUTH_FLAG

5711: ,x_error_message=>l_error_message
5712: );
5713: elsif (l_flag_name = 'OLD_SP_AUTHORIZATION_FLAG') then
5714: -- Get the old_sp_auth flag
5715: XNP_CORE.SOA_GET_OLD_SP_AUTH_FLAG
5716: (p_porting_id=>l_porting_id
5717: ,p_local_sp_id=>l_local_sp_id
5718: ,x_old_sp_auth_flag=>l_flag_value
5719: ,x_error_code=>l_error_code

Line 5724: XNP_CORE.SOA_GET_CONCURRENCE_FLAG

5720: ,x_error_message=>l_error_message
5721: );
5722: elsif (l_flag_name = 'CONCURRENCE_FLAG') then
5723: -- Get the concurrence flag
5724: XNP_CORE.SOA_GET_CONCURRENCE_FLAG
5725: (p_porting_id=>l_porting_id
5726: ,p_local_sp_id=>l_local_sp_id
5727: ,x_concurrence_flag=>l_flag_value
5728: ,x_error_code=>l_error_code

Line 5799: -- Calls XNP_CORE.

5795: --
5796: -- Workitem Parameter: PORTING_ID
5797: -- Item Attr: Gets the Item Attributes WORKITEM_INSTANCE
5798: -- Workitem Paramters : PORTING_ID
5799: -- Calls XNP_CORE.
5800: --
5801: ------------------------------------------------------------------
5802: PROCEDURE SOA_UPDATE_DATE
5803: (ITEMTYPE IN VARCHAR2

Line 5871: XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE

5867: (l_WORKITEM_INSTANCE_ID
5868: ,'NEW_SP_DUE_DATE'
5869: );
5870:
5871: XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE
5872: (p_order_id =>l_order_id,
5873: p_lineitem_id =>l_lineitem_id,
5874: p_workitem_instance_id =>l_workitem_instance_id ,
5875: p_fa_instance_id =>l_fa_instance_id,

Line 5891: XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE

5887: (l_WORKITEM_INSTANCE_ID
5888: ,'OLD_SP_DUE_DATE'
5889: );
5890:
5891: XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE
5892: (p_order_id =>l_order_id,
5893: p_lineitem_id =>l_lineitem_id,
5894: p_workitem_instance_id =>l_workitem_instance_id ,
5895: p_fa_instance_id =>l_fa_instance_id,

Line 5911: XNP_CORE.SOA_UPDATE_ACTIVATION_DUE_DATE

5907: (l_WORKITEM_INSTANCE_ID
5908: ,'ACTIVATION_DUE_DATE'
5909: );
5910:
5911: XNP_CORE.SOA_UPDATE_ACTIVATION_DUE_DATE
5912: (p_order_id =>l_order_id,
5913: p_lineitem_id =>l_lineitem_id,
5914: p_workitem_instance_id =>l_workitem_instance_id ,
5915: p_fa_instance_id =>l_fa_instance_id,

Line 5931: XNP_CORE.SOA_UPDATE_DISCONN_DUE_DATE

5927: (l_WORKITEM_INSTANCE_ID
5928: ,'DISCONNECT_DUE_DATE'
5929: );
5930:
5931: XNP_CORE.SOA_UPDATE_DISCONN_DUE_DATE
5932: (p_order_id =>l_order_id,
5933: p_lineitem_id =>l_lineitem_id,
5934: p_workitem_instance_id =>l_workitem_instance_id ,
5935: p_fa_instance_id =>l_fa_instance_id,

Line 5950: XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE

5946: (l_WORKITEM_INSTANCE_ID
5947: ,'EFFECTIVE_RELEASE_DUE_DATE'
5948: );
5949:
5950: XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE
5951: (p_order_id =>l_order_id,
5952: p_lineitem_id =>l_lineitem_id,
5953: p_workitem_instance_id =>l_workitem_instance_id ,
5954: p_fa_instance_id =>l_fa_instance_id,

Line 5969: XNP_CORE.SOA_UPDATE_NUM_RETURN_DUE_DATE

5965: (l_WORKITEM_INSTANCE_ID
5966: ,'NUMBER_RETURNED_DUE_DATE'
5967: );
5968:
5969: XNP_CORE.SOA_UPDATE_NUM_RETURN_DUE_DATE
5970: (p_order_id =>l_order_id,
5971: p_lineitem_id =>l_lineitem_id,
5972: p_workitem_instance_id =>l_workitem_instance_id ,
5973: p_fa_instance_id =>l_fa_instance_id,

Line 6040: -- calls XNP_CORE.CHECK_IF_SP_ASSIGNED

6036:
6037: --------------------------------------------------------------------
6038: -- Description:
6039: -- Gets the Item Attributes WORKITEM_INSTANCE, ORDER_ID
6040: -- calls XNP_CORE.CHECK_IF_SP_ASSIGNED
6041: -- Completes the path based on the result
6042: -- Mandatory WI params: STARTING_NUMBER,ENDING_NUMBER,DONOR_SP_ID
6043: ------------------------------------------------------------------
6044: PROCEDURE CHECK_IF_DONOR_CAN_PORT_OUT

Line 6099: XNP_CORE.GET_SP_ID

6095: (l_WORKITEM_INSTANCE_ID
6096: ,'DONOR_SP_ID'
6097: );
6098:
6099: XNP_CORE.GET_SP_ID
6100: (p_SP_NAME=>l_DONOR_SP_NAME
6101: ,x_SP_ID=>l_donor_sp_id
6102: ,x_ERROR_CODE=>l_error_code
6103: ,x_ERROR_MESSAGE=>l_error_message

Line 6113: XNP_CORE.CHECK_IF_SP_ASSIGNED

6109:
6110: -- Check this is the SP which has provisioned the
6111: -- entire number range or is the assigned sp id
6112:
6113: XNP_CORE.CHECK_IF_SP_ASSIGNED
6114: (p_STARTING_NUMBER =>l_starting_number
6115: ,p_ENDING_NUMBER =>l_ending_number
6116: ,p_SP_ID =>l_donor_sp_id
6117: ,x_CHECK_IF_ASSIGNED=>l_check_status

Line 6185: -- calls XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR

6181: --------------------------------------------------------------------
6182: -- Description:
6183: -- Checks if the DONOR_SP_ID (WI param) is the Initial donor
6184: -- Gets the Item Attributes WORKITEM_INSTANCE
6185: -- calls XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR
6186: -- Completes the path based on the result
6187: -- Mandatory WI params: STARTING_NUMBER,ENDING_NUMBER,DONOR_SP_ID
6188: ------------------------------------------------------------------
6189: PROCEDURE CHECK_IF_DON_IS_INITIAL_DON

Line 6244: XNP_CORE.GET_SP_ID

6240: (l_WORKITEM_INSTANCE_ID
6241: ,'DONOR_SP_ID'
6242: );
6243:
6244: XNP_CORE.GET_SP_ID
6245: (p_SP_NAME =>l_donor_sp_name
6246: ,x_SP_ID =>l_donor_sp_id
6247: ,x_ERROR_CODE =>l_error_code
6248: ,x_ERROR_MESSAGE=>l_error_message

Line 6257: XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR

6253: END IF;
6254:
6255: -- check if the given donor is the initial donor entire
6256: -- number range
6257: XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR
6258: (p_DONOR_SP_ID =>l_donor_sp_id
6259: ,p_STARTING_NUMBER=>l_starting_number
6260: ,p_ENDING_NUMBER =>l_ending_number
6261: ,x_CHECK_STATUS =>l_check_status

Line 6921: XNP_CORE.SMS_UPDATE_PROV_DONE_DATE

6917: (l_WORKITEM_INSTANCE_ID
6918: ,'ENDING_NUMBER'
6919: );
6920:
6921: XNP_CORE.SMS_UPDATE_PROV_DONE_DATE
6922: (p_order_id => l_order_id,
6923: p_lineitem_id => l_lineitem_id,
6924: p_workitem_instance_id => l_workitem_instance_id,
6925: p_fa_instance_id => l_fa_instance_id,