DBA Data[Home] [Help]

APPS.XNP_UTILS dependencies on XNP_CORE

Line 241: XNP_CORE.GET_SP_ID

237: WHERE OBJECT_REFERENCE = l_PORTING_ID;
238:
239: ELSE
240:
241: XNP_CORE.GET_SP_ID
242: (p_SP_NAME=>l_DONOR_SP_CODE
243: ,x_SP_ID=>l_DONOR_SP_ID
244: ,x_ERROR_CODE=>x_RETURN_CODE
245: ,x_ERROR_MESSAGE=>x_ERROR_DESCRIPTION

Line 317: XNP_CORE.GET_ASSIGNED_SP_ID

313: (p_WI_INSTANCE_ID
314: ,'ENDING_NUMBER'
315: );
316:
317: XNP_CORE.GET_ASSIGNED_SP_ID
318: (p_STARTING_NUMBER=>l_STARTING_NUMBER
319: ,p_ENDING_NUMBER=>l_ENDING_NUMBER
320: ,x_ASSIGNED_SP_ID=>l_ORIGINAL_DONOR_SP_ID
321: ,x_ERROR_CODE=>x_RETURN_CODE

Line 393: XNP_CORE.GET_NRC_ID

389: (p_WI_INSTANCE_ID
390: ,'ENDING_NUMBER'
391: );
392:
393: XNP_CORE.GET_NRC_ID
394: (p_STARTING_NUMBER=>l_STARTING_NUMBER
395: ,p_ENDING_NUMBER=>l_ENDING_NUMBER
396: ,x_NRC_ID=>l_NRC_SP_ID
397: ,x_ERROR_CODE=>x_RETURN_CODE

Line 478: XNP_CORE.GET_SP_ID

474: FROM XNP_SV_SOA
475: WHERE OBJECT_REFERENCE = l_PORTING_ID;
476: ELSE
477:
478: XNP_CORE.GET_SP_ID
479: (p_SP_NAME=>l_RECIPIENT_SP_CODE
480: ,x_SP_ID=>l_RECIPIENT_SP_ID
481: ,x_ERROR_CODE=>x_RETURN_CODE
482: ,x_ERROR_MESSAGE=>x_ERROR_DESCRIPTION

Line 545: XNP_CORE.GET_SP_ID

541: (p_WI_INSTANCE_ID
542: ,'SENDER_NAME'
543: );
544:
545: XNP_CORE.GET_SP_ID
546: (p_SP_NAME=>l_SENDER_SP_CODE
547: ,x_SP_ID=>l_SENDER_SP_ID
548: ,x_ERROR_CODE=>x_RETURN_CODE
549: ,x_ERROR_MESSAGE=>x_ERROR_DESCRIPTION

Line 784: XNP_CORE.GET_ASSIGNED_SP_ID

780: (p_WI_INSTANCE_ID
781: ,'ENDING_NUMBER'
782: );
783:
784: XNP_CORE.GET_ASSIGNED_SP_ID
785: (p_STARTING_NUMBER=>l_STARTING_NUMBER
786: ,p_ENDING_NUMBER=>l_ENDING_NUMBER
787: ,x_ASSIGNED_SP_ID=>l_ORIGINAL_DONOR_SP_ID
788: ,x_ERROR_CODE=>x_RETURN_CODE

Line 796: XNP_CORE.GET_SP_NAME

792: THEN
793: RETURN;
794: END IF;
795:
796: XNP_CORE.GET_SP_NAME
797: (l_ORIGINAL_DONOR_SP_ID
798: ,x_RECIPIENT_NAME
799: ,x_RETURN_CODE
800: ,x_ERROR_DESCRIPTION

Line 844: XNP_CORE.GET_NRC_ID

840: );
841:
842: -- Get the NRC id
843:
844: XNP_CORE.GET_NRC_ID
845: (l_STARTING_NUMBER
846: ,l_ENDING_NUMBER
847: ,l_NRC_ID
848: ,x_RETURN_CODE

Line 855: XNP_CORE.GET_SP_NAME

851: if x_return_code <> 0 then
852: return;
853: end if;
854:
855: XNP_CORE.GET_SP_NAME
856: (l_NRC_ID
857: ,x_RECIPIENT_NAME
858: ,x_RETURN_CODE
859: ,x_ERROR_DESCRIPTION