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_CORE dependencies on XNP_SV_SOA_S

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 911: FROM xnp_sv_soa soa,

907: x_error_code := 0;
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

Line 920: UPDATE xnp_sv_soa soa

916: AND sta.status_type_code = soa.status_type_code;
917:
918: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
919:
920: UPDATE xnp_sv_soa soa
921: SET soa.old_sp_cutoff_due_date = p_old_sp_cutoff_due_date,
922: soa.modified_date = sysdate,
923: soa.last_updated_by = fnd_global.user_id,
924: soa.last_update_date = sysdate

Line 1020: FROM xnp_sv_soa soa,

1016: SELECT soa.sv_soa_id,
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;

Line 1028: UPDATE xnp_sv_soa soa

1024: AND STA.status_type_code = SOA.status_type_code;
1025:
1026: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
1027:
1028: UPDATE xnp_sv_soa soa
1029: SET soa.status_type_code = p_new_status_type_code ,
1030: soa.status_change_cause_code = p_status_change_cause_code ,
1031: soa.prev_status_type_code = soa.status_type_code,
1032: soa.modified_date = sysdate,

Line 1279: -- SELECT xnp_sv_soa_s.nextval

1275: LOOP
1276:
1277: l_subscription_tn := to_char(l_init+l_counter);
1278:
1279: -- SELECT xnp_sv_soa_s.nextval
1280: -- INTO l_sv_soa_id
1281: -- FROM dual;
1282:
1283: INSERT INTO xnp_sv_soa

