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_ORDER_MAPPINGS

Line 927: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table

923: soa.last_updated_by = fnd_global.user_id,
924: soa.last_update_date = sysdate
925: WHERE soa.sv_soa_id = l_sv_soa_id(i);
926:
927: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table
928:
929: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
930:
931: INSERT INTO XNP_SV_ORDER_MAPPINGS

Line 931: INSERT INTO XNP_SV_ORDER_MAPPINGS

927: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table
928:
929: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
930:
931: INSERT INTO XNP_SV_ORDER_MAPPINGS
932: (sv_order_mapping_id ,
933: sv_soa_id ,
934: order_id ,
935: workitem_instance_id ,

Line 942: (XNP_SV_ORDER_MAPPINGS_S.nextval,

938: last_updated_by ,
939: last_update_date
940: )
941: VALUES
942: (XNP_SV_ORDER_MAPPINGS_S.nextval,
943: l_sv_soa_id(i) ,
944: p_order_id ,
945: p_workitem_instance_id ,
946: fnd_global.user_id ,

Line 1067: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table

1063: fnd_global.user_id ,
1064: sysdate
1065: );
1066:
1067: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table
1068:
1069: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
1070:
1071:

Line 1072: INSERT INTO XNP_SV_ORDER_MAPPINGS

1068:
1069: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
1070:
1071:
1072: INSERT INTO XNP_SV_ORDER_MAPPINGS
1073: (sv_order_mapping_id ,
1074: sv_soa_id ,
1075: order_id ,
1076: workitem_instance_id ,

Line 1083: (XNP_SV_ORDER_MAPPINGS_S.nextval,

1079: last_updated_by ,
1080: last_update_date
1081: )
1082: VALUES
1083: (XNP_SV_ORDER_MAPPINGS_S.nextval,
1084: l_sv_soa_id(i) ,
1085: p_order_id ,
1086: p_workitem_instance_id ,
1087: fnd_global.user_id ,

Line 1400: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table

1396: ,fnd_global.user_id
1397: ,sysdate
1398: ) RETURNING sv_soa_id INTO l_sv_soa_id;
1399:
1400: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table
1401:
1402: CREATE_ORDER_MAPPING
1403: (p_ORDER_ID ,
1404: p_LINEITEM_ID ,

Line 1792: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table

1788: ,sysdate
1789: ) RETURNING sv_soa_id INTO l_sv_soa_id;
1790:
1791:
1792: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table
1793:
1794: CREATE_ORDER_MAPPING
1795: (p_ORDER_ID ,
1796: p_LINEITEM_ID ,

Line 2128: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table

2124: ,SYSDATE
2125: ) RETURNING sv_soa_id INTO l_sv_soa_id;
2126:
2127:
2128: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table
2129:
2130: CREATE_ORDER_MAPPING
2131: (p_ORDER_ID ,
2132: p_LINEITEM_ID ,

Line 2335: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

2331: soa.last_updated_by = fnd_global.user_id,
2332: soa.last_update_date = sysdate
2333: WHERE soa.sv_soa_id = l_sv_soa_id(i);
2334:
2335: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
2336:
2337: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2338:
2339:

Line 2340: INSERT INTO XNP_SV_ORDER_MAPPINGS

2336:
2337: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2338:
2339:
2340: INSERT INTO XNP_SV_ORDER_MAPPINGS
2341: (sv_order_mapping_id ,
2342: sv_soa_id ,
2343: order_id ,
2344: workitem_instance_id ,

Line 2351: (XNP_SV_ORDER_MAPPINGS_S.nextval,

2347: last_updated_by ,
2348: last_update_date
2349: )
2350: VALUES
2351: (XNP_SV_ORDER_MAPPINGS_S.nextval,
2352: l_sv_soa_id(i) ,
2353: p_order_id ,
2354: p_workitem_instance_id ,
2355: fnd_global.user_id ,

Line 2425: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table

2421: END IF;
2422:
2423: IF l_sv_id IS NOT NULL THEN
2424:
2425: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table
2426:
2427: CREATE_ORDER_MAPPING
2428: (p_ORDER_ID ,
2429: p_LINEITEM_ID ,

Line 2578: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

2574: fnd_global.user_id ,
2575: sysdate
2576: );
2577:
2578: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
2579:
2580: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2581:
2582:

Line 2583: INSERT INTO XNP_SV_ORDER_MAPPINGS

2579:
2580: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2581:
2582:
2583: INSERT INTO XNP_SV_ORDER_MAPPINGS
2584: (sv_order_mapping_id ,
2585: sv_soa_id ,
2586: order_id ,
2587: workitem_instance_id ,

Line 2594: (XNP_SV_ORDER_MAPPINGS_S.nextval,

2590: last_updated_by ,
2591: last_update_date
2592: )
2593: VALUES
2594: (XNP_SV_ORDER_MAPPINGS_S.nextval,
2595: l_sv_soa_id(i) ,
2596: p_order_id ,
2597: p_workitem_instance_id ,
2598: fnd_global.user_id ,

Line 2939: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

2935: fnd_global.user_id ,
2936: sysdate
2937: );
2938:
2939: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
2940:
2941: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2942:
2943:

Line 2944: INSERT INTO XNP_SV_ORDER_MAPPINGS

2940:
2941: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
2942:
2943:
2944: INSERT INTO XNP_SV_ORDER_MAPPINGS
2945: (sv_order_mapping_id ,
2946: sv_soa_id ,
2947: order_id ,
2948: workitem_instance_id ,

Line 2955: (XNP_SV_ORDER_MAPPINGS_S.nextval,

2951: last_updated_by ,
2952: last_update_date
2953: )
2954: VALUES
2955: (XNP_SV_ORDER_MAPPINGS_S.nextval,
2956: l_sv_soa_id(i) ,
2957: p_order_id ,
2958: p_workitem_instance_id ,
2959: fnd_global.user_id ,

Line 3052: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

3048: soa.last_updated_by = fnd_global.user_id,
3049: soa.last_update_date = sysdate
3050: WHERE soa.sv_soa_id = l_sv_soa_id(i);
3051:
3052: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
3053:
3054: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3055:
3056:

Line 3057: INSERT INTO XNP_SV_ORDER_MAPPINGS

3053:
3054: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3055:
3056:
3057: INSERT INTO XNP_SV_ORDER_MAPPINGS
3058: (sv_order_mapping_id ,
3059: sv_soa_id ,
3060: order_id ,
3061: workitem_instance_id ,

Line 3068: (XNP_SV_ORDER_MAPPINGS_S.nextval,

3064: last_updated_by ,
3065: last_update_date
3066: )
3067: VALUES
3068: (XNP_SV_ORDER_MAPPINGS_S.nextval,
3069: l_sv_soa_id(i) ,
3070: p_order_id ,
3071: p_workitem_instance_id ,
3072: fnd_global.user_id ,

Line 3132: FROM xnp_sv_order_mappings

3128:
3129: -- Delete from order mappings
3130:
3131: DELETE
3132: FROM xnp_sv_order_mappings
3133: WHERE sv_sms_id IN
3134: (SELECT sv_sms_id
3135: FROM xnp_sv_sms
3136: WHERE subscription_tn BETWEEN l_starting_number

Line 3215: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

3211: WHERE sv_sms_id = l_sv_sms_id(i)
3212: AND fe_id = p_fe_id
3213: AND feature_type = p_feature_type;
3214:
3215: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
3216:
3217: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
3218:
3219:

Line 3220: INSERT INTO XNP_SV_ORDER_MAPPINGS

3216:
3217: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
3218:
3219:
3220: INSERT INTO XNP_SV_ORDER_MAPPINGS
3221: (sv_order_mapping_id ,
3222: sv_sms_id ,
3223: order_id ,
3224: workitem_instance_id ,

Line 3231: (XNP_SV_ORDER_MAPPINGS_S.nextval,

3227: last_updated_by ,
3228: last_update_date
3229: )
3230: VALUES
3231: (XNP_SV_ORDER_MAPPINGS_S.nextval,
3232: l_sv_sms_id(i) ,
3233: p_order_id ,
3234: p_workitem_instance_id ,
3235: fnd_global.user_id ,

Line 3363: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

3359: SOA.LAST_UPDATE_DATE = SYSDATE ,
3360: SOA.MODIFIED_DATE = SYSDATE
3361: WHERE soa.sv_soa_id = l_sv_soa_id(i);
3362:
3363: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
3364:
3365: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3366:
3367: INSERT INTO XNP_SV_ORDER_MAPPINGS

Line 3367: INSERT INTO XNP_SV_ORDER_MAPPINGS

3363: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
3364:
3365: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3366:
3367: INSERT INTO XNP_SV_ORDER_MAPPINGS
3368: (sv_order_mapping_id ,
3369: sv_soa_id ,
3370: order_id ,
3371: workitem_instance_id ,

Line 3378: (XNP_SV_ORDER_MAPPINGS_S.nextval,

3374: last_updated_by ,
3375: last_update_date
3376: )
3377: VALUES
3378: (XNP_SV_ORDER_MAPPINGS_S.nextval,
3379: l_sv_soa_id(i) ,
3380: p_order_id ,
3381: p_workitem_instance_id ,
3382: fnd_global.user_id ,

Line 3507: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

3503: SOA.LAST_UPDATE_DATE = SYSDATE,
3504: SOA.MODIFIED_DATE = SYSDATE
3505: WHERE SOA.SV_SOA_ID = L_SV_SOA_ID(i);
3506:
3507: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
3508:
3509: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3510:
3511:

Line 3512: INSERT INTO XNP_SV_ORDER_MAPPINGS

3508:
3509: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3510:
3511:
3512: INSERT INTO XNP_SV_ORDER_MAPPINGS
3513: (sv_order_mapping_id ,
3514: sv_soa_id ,
3515: order_id ,
3516: workitem_instance_id ,

Line 3523: (XNP_SV_ORDER_MAPPINGS_S.nextval,

3519: last_updated_by ,
3520: last_update_date
3521: )
3522: VALUES
3523: (XNP_SV_ORDER_MAPPINGS_S.nextval,
3524: l_sv_soa_id(i) ,
3525: p_order_id ,
3526: p_workitem_instance_id ,
3527: fnd_global.user_id ,

Line 3610: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

3606: SMS.LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
3607: SMS.LAST_UPDATE_DATE = SYSDATE
3608: WHERE SMS.SV_SMS_ID = L_SV_SMS_ID(i);
3609:
3610: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
3611:
3612: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
3613:
3614: INSERT INTO XNP_SV_ORDER_MAPPINGS

Line 3614: INSERT INTO XNP_SV_ORDER_MAPPINGS

3610: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
3611:
3612: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
3613:
3614: INSERT INTO XNP_SV_ORDER_MAPPINGS
3615: (sv_order_mapping_id ,
3616: sv_sms_id ,
3617: order_id ,
3618: workitem_instance_id ,

Line 3625: (XNP_SV_ORDER_MAPPINGS_S.nextval,

3621: last_updated_by ,
3622: last_update_date
3623: )
3624: VALUES
3625: (XNP_SV_ORDER_MAPPINGS_S.nextval,
3626: l_sv_sms_id(i) ,
3627: p_order_id ,
3628: p_workitem_instance_id ,
3629: fnd_global.user_id ,

Line 3765: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

3761: soa.last_updated_by = fnd_global.user_id,
3762: soa.last_update_date = sysdate
3763: WHERE soa.sv_soa_id = l_sv_soa_id(i);
3764:
3765: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
3766:
3767: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3768:
3769:

Line 3770: INSERT INTO XNP_SV_ORDER_MAPPINGS

3766:
3767: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3768:
3769:
3770: INSERT INTO XNP_SV_ORDER_MAPPINGS
3771: (sv_order_mapping_id ,
3772: sv_soa_id ,
3773: order_id ,
3774: workitem_instance_id ,

Line 3781: (XNP_SV_ORDER_MAPPINGS_S.nextval,

3777: last_updated_by ,
3778: last_update_date
3779: )
3780: VALUES
3781: (XNP_SV_ORDER_MAPPINGS_S.nextval,
3782: l_sv_soa_id(i) ,
3783: p_order_id ,
3784: p_workitem_instance_id ,
3785: fnd_global.user_id ,

Line 3848: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

3844: soa.last_updated_by = fnd_global.user_id,
3845: soa.last_update_date = sysdate
3846: WHERE soa.sv_soa_id = l_sv_soa_id(i);
3847:
3848: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
3849:
3850: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3851:
3852:

Line 3853: INSERT INTO XNP_SV_ORDER_MAPPINGS

3849:
3850: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
3851:
3852:
3853: INSERT INTO XNP_SV_ORDER_MAPPINGS
3854: (sv_order_mapping_id ,
3855: sv_soa_id ,
3856: order_id ,
3857: workitem_instance_id ,

Line 3864: (XNP_SV_ORDER_MAPPINGS_S.nextval,

3860: last_updated_by ,
3861: last_update_date
3862: )
3863: VALUES
3864: (XNP_SV_ORDER_MAPPINGS_S.nextval,
3865: l_sv_soa_id(i) ,
3866: p_order_id ,
3867: p_workitem_instance_id ,
3868: fnd_global.user_id ,

Line 4033: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

4029: soa.last_updated_by = fnd_global.user_id,
4030: soa.last_update_date = sysdate
4031: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4032:
4033: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
4034:
4035: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4036:
4037:

Line 4038: INSERT INTO XNP_SV_ORDER_MAPPINGS

4034:
4035: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4036:
4037:
4038: INSERT INTO XNP_SV_ORDER_MAPPINGS
4039: (sv_order_mapping_id ,
4040: sv_soa_id ,
4041: order_id ,
4042: workitem_instance_id ,

Line 4049: (XNP_SV_ORDER_MAPPINGS_S.nextval,

4045: last_updated_by ,
4046: last_update_date
4047: )
4048: VALUES
4049: (XNP_SV_ORDER_MAPPINGS_S.nextval,
4050: l_sv_soa_id(i) ,
4051: p_order_id ,
4052: p_workitem_instance_id ,
4053: fnd_global.user_id ,

Line 4119: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

4115: soa.last_updated_by = fnd_global.user_id,
4116: soa.last_update_date = sysdate
4117: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4118:
4119: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
4120:
4121: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4122:
4123:

Line 4124: INSERT INTO XNP_SV_ORDER_MAPPINGS

4120:
4121: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4122:
4123:
4124: INSERT INTO XNP_SV_ORDER_MAPPINGS
4125: (sv_order_mapping_id ,
4126: sv_soa_id ,
4127: order_id ,
4128: workitem_instance_id ,

Line 4135: (XNP_SV_ORDER_MAPPINGS_S.nextval,

4131: last_updated_by ,
4132: last_update_date
4133: )
4134: VALUES
4135: (XNP_SV_ORDER_MAPPINGS_S.nextval,
4136: l_sv_soa_id(i) ,
4137: p_order_id ,
4138: p_workitem_instance_id ,
4139: fnd_global.user_id ,

Line 4245: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

4241: soa.last_updated_by = fnd_global.user_id,
4242: soa.last_update_date = sysdate
4243: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4244:
4245: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
4246:
4247: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4248:
4249:

Line 4250: INSERT INTO XNP_SV_ORDER_MAPPINGS

4246:
4247: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4248:
4249:
4250: INSERT INTO XNP_SV_ORDER_MAPPINGS
4251: (sv_order_mapping_id ,
4252: sv_soa_id ,
4253: order_id ,
4254: workitem_instance_id ,

Line 4261: (XNP_SV_ORDER_MAPPINGS_S.nextval,

4257: last_updated_by ,
4258: last_update_date
4259: )
4260: VALUES
4261: (XNP_SV_ORDER_MAPPINGS_S.nextval,
4262: l_sv_soa_id(i) ,
4263: p_order_id ,
4264: p_workitem_instance_id ,
4265: fnd_global.user_id ,

Line 4324: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

4320: soa.last_updated_by = fnd_global.user_id,
4321: soa.last_update_date = sysdate
4322: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4323:
4324: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
4325:
4326: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4327:
4328:

Line 4329: INSERT INTO XNP_SV_ORDER_MAPPINGS

4325:
4326: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4327:
4328:
4329: INSERT INTO XNP_SV_ORDER_MAPPINGS
4330: (sv_order_mapping_id ,
4331: sv_soa_id ,
4332: order_id ,
4333: workitem_instance_id ,

Line 4340: (XNP_SV_ORDER_MAPPINGS_S.nextval,

4336: last_updated_by ,
4337: last_update_date
4338: )
4339: VALUES
4340: (XNP_SV_ORDER_MAPPINGS_S.nextval,
4341: l_sv_soa_id(i) ,
4342: p_order_id ,
4343: p_workitem_instance_id ,
4344: fnd_global.user_id ,

Line 4487: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

4483: last_update_date = sysdate
4484: WHERE feature_type = p_feature_type
4485: AND sv_sms_id = l_sv_sms_id(i);
4486:
4487: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
4488:
4489: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
4490:
4491:

Line 4492: INSERT INTO XNP_SV_ORDER_MAPPINGS

4488:
4489: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
4490:
4491:
4492: INSERT INTO XNP_SV_ORDER_MAPPINGS
4493: (sv_order_mapping_id ,
4494: sv_sms_id ,
4495: order_id ,
4496: workitem_instance_id ,

Line 4503: (XNP_SV_ORDER_MAPPINGS_S.nextval,

4499: last_updated_by ,
4500: last_update_date
4501: )
4502: VALUES
4503: (XNP_SV_ORDER_MAPPINGS_S.nextval,
4504: l_sv_sms_id(i) ,
4505: p_order_id ,
4506: p_workitem_instance_id ,
4507: fnd_global.user_id ,

Line 4564: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

4560: soa.last_updated_by = fnd_global.user_id,
4561: soa.last_update_date = sysdate
4562: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4563:
4564: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
4565:
4566: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4567:
4568:

Line 4569: INSERT INTO XNP_SV_ORDER_MAPPINGS

4565:
4566: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4567:
4568:
4569: INSERT INTO XNP_SV_ORDER_MAPPINGS
4570: (sv_order_mapping_id ,
4571: sv_soa_id ,
4572: order_id ,
4573: workitem_instance_id ,

Line 4580: (XNP_SV_ORDER_MAPPINGS_S.nextval,

4576: last_updated_by ,
4577: last_update_date
4578: )
4579: VALUES
4580: (XNP_SV_ORDER_MAPPINGS_S.nextval,
4581: l_sv_soa_id(i) ,
4582: p_order_id ,
4583: p_workitem_instance_id ,
4584: fnd_global.user_id ,

Line 4808: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

4804: soa.last_updated_by = fnd_global.user_id,
4805: soa.last_update_date = sysdate
4806: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4807:
4808: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
4809:
4810: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4811:
4812:

Line 4813: INSERT INTO XNP_SV_ORDER_MAPPINGS

4809:
4810: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
4811:
4812:
4813: INSERT INTO XNP_SV_ORDER_MAPPINGS
4814: (sv_order_mapping_id ,
4815: sv_soa_id ,
4816: order_id ,
4817: workitem_instance_id ,

Line 4824: (XNP_SV_ORDER_MAPPINGS_S.nextval,

4820: last_updated_by ,
4821: last_update_date
4822: )
4823: VALUES
4824: (XNP_SV_ORDER_MAPPINGS_S.nextval,
4825: l_sv_soa_id(i) ,
4826: p_order_id ,
4827: p_workitem_instance_id ,
4828: fnd_global.user_id ,

Line 5082: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

5078: soa.last_updated_by = fnd_global.user_id,
5079: soa.last_update_date = sysdate
5080: WHERE soa.sv_soa_id = l_sv_soa_id(i);
5081:
5082: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
5083:
5084: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5085:
5086:

Line 5087: INSERT INTO XNP_SV_ORDER_MAPPINGS

5083:
5084: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5085:
5086:
5087: INSERT INTO XNP_SV_ORDER_MAPPINGS
5088: (sv_order_mapping_id ,
5089: sv_soa_id ,
5090: order_id ,
5091: workitem_instance_id ,

Line 5098: (XNP_SV_ORDER_MAPPINGS_S.nextval,

5094: last_updated_by ,
5095: last_update_date
5096: )
5097: VALUES
5098: (XNP_SV_ORDER_MAPPINGS_S.nextval,
5099: l_sv_soa_id(i) ,
5100: p_order_id ,
5101: p_workitem_instance_id ,
5102: fnd_global.user_id ,

Line 5287: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

5283: last_updated_by = fnd_global.user_id,
5284: last_update_date = sysdate
5285: WHERE soa.sv_soa_id = l_sv_soa_id(i);
5286:
5287: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
5288:
5289: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5290:
5291:

Line 5292: INSERT INTO XNP_SV_ORDER_MAPPINGS

5288:
5289: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5290:
5291:
5292: INSERT INTO XNP_SV_ORDER_MAPPINGS
5293: (sv_order_mapping_id ,
5294: sv_soa_id ,
5295: order_id ,
5296: workitem_instance_id ,

Line 5303: (XNP_SV_ORDER_MAPPINGS_S.nextval,

5299: last_updated_by ,
5300: last_update_date
5301: )
5302: VALUES
5303: (XNP_SV_ORDER_MAPPINGS_S.nextval,
5304: l_sv_soa_id(i) ,
5305: p_order_id ,
5306: p_workitem_instance_id ,
5307: fnd_global.user_id ,

Line 5394: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

5390: soa.last_updated_by = fnd_global.user_id ,
5391: soa.last_update_date = sysdate
5392: WHERE soa.sv_soa_id = l_sv_soa_id(i);
5393:
5394: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
5395:
5396: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5397:
5398:

Line 5399: INSERT INTO XNP_SV_ORDER_MAPPINGS

5395:
5396: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5397:
5398:
5399: INSERT INTO XNP_SV_ORDER_MAPPINGS
5400: (sv_order_mapping_id ,
5401: sv_soa_id ,
5402: order_id ,
5403: workitem_instance_id ,

Line 5410: (XNP_SV_ORDER_MAPPINGS_S.nextval,

5406: last_updated_by ,
5407: last_update_date
5408: )
5409: VALUES
5410: (XNP_SV_ORDER_MAPPINGS_S.nextval,
5411: l_sv_soa_id(i) ,
5412: p_order_id ,
5413: p_workitem_instance_id ,
5414: fnd_global.user_id ,

Line 5509: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

5505: soa.last_updated_by = fnd_global.user_id,
5506: soa.last_update_date = sysdate
5507: WHERE soa.sv_soa_id = l_sv_soa_id(i);
5508:
5509: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
5510:
5511: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5512:
5513:

Line 5514: INSERT INTO XNP_SV_ORDER_MAPPINGS

5510:
5511: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5512:
5513:
5514: INSERT INTO XNP_SV_ORDER_MAPPINGS
5515: (sv_order_mapping_id ,
5516: sv_soa_id ,
5517: order_id ,
5518: workitem_instance_id ,

Line 5525: (XNP_SV_ORDER_MAPPINGS_S.nextval,

5521: last_updated_by ,
5522: last_update_date
5523: )
5524: VALUES
5525: (XNP_SV_ORDER_MAPPINGS_S.nextval,
5526: l_sv_soa_id(i) ,
5527: p_order_id ,
5528: p_workitem_instance_id ,
5529: fnd_global.user_id ,

Line 5627: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

5623: soa.last_updated_by = fnd_global.user_id,
5624: soa.last_update_date = sysdate
5625: WHERE soa.sv_soa_id = l_sv_soa_id(i);
5626:
5627: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
5628:
5629: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5630:
5631:

Line 5632: INSERT INTO XNP_SV_ORDER_MAPPINGS

5628:
5629: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
5630:
5631:
5632: INSERT INTO XNP_SV_ORDER_MAPPINGS
5633: (sv_order_mapping_id ,
5634: sv_soa_id ,
5635: order_id ,
5636: workitem_instance_id ,

Line 5643: (XNP_SV_ORDER_MAPPINGS_S.nextval,

5639: last_updated_by ,
5640: last_update_date
5641: )
5642: VALUES
5643: (XNP_SV_ORDER_MAPPINGS_S.nextval,
5644: l_sv_soa_id(i) ,
5645: p_order_id ,
5646: p_workitem_instance_id ,
5647: fnd_global.user_id ,

Line 5722: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

5718: sms.last_updated_by = fnd_global.user_id,
5719: sms.last_update_date = sysdate
5720: WHERE sms.sv_sms_id = l_sv_sms_id(i);
5721:
5722: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
5723:
5724: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
5725:
5726:

Line 5727: INSERT INTO XNP_SV_ORDER_MAPPINGS

5723:
5724: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
5725:
5726:
5727: INSERT INTO XNP_SV_ORDER_MAPPINGS
5728: (sv_order_mapping_id ,
5729: sv_sms_id ,
5730: order_id ,
5731: workitem_instance_id ,

Line 5738: (XNP_SV_ORDER_MAPPINGS_S.nextval,

5734: last_updated_by ,
5735: last_update_date
5736: )
5737: VALUES
5738: (XNP_SV_ORDER_MAPPINGS_S.nextval,
5739: l_sv_sms_id(i) ,
5740: p_order_id ,
5741: p_workitem_instance_id ,
5742: fnd_global.user_id ,

Line 5956: INSERT INTO XNP_SV_ORDER_MAPPINGS

5952: l_sv_order_mapping_id NUMBER;
5953:
5954: BEGIN
5955:
5956: INSERT INTO XNP_SV_ORDER_MAPPINGS
5957: (sv_order_mapping_id ,
5958: sv_soa_id ,
5959: sv_sms_id ,
5960: order_id ,

Line 5968: (XNP_SV_ORDER_MAPPINGS_S.nextval,

5964: last_updated_by ,
5965: last_update_date
5966: )
5967: VALUES
5968: (XNP_SV_ORDER_MAPPINGS_S.nextval,
5969: p_sv_soa_id ,
5970: p_sv_sms_id ,
5971: p_order_id ,
5972: p_workitem_instance_id ,

Line 6029: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

6025: soa.last_updated_by = fnd_global.user_id,
6026: soa.last_update_date = sysdate
6027: WHERE soa.sv_soa_id = l_sv_soa_id(i);
6028:
6029: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
6030:
6031: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6032:
6033:

Line 6034: INSERT INTO XNP_SV_ORDER_MAPPINGS

6030:
6031: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6032:
6033:
6034: INSERT INTO XNP_SV_ORDER_MAPPINGS
6035: (sv_order_mapping_id ,
6036: sv_soa_id ,
6037: order_id ,
6038: workitem_instance_id ,

Line 6045: (XNP_SV_ORDER_MAPPINGS_S.nextval,

6041: last_updated_by ,
6042: last_update_date
6043: )
6044: VALUES
6045: (XNP_SV_ORDER_MAPPINGS_S.nextval,
6046: l_sv_soa_id(i) ,
6047: p_order_id ,
6048: p_workitem_instance_id ,
6049: fnd_global.user_id ,

Line 6110: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

6106: soa.last_updated_by = fnd_global.user_id,
6107: soa.last_update_date = sysdate
6108: WHERE soa.sv_soa_id = l_sv_soa_id(i);
6109:
6110: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
6111:
6112: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6113:
6114:

Line 6115: INSERT INTO XNP_SV_ORDER_MAPPINGS

6111:
6112: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6113:
6114:
6115: INSERT INTO XNP_SV_ORDER_MAPPINGS
6116: (sv_order_mapping_id ,
6117: sv_soa_id ,
6118: order_id ,
6119: workitem_instance_id ,

Line 6126: (XNP_SV_ORDER_MAPPINGS_S.nextval,

6122: last_updated_by ,
6123: last_update_date
6124: )
6125: VALUES
6126: (XNP_SV_ORDER_MAPPINGS_S.nextval,
6127: l_sv_soa_id(i) ,
6128: p_order_id ,
6129: p_workitem_instance_id ,
6130: fnd_global.user_id ,

Line 6190: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

6186: soa.last_updated_by = fnd_global.user_id,
6187: soa.last_update_date = sysdate
6188: WHERE soa.sv_soa_id = l_sv_soa_id(i);
6189:
6190: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
6191:
6192: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6193:
6194:

Line 6195: INSERT INTO XNP_SV_ORDER_MAPPINGS

6191:
6192: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6193:
6194:
6195: INSERT INTO XNP_SV_ORDER_MAPPINGS
6196: (sv_order_mapping_id ,
6197: sv_soa_id ,
6198: order_id ,
6199: workitem_instance_id ,

Line 6206: (XNP_SV_ORDER_MAPPINGS_S.nextval,

6202: last_updated_by ,
6203: last_update_date
6204: )
6205: VALUES
6206: (XNP_SV_ORDER_MAPPINGS_S.nextval,
6207: l_sv_soa_id(i) ,
6208: p_order_id ,
6209: p_workitem_instance_id ,
6210: fnd_global.user_id ,

Line 6266: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

6262: soa.last_updated_by = fnd_global.user_id,
6263: soa.last_update_date = sysdate
6264: WHERE soa.sv_soa_id = l_sv_soa_id(i);
6265:
6266: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table
6267:
6268: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6269:
6270:

Line 6271: INSERT INTO XNP_SV_ORDER_MAPPINGS

6267:
6268: FORALL i IN l_sv_soa_id.first..l_sv_soa_id.last
6269:
6270:
6271: INSERT INTO XNP_SV_ORDER_MAPPINGS
6272: (sv_order_mapping_id ,
6273: sv_soa_id ,
6274: order_id ,
6275: workitem_instance_id ,

Line 6282: (XNP_SV_ORDER_MAPPINGS_S.nextval,

6278: last_updated_by ,
6279: last_update_date
6280: )
6281: VALUES
6282: (XNP_SV_ORDER_MAPPINGS_S.nextval,
6283: l_sv_soa_id(i) ,
6284: p_order_id ,
6285: p_workitem_instance_id ,
6286: fnd_global.user_id ,