APPS.XNP_CORE dependencies on XNP_SV_STATUS_TYPES_B

Line 435: FROM xnp_sv_soa SOA , xnp_sv_status_types_b STA

431: IS
432:
433: CURSOR c_sv_id IS
434: SELECT sv_soa_id
435: FROM xnp_sv_soa SOA , xnp_sv_status_types_b STA
436: WHERE SOA.subscription_tn = p_subscription_tn
437: AND STA.phase_indicator = p_phase_indicator
438: AND STA.status_type_code = SOA.status_type_code;
439:

Line 501: FROM xnp_sv_status_types_b

497: )
498: IS
499: CURSOR c_phase_indicator IS
500: SELECT phase_indicator
501: FROM xnp_sv_status_types_b
502: WHERE status_type_code = p_cur_status_type_code;
503:
504:
505: BEGIN

Line 912: xnp_sv_status_types_b sta

908:
909: SELECT sv_soa_id BULK COLLECT
910: INTO l_sv_soa_id
911: FROM xnp_sv_soa soa,
912: xnp_sv_status_types_b sta
913: WHERE soa.subscription_tn
914: BETWEEN l_starting_number AND l_ending_number
915: AND sta.phase_indicator = l_phase_indicator
916: AND sta.status_type_code = soa.status_type_code;

Line 1021: xnp_sv_status_types_b sta

1017: soa.status_type_code BULK COLLECT
1018: INTO l_sv_soa_id,
1019: l_sv_event_code
1020: FROM xnp_sv_soa soa,
1021: xnp_sv_status_types_b sta
1022: WHERE SOA.subscription_tn BETWEEN l_starting_number AND l_ending_number
1023: AND STA.phase_indicator = l_phase_indicator
1024: AND STA.status_type_code = SOA.status_type_code;
1025:

Line 1162: l_new_status_type_code xnp_sv_status_types_b.STATUS_TYPE_CODE%TYPE;

1158: l_counter BINARY_INTEGER := 0;
1159: l_SP_ID NUMBER;
1160: l_diff NUMBER := (p_ending_number - p_starting_number);
1161: l_init NUMBER := p_starting_number;
1162: l_new_status_type_code xnp_sv_status_types_b.STATUS_TYPE_CODE%TYPE;
1163: l_nrc_id NUMBER := 0;
1164: l_assigned_sp_id NUMBER := 0;
1165: l_mediator_sp_id NUMBER := 0;
1166: l_pto_flag VARCHAR2(1);

Line 1485: l_new_status_type_code xnp_sv_status_types_b.STATUS_TYPE_CODE%TYPE;

1481: l_counter BINARY_INTEGER := 0;
1482: l_sp_id NUMBER;
1483: l_diff NUMBER := (p_ending_number - p_starting_number);
1484: l_init NUMBER := p_starting_number;
1485: l_new_status_type_code xnp_sv_status_types_b.STATUS_TYPE_CODE%TYPE;
1486: l_nrc_id NUMBER := 0;
1487: l_assigned_sp_id NUMBER := 0;
1488: l_mediator_sp_id NUMBER := 0;
1489: l_pto_flag VARCHAR2(1);

Line 1876: l_NEW_STATUS_TYPE_CODE xnp_sv_status_types_b.STATUS_TYPE_CODE%TYPE;

1872: l_counter BINARY_INTEGER;
1873: l_SP_ID NUMBER;
1874: l_diff NUMBER := (p_ENDING_NUMBER - p_STARTING_NUMBER);
1875: l_init NUMBER := p_STARTING_NUMBER;
1876: l_NEW_STATUS_TYPE_CODE xnp_sv_status_types_b.STATUS_TYPE_CODE%TYPE;
1877: l_NRC_ID NUMBER := 0;
1878: l_ASSIGNED_SP_ID NUMBER := 0;
1879: l_MEDIATOR_SP_ID NUMBER := 0;
1880: l_PTO_FLAG VARCHAR2(1);

Line 2280: l_PHASE_INDICATOR XNP_SV_STATUS_TYPES_B.PHASE_INDICATOR%TYPE;

2276: )
2277: IS
2278: l_counter BINARY_INTEGER := 0;
2279: l_SV_ID XNP_SV_SOA.SV_SOA_ID%TYPE;
2280: l_PHASE_INDICATOR XNP_SV_STATUS_TYPES_B.PHASE_INDICATOR%TYPE;
2281: l_STARTING_NUMBER VARCHAR2(80) := null;
2282: l_ENDING_NUMBER VARCHAR2(80) := null;
2283:
2284: TYPE sv_soa_id_tab IS TABLE OF NUMBER;