Line 1342: (xnp_sv_soa_s.nextval

1338: ,last_updated_by
1339: ,last_update_date
1340: )
1341: VALUES
1342: (xnp_sv_soa_s.nextval
1343: ,p_porting_id -- obj ref
1344: ,l_subscription_tn -- subs TN
1345: ,'NP' -- subs type
1346: ,p_donor_sp_id

Line 1670: --- SELECT xnp_sv_soa_s.nextval

1666: LOOP
1667:
1668: l_subscription_tn := to_char(l_init+l_counter);
1669:
1670: --- SELECT xnp_sv_soa_s.nextval
1671: --- INTO l_sv_soa_id
1672: --- FROM dual;
1673:
1674: INSERT INTO XNP_SV_SOA

Line 1733: (xnp_sv_soa_s.nextval

1729: ,last_updated_by
1730: ,last_update_date
1731: )
1732: VALUES
1733: (xnp_sv_soa_s.nextval
1734: ,p_porting_id -- obj ref
1735: ,l_subscription_tn -- subs TN
1736: ,'NP' -- subs type
1737: ,p_donor_sp_id

Line 2005: SELECT xnp_sv_soa_s.nextval

2001:
2002: l_SUBSCRIPTION_TN := to_char(l_init+l_counter);
2003:
2004: /***
2005: SELECT xnp_sv_soa_s.nextval
2006: INTO l_sv_soa_id
2007: FROM dual;
2008: ***/
2009:

Line 2069: (xnp_sv_soa_s.nextval

2065: ,LAST_UPDATED_BY
2066: ,LAST_UPDATE_DATE
2067: )
2068: VALUES
2069: (xnp_sv_soa_s.nextval
2070: ,p_PORTING_ID
2071: ,l_SUBSCRIPTION_TN -- telephone number
2072: ,'NP' -- subs type
2073: ,p_DONOR_SP_ID

Line 2279: l_SV_ID XNP_SV_SOA.SV_SOA_ID%TYPE;

2275: ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
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:

Line 2317: FROM xnp_sv_soa soa,

2313: --
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;

Line 2325: UPDATE xnp_sv_soa soa

2321: AND sta.status_type_code = soa.status_type_code;
2322:
2323: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2324:
2325: UPDATE xnp_sv_soa soa
2326: SET soa.invoice_due_date = p_invoice_due_date,
2327: soa.charging_info = p_charging_info,
2328: soa.user_loctn_type = p_user_loctn_type,
2329: soa.user_loctn_value = p_user_loctn_value,

Line 2534: FROM xnp_sv_soa soa

2530: SELECT soa.sv_soa_id,
2531: soa.status_type_code BULK COLLECT
2532: INTO l_sv_soa_id,
2533: l_sv_event_code
2534: FROM xnp_sv_soa soa
2535: WHERE soa.object_reference = p_porting_id ;
2536:
2537: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2538:

Line 2539: UPDATE xnp_sv_soa soa

2535: WHERE soa.object_reference = p_porting_id ;
2536:
2537: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2538:
2539: UPDATE xnp_sv_soa soa
2540: SET soa.status_type_code = p_new_status_type_code ,
2541: soa.status_change_cause_code = p_status_change_cause_code ,
2542: soa.prev_status_type_code = soa.status_type_code,
2543: soa.modified_date = sysdate,

Line 2646: FROM xnp_sv_soa SOA

2642: l_SOA_SV_ID NUMBER := 0;
2643:
2644: CURSOR c_SOA_SV_ID IS
2645: SELECT sv_soa_id
2646: FROM xnp_sv_soa SOA
2647: WHERE SOA.status_type_code = p_status_type_code
2648: AND TO_NUMBER(SOA.subscription_tn) BETWEEN TO_NUMBER(p_starting_number) AND TO_NUMBER(p_ending_number) ;
2649:
2650: BEGIN

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 2800: FROM xnp_sv_soa SOA ,

2796: l_ENDING_NUMBER VARCHAR2(80) := null;
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

Line 2888: FROM xnp_sv_soa soa

2884: -- Reset Status for each SV in the given phase
2885:
2886: SELECT sv_soa_id BULK COLLECT
2887: INTO l_sv_soa_id
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

Line 2898: UPDATE xnp_sv_soa soa

2894: AND sta.status_type_code <> p_omit_status);
2895:
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 ,

Line 2998: l_SV_ID XNP_SV_SOA.SV_SOA_ID%TYPE;

2994: )
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:

Line 3037: FROM xnp_sv_soa soa,

3033: x_ERROR_CODE := 0;
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;

Line 3045: UPDATE xnp_sv_soa soa

3041: AND sta.status_type_code = soa.status_type_code;
3042:
3043: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3044:
3045: UPDATE xnp_sv_soa soa
3046: SET soa.old_sp_due_date = p_old_sp_due_date,
3047: soa.modified_date = sysdate,
3048: soa.last_updated_by = fnd_global.user_id,
3049: soa.last_update_date = sysdate

Line 3317: FROM xnp_sv_soa soa

3313: BEGIN
3314:
3315: SELECT sv_soa_id BULK COLLECT
3316: INTO l_sv_soa_id
3317: FROM xnp_sv_soa soa
3318: WHERE soa.object_reference = p_porting_id ;
3319:
3320: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3321:

Line 3322: UPDATE xnp_sv_soa soa

3318: WHERE soa.object_reference = p_porting_id ;
3319:
3320: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3321:
3322: UPDATE xnp_sv_soa soa
3323: SET SOA.CHANGED_BY_SP_ID = p_RECIPIENT_SP_ID ,
3324: SOA.OLD_SP_CUTOFF_DUE_DATE = p_OLD_SP_CUTOFF_DUE_DATE ,
3325: SOA.CUSTOMER_ID = p_CUSTOMER_ID ,
3326: SOA.CUSTOMER_NAME = p_CUSTOMER_NAME ,

Line 3461: FROM xnp_sv_soa soa

3457: BEGIN
3458:
3459: SELECT sv_soa_id BULK COLLECT
3460: INTO l_sv_soa_id
3461: FROM xnp_sv_soa soa
3462: WHERE object_reference = p_porting_id;
3463:
3464: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3465:

Line 3466: UPDATE xnp_sv_soa soa

3462: WHERE object_reference = p_porting_id;
3463:
3464: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3465:
3466: UPDATE xnp_sv_soa soa
3467: SET SOA.CHANGED_BY_SP_ID = p_DONOR_SP_ID ,
3468: SOA.OLD_SP_CUTOFF_DUE_DATE = p_OLD_SP_CUTOFF_DUE_DATE ,
3469: SOA.CUSTOMER_ID = p_CUSTOMER_ID ,
3470: SOA.CUSTOMER_NAME = p_CUSTOMER_NAME ,

Line 3753: FROM xnp_sv_soa soa

3749: end if;
3750:
3751: SELECT sv_soa_id BULK COLLECT
3752: INTO l_sv_soa_id
3753: FROM xnp_sv_soa soa
3754: WHERE soa.object_reference = p_porting_id;
3755:
3756: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3757:

Line 3758: UPDATE xnp_sv_soa soa

3754: WHERE soa.object_reference = p_porting_id;
3755:
3756: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3757:
3758: UPDATE xnp_sv_soa soa
3759: SET soa.old_sp_due_date = p_old_sp_due_date ,
3760: soa.modified_date = sysdate,
3761: soa.last_updated_by = fnd_global.user_id,
3762: soa.last_update_date = sysdate

Line 3836: FROM xnp_sv_soa soa

3832: end if;
3833:
3834: SELECT sv_soa_id BULK COLLECT
3835: INTO l_sv_soa_id
3836: FROM xnp_sv_soa soa
3837: WHERE soa.object_reference = p_porting_id;
3838:
3839: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3840:

Line 3841: UPDATE xnp_sv_soa soa

3837: WHERE soa.object_reference = p_porting_id;
3838:
3839: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3840:
3841: UPDATE xnp_sv_soa soa
3842: SET soa.new_sp_due_date = p_new_sp_due_date,
3843: soa.modified_date = sysdate,
3844: soa.last_updated_by = fnd_global.user_id,
3845: soa.last_update_date = sysdate

Line 3905: FROM xnp_sv_soa SOA

3901: l_SOA_SV_ID NUMBER := 0;
3902:
3903: CURSOR c_SOA_SV_ID IS
3904: SELECT sv_soa_id
3905: FROM xnp_sv_soa SOA
3906: WHERE status_type_code = p_status_type_code
3907: AND SOA.donor_sp_id = p_donor_sp_id
3908: AND ( (to_number(subscription_tn) >= to_number(p_starting_number))
3909: AND (to_number(subscription_tn) <= to_number(p_ending_number)) ) ;

Line 4021: FROM xnp_sv_soa soa

4017: x_ERROR_CODE := 0;
4018:
4019: SELECT sv_soa_id BULK COLLECT
4020: INTO l_sv_soa_id
4021: FROM xnp_sv_soa soa
4022: WHERE soa.object_reference = p_porting_id;
4023:
4024: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4025:

Line 4026: UPDATE xnp_sv_soa soa

4022: WHERE soa.object_reference = p_porting_id;
4023:
4024: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4025:
4026: UPDATE xnp_sv_soa soa
4027: SET soa.old_sp_cutoff_due_date = XNP_UTILS.CANONICAL_TO_DATE(p_old_sp_cutoff_due_date) ,
4028: soa.modified_date = sysdate,
4029: soa.last_updated_by = fnd_global.user_id,
4030: soa.last_update_date = sysdate

Line 4101: FROM xnp_sv_soa soa

4097: BEGIN
4098:
4099: SELECT sv_soa_id BULK COLLECT
4100: INTO l_sv_soa_id
4101: FROM xnp_sv_soa soa
4102: WHERE soa.object_reference=p_porting_id;
4103:
4104: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4105:

Line 4106: UPDATE xnp_sv_soa soa

4102: WHERE soa.object_reference=p_porting_id;
4103:
4104: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4105:
4106: UPDATE xnp_sv_soa soa
4107: SET soa.invoice_due_date = p_invoice_due_date,
4108: soa.charging_info = p_charging_info ,
4109: soa.user_loctn_type = p_user_loctn_type,
4110: soa.user_loctn_value = p_user_loctn_value,

Line 4175: FROM xnp_sv_soa SOA

4171: l_SOA_SV_ID NUMBER := 0;
4172:
4173: CURSOR c_SOA_SV_ID IS
4174: SELECT sv_soa_id
4175: FROM xnp_sv_soa SOA
4176: WHERE SOA.object_reference = p_porting_id
4177: AND SOA.status_type_code = p_status_type_code;
4178:
4179: BEGIN

Line 4233: FROM xnp_sv_soa soa

4229: x_ERROR_CODE := 0;
4230:
4231: SELECT sv_soa_id BULK COLLECT
4232: INTO l_sv_soa_id
4233: FROM xnp_sv_soa soa
4234: WHERE soa.object_reference = p_porting_id;
4235:
4236: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4237:

Line 4238: UPDATE xnp_sv_soa soa

4234: WHERE soa.object_reference = p_porting_id;
4235:
4236: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4237:
4238: UPDATE xnp_sv_soa soa
4239: SET soa.old_sp_authorization_flag = p_old_sp_authorization_flag,
4240: soa.modified_date = sysdate,
4241: soa.last_updated_by = fnd_global.user_id,
4242: soa.last_update_date = sysdate

Line 4312: FROM xnp_sv_soa soa

4308: x_ERROR_CODE := 0;
4309:
4310: SELECT sv_soa_id BULK COLLECT
4311: INTO l_sv_soa_id
4312: FROM xnp_sv_soa soa
4313: WHERE soa.object_reference = p_porting_id;
4314:
4315: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4316:

Line 4317: UPDATE xnp_sv_soa soa

4313: WHERE soa.object_reference = p_porting_id;
4314:
4315: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4316:
4317: UPDATE xnp_sv_soa soa
4318: SET soa.new_sp_authorization_flag = p_new_sp_authorization_flag ,
4319: soa.modified_date = sysdate,
4320: soa.last_updated_by = fnd_global.user_id,
4321: soa.last_update_date = sysdate

Line 4552: FROM xnp_sv_soa soa

4548: x_error_code := 0;
4549:
4550: SELECT sv_soa_id BULK COLLECT
4551: INTO l_sv_soa_id
4552: FROM xnp_sv_soa soa
4553: WHERE soa.object_reference = p_porting_id;
4554:
4555: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4556:

Line 4557: UPDATE xnp_sv_soa soa

4553: WHERE soa.object_reference = p_porting_id;
4554:
4555: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4556:
4557: UPDATE xnp_sv_soa soa
4558: SET soa.locked_flag = p_locked_flag,
4559: soa.modified_date = sysdate,
4560: soa.last_updated_by = fnd_global.user_id,
4561: soa.last_update_date = sysdate

Line 4626: FROM xnp_sv_soa soa

4622: IS
4623:
4624: CURSOR c_locked_flag IS
4625: SELECT locked_flag
4626: FROM xnp_sv_soa soa
4627: WHERE soa.object_reference = p_porting_id;
4628:
4629: BEGIN
4630: x_error_code := 0;

Line 4689: FROM xnp_sv_soa soa

4685: IS
4686:
4687: CURSOR c_SV_STATUS IS
4688: SELECT status_type_code
4689: FROM xnp_sv_soa soa
4690: WHERE soa.object_reference=p_porting_id;
4691:
4692: BEGIN
4693: x_error_code := 0;

Line 4796: FROM xnp_sv_soa soa

4792: x_error_code := 0;
4793:
4794: SELECT sv_soa_id BULK COLLECT
4795: INTO l_sv_soa_id
4796: FROM xnp_sv_soa soa
4797: WHERE object_reference = p_porting_id;
4798:
4799: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4800:

Line 4801: UPDATE xnp_sv_soa soa

4797: WHERE object_reference = p_porting_id;
4798:
4799: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4800:
4801: UPDATE xnp_sv_soa soa
4802: SET soa.blocked_flag = p_blocked_flag,
4803: soa.modified_date = sysdate,
4804: soa.last_updated_by = fnd_global.user_id,
4805: soa.last_update_date = sysdate

Line 5070: FROM xnp_sv_soa soa

5066: end if;
5067:
5068: SELECT sv_soa_id BULK COLLECT
5069: INTO l_sv_soa_id
5070: FROM xnp_sv_soa soa
5071: WHERE soa.object_reference = p_porting_id;
5072:
5073: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5074:

Line 5075: UPDATE xnp_sv_soa soa

5071: WHERE soa.object_reference = p_porting_id;
5072:
5073: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5074:
5075: UPDATE xnp_sv_soa soa
5076: SET soa.activation_due_date = p_activation_due_date ,
5077: soa.modified_date = sysdate,
5078: soa.last_updated_by = fnd_global.user_id,
5079: soa.last_update_date = sysdate

Line 5273: FROM xnp_sv_soa soa

5269: BEGIN
5270:
5271: SELECT sv_soa_id BULK COLLECT
5272: INTO l_sv_soa_id
5273: FROM xnp_sv_soa soa
5274: WHERE soa.object_reference = p_porting_id;
5275:
5276: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5277:

Line 5278: UPDATE xnp_sv_soa soa

5274: WHERE soa.object_reference = p_porting_id;
5275:
5276: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5277:
5278: UPDATE xnp_sv_soa soa
5279: SET soa.comments = p_comments ,
5280: soa.notes = p_notes ,
5281: soa.preorder_authorization_code = p_preorder_authorization_code,
5282: soa.modified_date = sysdate,

Line 5370: FROM xnp_sv_soa soa

5366: BEGIN
5367:
5368: SELECT sv_soa_id BULK COLLECT
5369: INTO l_sv_soa_id
5370: FROM xnp_sv_soa soa
5371: WHERE soa.object_reference = p_porting_id;
5372:
5373: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5374:

Line 5375: UPDATE xnp_sv_soa soa

5371: WHERE soa.object_reference = p_porting_id;
5372:
5373: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5374:
5375: UPDATE xnp_sv_soa soa
5376: SET soa.routing_number_id = p_routing_number_id ,
5377: soa.cnam_address = p_cnam_address ,
5378: soa.cnam_subsystem = p_cnam_subsystem ,
5379: soa.isvm_address = p_isvm_address ,

Line 5482: FROM xnp_sv_soa soa

5478: BEGIN
5479:
5480: SELECT sv_soa_id BULK COLLECT
5481: INTO l_sv_soa_id
5482: FROM xnp_sv_soa soa
5483: WHERE soa.object_reference = p_porting_id;
5484:
5485: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5486:

Line 5487: UPDATE xnp_sv_soa soa

5483: WHERE soa.object_reference = p_porting_id;
5484:
5485: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5486:
5487: UPDATE xnp_sv_soa soa
5488: SET soa.customer_id = p_customer_id ,
5489: soa.customer_name = p_customer_name ,
5490: soa.customer_type = p_customer_type ,
5491: soa.address_line1 = p_address_line1 ,

Line 5612: FROM xnp_sv_soa soa,

5608: -- and update the porting id
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;

Line 5620: UPDATE xnp_sv_soa soa

5616: AND sta.status_type_code = soa.status_type_code;
5617:
5618: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5619:
5620: UPDATE xnp_sv_soa soa
5621: SET soa.object_reference = p_porting_id,
5622: soa.modified_date = sysdate,
5623: soa.last_updated_by = fnd_global.user_id,
5624: soa.last_update_date = sysdate

Line 6017: FROM xnp_sv_soa soa

6013: end if;
6014:
6015: SELECT sv_soa_id BULK COLLECT
6016: INTO l_sv_soa_id
6017: FROM xnp_sv_soa soa
6018: WHERE soa.object_reference = p_porting_id;
6019:
6020: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6021:

Line 6022: UPDATE xnp_sv_soa soa

6018: WHERE soa.object_reference = p_porting_id;
6019:
6020: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6021:
6022: UPDATE xnp_sv_soa soa
6023: SET soa.disconnect_due_date = p_disconnect_due_date,
6024: soa.modified_date = sysdate,
6025: soa.last_updated_by = fnd_global.user_id,
6026: soa.last_update_date = sysdate

Line 6098: FROM xnp_sv_soa soa

6094: end if;
6095:
6096: SELECT sv_soa_id BULK COLLECT
6097: INTO l_sv_soa_id
6098: FROM xnp_sv_soa soa
6099: WHERE soa.object_reference = p_porting_id;
6100:
6101: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6102:

Line 6103: UPDATE xnp_sv_soa soa

6099: WHERE soa.object_reference = p_porting_id;
6100:
6101: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6102:
6103: UPDATE xnp_sv_soa soa
6104: SET soa.effective_release_due_date = p_effective_release_due_date,
6105: soa.modified_date = sysdate,
6106: soa.last_updated_by = fnd_global.user_id,
6107: soa.last_update_date = sysdate

Line 6178: FROM xnp_sv_soa soa

6174: end if;
6175:
6176: SELECT sv_soa_id BULK COLLECT
6177: INTO l_sv_soa_id
6178: FROM xnp_sv_soa soa
6179: WHERE soa.object_reference = p_porting_id;
6180:
6181: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6182:

Line 6183: UPDATE xnp_sv_soa soa

6179: WHERE soa.object_reference = p_porting_id;
6180:
6181: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6182:
6183: UPDATE xnp_sv_soa soa
6184: SET soa.NUMBER_RETURNED_DUE_DATE = p_NUMBER_RETURNED_DUE_DATE,
6185: soa.modified_date = sysdate,
6186: soa.last_updated_by = fnd_global.user_id,
6187: soa.last_update_date = sysdate

Line 6254: FROM xnp_sv_soa soa

6250: x_error_code := 0;
6251:
6252: SELECT sv_soa_id BULK COLLECT
6253: INTO l_sv_soa_id
6254: FROM xnp_sv_soa soa
6255: WHERE soa.object_reference = p_porting_id;
6256:
6257: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6258:

Line 6259: UPDATE xnp_sv_soa soa

6255: WHERE soa.object_reference = p_porting_id;
6256:
6257: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6258:
6259: UPDATE xnp_sv_soa soa
6260: SET soa.concurrence_flag = p_concurrence_flag,
6261: soa.modified_date = sysdate,
6262: soa.last_updated_by = fnd_global.user_id,
6263: soa.last_update_date = sysdate

Line 6327: FROM xnp_sv_soa soa

6323: IS
6324:
6325: CURSOR c_concurrence_flag IS
6326: SELECT concurrence_flag
6327: FROM xnp_sv_soa soa
6328: WHERE soa.object_reference = p_porting_id;
6329:
6330: BEGIN
6331: x_error_code := 0;