DBA Data[Home] [Help]

APPS.XNP_STANDARD dependencies on XNP_SV_SOA

Line 1382: -- XNP_SV_SOA to the given status

1378:
1379:
1380: ------------------------------------------------------------------
1381: -- Procedure used to update the status of a SV in
1382: -- XNP_SV_SOA to the given status
1383: -- Using the WORKITEM_INSTANCE_ID the starting and ending TN
1384: -- is found to derive the SV
1385: -- The foll WI params are checked STARTING_NUMBER,
1386: -- ENDING_NUMBER, PORTING_ID

Line 3130: FROM xnp_sv_soa

3126:
3127:
3128: CURSOR c_CUR_STATUS IS
3129: SELECT status_type_code
3130: FROM xnp_sv_soa
3131: WHERE object_reference = l_porting_id;
3132:
3133: BEGIN
3134: x_error_code := 0;

Line 3319: -- Porting id in XNP_SV_SOA

3315:
3316:
3317: ------------------------------------------------------------------
3318: -- Updates the Network information for the given
3319: -- Porting id in XNP_SV_SOA
3320: -- Mandatory WI parameter: ROUTING_NUMBER
3321: -- Optional WI Params: ROUTING_NUMBER,
3322: -- CNAM_ADDRESS, CNAM_SUBSYSTEM, ISVM_ADDRESS
3323: -- ISVM_SUBSYSTEM, LIDB_ADDRESS, LIDB_SUBSYSTEM