Line 2318: xnp_sv_status_types_b sta

2314:
2315: SELECT sv_soa_id BULK COLLECT
2316: INTO l_sv_soa_id
2317: FROM xnp_sv_soa soa,
2318: xnp_sv_status_types_b sta
2319: WHERE soa.subscription_tn BETWEEN l_starting_number AND l_ending_number
2320: AND sta.phase_indicator = l_phase_indicator
2321: AND sta.status_type_code = soa.status_type_code;
2322:

Line 2742: FROM xnp_sv_soa SOA , xnp_sv_status_types_b STA

2738: l_SOA_SV_ID NUMBER := 0;
2739:
2740: CURSOR c_SOA_SV_ID IS
2741: SELECT sv_soa_id
2742: FROM xnp_sv_soa SOA , xnp_sv_status_types_b STA
2743: WHERE SOA.subscription_tn = l_starting_number
2744: AND SOA.donor_sp_id = p_sp_id
2745: AND SOA.status_type_code = STA.status_type_code
2746: AND STA.phase_indicator = p_phase_indicator ;

Line 2801: xnp_sv_status_types_b STA

2797:
2798: CURSOR c_SOA_SV_ID IS
2799: SELECT sv_soa_id
2800: FROM xnp_sv_soa SOA ,
2801: xnp_sv_status_types_b STA
2802: WHERE SOA.subscription_tn = p_starting_number
2803: AND SOA.recipient_sp_id = p_sp_id
2804: AND SOA.status_type_code = STA.status_type_code
2805: AND STA.phase_indicator = p_phase_indicator ;

Line 2892: FROM xnp_sv_status_types_b sta

2888: FROM xnp_sv_soa soa
2889: WHERE soa.subscription_tn BETWEEN l_starting_number AND l_ending_number
2890: AND soa.status_type_code IN
2891: (SELECT sta.status_type_code
2892: FROM xnp_sv_status_types_b sta
2893: WHERE sta.phase_indicator = p_cur_phase_indicator
2894: AND sta.status_type_code <> p_omit_status);
2895:
2896: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last

Line 2900: FROM xnp_sv_status_types_b sta

2896: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2897:
2898: UPDATE xnp_sv_soa soa
2899: SET soa.status_type_code = (SELECT min(sta.status_type_code)
2900: FROM xnp_sv_status_types_b sta
2901: WHERE sta.phase_indicator = p_reset_phase_indicator) ,
2902: soa.status_change_cause_code = p_status_change_cause_code ,
2903: soa.prev_status_type_code = soa.status_type_code,
2904: soa.modified_date = sysdate,

Line 2999: l_PHASE_INDICATOR XNP_SV_STATUS_TYPES_B.PHASE_INDICATOR%TYPE;

2995:
2996: IS
2997: l_counter BINARY_INTEGER := 0;
2998: l_SV_ID XNP_SV_SOA.SV_SOA_ID%TYPE;
2999: l_PHASE_INDICATOR XNP_SV_STATUS_TYPES_B.PHASE_INDICATOR%TYPE;
3000: l_STARTING_NUMBER VARCHAR2(80) := null;
3001: l_ENDING_NUMBER VARCHAR2(80) := null;
3002:
3003: TYPE sv_soa_id_tab IS TABLE OF NUMBER;

Line 3038: xnp_sv_status_types_b sta

3034:
3035: SELECT sv_soa_id BULK COLLECT
3036: INTO l_sv_soa_id
3037: FROM xnp_sv_soa soa,
3038: xnp_sv_status_types_b sta
3039: WHERE soa.subscription_tn BETWEEN l_starting_number AND l_ending_number
3040: AND sta.phase_indicator = l_phase_indicator
3041: AND sta.status_type_code = soa.status_type_code;
3042:

Line 5613: xnp_sv_status_types_b sta

5609: --
5610: SELECT sv_soa_id BULK COLLECT
5611: INTO l_sv_soa_id
5612: FROM xnp_sv_soa soa,
5613: xnp_sv_status_types_b sta
5614: WHERE soa.subscription_tn BETWEEN l_starting_number AND l_ending_number
5615: AND sta.phase_indicator = l_phase_indicator
5616: AND sta.status_type_code = soa.status_type_code;
5617: