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 FND_GLOBAL

Line 798: fnd_global.

794: p_wsmsc_address ,
795: p_wsmsc_subsystem ,
796: p_rn_address ,
797: p_rn_subsystem ,
798: fnd_global.
799: user_id ,
800: sysdate ,
801: fnd_global.user_id ,
802: sysdate

Line 801: fnd_global.user_id ,

797: p_rn_subsystem ,
798: fnd_global.
799: user_id ,
800: sysdate ,
801: fnd_global.user_id ,
802: sysdate
803: ) RETURNING sv_sms_id INTO l_sv_sms_id ;
804:
805: ELSE

Line 822: ,last_updated_by = fnd_global.user_id

818: ,wsmsc_address = p_wsmsc_address
819: ,wsmsc_subsystem = p_wsmsc_subsystem
820: ,rn_address = p_rn_address
821: ,rn_subsystem = p_rn_subsystem
822: ,last_updated_by = fnd_global.user_id
823: ,last_update_date = sysdate
824: WHERE sv_sms_id = l_sv_sms_id ;
825:
826: END IF;

Line 923: soa.last_updated_by = fnd_global.user_id,

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
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

Line 946: fnd_global.user_id ,

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 ,
947: sysdate ,
948: fnd_global.user_id ,
949: sysdate
950: );

Line 948: fnd_global.user_id ,

944: p_order_id ,
945: p_workitem_instance_id ,
946: fnd_global.user_id ,
947: sysdate ,
948: fnd_global.user_id ,
949: sysdate
950: );
951:
952: EXCEPTION

Line 1033: soa.last_updated_by = fnd_global.user_id,

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,
1033: soa.last_updated_by = fnd_global.user_id,
1034: soa.last_update_date = sysdate
1035: WHERE soa.sv_soa_id = l_sv_soa_id(i)
1036: AND soa.status_type_code <> p_new_status_type_code;
1037:

Line 1061: fnd_global.user_id ,

1057: l_sv_event_code(i) ,
1058: 'STATUS_CHANGE' ,
1059: sysdate ,
1060: p_status_change_cause_code,
1061: fnd_global.user_id ,
1062: sysdate ,
1063: fnd_global.user_id ,
1064: sysdate
1065: );

Line 1063: fnd_global.user_id ,

1059: sysdate ,
1060: p_status_change_cause_code,
1061: fnd_global.user_id ,
1062: sysdate ,
1063: fnd_global.user_id ,
1064: sysdate
1065: );
1066:
1067: -- Call CREATE_ORDER_MAPPING Procedure to create record in XNP_SV_ORDER_MAPPINGS table

Line 1087: fnd_global.user_id ,

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 ,
1088: sysdate ,
1089: fnd_global.user_id ,
1090: sysdate
1091: );

Line 1089: fnd_global.user_id ,

1085: p_order_id ,
1086: p_workitem_instance_id ,
1087: fnd_global.user_id ,
1088: sysdate ,
1089: fnd_global.user_id ,
1090: sysdate
1091: );
1092: EXCEPTION
1093: WHEN dup_val_on_index THEN

Line 1394: ,fnd_global.user_id

1390: ,p_comments
1391: ,p_notes
1392: ,sysdate
1393: ,sysdate
1394: ,fnd_global.user_id
1395: ,sysdate
1396: ,fnd_global.user_id
1397: ,sysdate
1398: ) RETURNING sv_soa_id INTO l_sv_soa_id;

Line 1396: ,fnd_global.user_id

1392: ,sysdate
1393: ,sysdate
1394: ,fnd_global.user_id
1395: ,sysdate
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

Line 1636: fnd_global.user_id ,

1632: p_RECIPIENT_SP_ID ,
1633: p_ROUTING_NUMBER ,
1634: 'Y' ,
1635: null ,
1636: fnd_global.user_id ,
1637: sysdate ,
1638: fnd_global.user_id ,
1639: sysdate ,
1640: fnd_global.user_id

Line 1638: fnd_global.user_id ,

1634: 'Y' ,
1635: null ,
1636: fnd_global.user_id ,
1637: sysdate ,
1638: fnd_global.user_id ,
1639: sysdate ,
1640: fnd_global.user_id
1641: ) RETURNING routing_number_id INTO l_routing_number_id ;
1642: END IF;

Line 1640: fnd_global.user_id

1636: fnd_global.user_id ,
1637: sysdate ,
1638: fnd_global.user_id ,
1639: sysdate ,
1640: fnd_global.user_id
1641: ) RETURNING routing_number_id INTO l_routing_number_id ;
1642: END IF;
1643:
1644: CLOSE c_routing_id_exists ;

Line 1785: ,fnd_global.user_id

1781: ,p_comments
1782: ,p_notes
1783: ,sysdate
1784: ,sysdate
1785: ,fnd_global.user_id
1786: ,sysdate
1787: ,fnd_global.user_id
1788: ,sysdate
1789: ) RETURNING sv_soa_id INTO l_sv_soa_id;

Line 1787: ,fnd_global.user_id

1783: ,sysdate
1784: ,sysdate
1785: ,fnd_global.user_id
1786: ,sysdate
1787: ,fnd_global.user_id
1788: ,sysdate
1789: ) RETURNING sv_soa_id INTO l_sv_soa_id;
1790:
1791:

Line 2121: ,FND_GLOBAL.USER_ID

2117: ,p_COMMENTS
2118: ,p_NOTES
2119: ,SYSDATE
2120: ,SYSDATE
2121: ,FND_GLOBAL.USER_ID
2122: ,SYSDATE
2123: ,FND_GLOBAL.USER_ID
2124: ,SYSDATE
2125: ) RETURNING sv_soa_id INTO l_sv_soa_id;

Line 2123: ,FND_GLOBAL.USER_ID

2119: ,SYSDATE
2120: ,SYSDATE
2121: ,FND_GLOBAL.USER_ID
2122: ,SYSDATE
2123: ,FND_GLOBAL.USER_ID
2124: ,SYSDATE
2125: ) RETURNING sv_soa_id INTO l_sv_soa_id;
2126:
2127:

Line 2331: soa.last_updated_by = fnd_global.user_id,

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,
2330: soa.modified_date = sysdate,
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

Line 2355: fnd_global.user_id ,

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 ,
2356: sysdate ,
2357: fnd_global.user_id ,
2358: sysdate
2359: );

Line 2357: fnd_global.user_id ,

2353: p_order_id ,
2354: p_workitem_instance_id ,
2355: fnd_global.user_id ,
2356: sysdate ,
2357: fnd_global.user_id ,
2358: sysdate
2359: );
2360:
2361: EXCEPTION

Line 2469: ,fnd_global.user_id

2465: ,l_SV_ID
2466: ,p_FE_ID
2467: ,p_FEATURE_TYPE
2468: ,'NOT_PROVISIONED'
2469: ,fnd_global.user_id
2470: ,sysdate
2471: ,fnd_global.user_id
2472: ,sysdate
2473: );

Line 2471: ,fnd_global.user_id

2467: ,p_FEATURE_TYPE
2468: ,'NOT_PROVISIONED'
2469: ,fnd_global.user_id
2470: ,sysdate
2471: ,fnd_global.user_id
2472: ,sysdate
2473: );
2474:
2475: ELSE

Line 2479: last_updated_by = fnd_global.user_id ,

2475: ELSE
2476:
2477: UPDATE xnp_sv_sms_fe_maps
2478: SET provision_status = 'NOT_PROVISIONED' ,
2479: last_updated_by = fnd_global.user_id ,
2480: last_update_date = sysdate
2481: WHERE sms_fe_map_id = l_sms_fe_map_id;
2482:
2483: END IF;

Line 2544: soa.last_updated_by = fnd_global.user_id,

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,
2544: soa.last_updated_by = fnd_global.user_id,
2545: soa.last_update_date = sysdate
2546: WHERE soa.sv_soa_id = l_sv_soa_id(i)
2547: AND soa.status_type_code <> p_new_status_type_code;
2548:

Line 2572: fnd_global.user_id ,

2568: l_sv_event_code(i) ,
2569: 'STATUS_CHANGE' ,
2570: sysdate ,
2571: p_status_change_cause_code,
2572: fnd_global.user_id ,
2573: sysdate ,
2574: fnd_global.user_id ,
2575: sysdate
2576: );

Line 2574: fnd_global.user_id ,

2570: sysdate ,
2571: p_status_change_cause_code,
2572: fnd_global.user_id ,
2573: sysdate ,
2574: fnd_global.user_id ,
2575: sysdate
2576: );
2577:
2578: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 2598: fnd_global.user_id ,

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 ,
2599: sysdate ,
2600: fnd_global.user_id ,
2601: sysdate
2602: );

Line 2600: fnd_global.user_id ,

2596: p_order_id ,
2597: p_workitem_instance_id ,
2598: fnd_global.user_id ,
2599: sysdate ,
2600: fnd_global.user_id ,
2601: sysdate
2602: );
2603:
2604: EXCEPTION

Line 2905: soa.last_updated_by = fnd_global.user_id,

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,
2905: soa.last_updated_by = fnd_global.user_id,
2906: soa.last_update_date = sysdate
2907: WHERE soa.sv_soa_id = l_sv_soa_id(i)
2908: RETURNING soa.status_type_code BULK COLLECT INTO l_sv_event_code;
2909:

Line 2933: fnd_global.user_id ,

2929: l_sv_event_code(i) ,
2930: 'STATUS_CHANGE' ,
2931: sysdate ,
2932: p_status_change_cause_code,
2933: fnd_global.user_id ,
2934: sysdate ,
2935: fnd_global.user_id ,
2936: sysdate
2937: );

Line 2935: fnd_global.user_id ,

2931: sysdate ,
2932: p_status_change_cause_code,
2933: fnd_global.user_id ,
2934: sysdate ,
2935: fnd_global.user_id ,
2936: sysdate
2937: );
2938:
2939: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 2959: fnd_global.user_id ,

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 ,
2960: sysdate ,
2961: fnd_global.user_id ,
2962: sysdate
2963: );

Line 2961: fnd_global.user_id ,

2957: p_order_id ,
2958: p_workitem_instance_id ,
2959: fnd_global.user_id ,
2960: sysdate ,
2961: fnd_global.user_id ,
2962: sysdate
2963: );
2964:
2965: EXCEPTION

Line 3048: soa.last_updated_by = fnd_global.user_id,

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
3050: WHERE soa.sv_soa_id = l_sv_soa_id(i);
3051:
3052: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 3072: fnd_global.user_id ,

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 ,
3073: sysdate ,
3074: fnd_global.user_id ,
3075: sysdate
3076: );

Line 3074: fnd_global.user_id ,

3070: p_order_id ,
3071: p_workitem_instance_id ,
3072: fnd_global.user_id ,
3073: sysdate ,
3074: fnd_global.user_id ,
3075: sysdate
3076: );
3077:
3078: EXCEPTION

Line 3209: last_updated_by = fnd_global.user_id ,

3205: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
3206:
3207: UPDATE xnp_sv_sms_fe_maps
3208: SET provision_status = p_prov_status ,
3209: last_updated_by = fnd_global.user_id ,
3210: last_update_date = sysdate
3211: WHERE sv_sms_id = l_sv_sms_id(i)
3212: AND fe_id = p_fe_id
3213: AND feature_type = p_feature_type;

Line 3235: fnd_global.user_id ,

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 ,
3236: sysdate ,
3237: fnd_global.user_id ,
3238: sysdate
3239: );

Line 3237: fnd_global.user_id ,

3233: p_order_id ,
3234: p_workitem_instance_id ,
3235: fnd_global.user_id ,
3236: sysdate ,
3237: fnd_global.user_id ,
3238: sysdate
3239: );
3240: EXCEPTION
3241: WHEN dup_val_on_index THEN

Line 3358: SOA.LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,

3354: SOA.RN_ADDRESS = p_RN_ADDRESS ,
3355: SOA.RN_SUBSYSTEM = p_RN_SUBSYSTEM ,
3356: SOA.PREORDER_AUTHORIZATION_CODE = p_PREORDER_AUTHORIZATION_CODE ,
3357: SOA.ACTIVATION_DUE_DATE = p_ACTIVATION_DUE_DATE ,
3358: SOA.LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
3359: SOA.LAST_UPDATE_DATE = SYSDATE ,
3360: SOA.MODIFIED_DATE = SYSDATE
3361: WHERE soa.sv_soa_id = l_sv_soa_id(i);
3362:

Line 3382: fnd_global.user_id ,

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 ,
3383: sysdate ,
3384: fnd_global.user_id ,
3385: sysdate
3386: );

Line 3384: fnd_global.user_id ,

3380: p_order_id ,
3381: p_workitem_instance_id ,
3382: fnd_global.user_id ,
3383: sysdate ,
3384: fnd_global.user_id ,
3385: sysdate
3386: );
3387:
3388: EXCEPTION

Line 3502: SOA.LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,

3498: SOA.RN_ADDRESS = p_RN_ADDRESS ,
3499: SOA.RN_SUBSYSTEM = p_RN_SUBSYSTEM ,
3500: SOA.PREORDER_AUTHORIZATION_CODE = p_PREORDER_AUTHORIZATION_CODE ,
3501: SOA.ACTIVATION_DUE_DATE = p_ACTIVATION_DUE_DATE ,
3502: SOA.LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
3503: SOA.LAST_UPDATE_DATE = SYSDATE,
3504: SOA.MODIFIED_DATE = SYSDATE
3505: WHERE SOA.SV_SOA_ID = L_SV_SOA_ID(i);
3506:

Line 3527: fnd_global.user_id ,

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 ,
3528: sysdate ,
3529: fnd_global.user_id ,
3530: sysdate
3531: );

Line 3529: fnd_global.user_id ,

3525: p_order_id ,
3526: p_workitem_instance_id ,
3527: fnd_global.user_id ,
3528: sysdate ,
3529: fnd_global.user_id ,
3530: sysdate
3531: );
3532:
3533: EXCEPTION

Line 3606: SMS.LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,

3602: SMS.WSMSC_ADDRESS = p_WSMSC_ADDRESS ,
3603: SMS.WSMSC_SUBSYSTEM = p_WSMSC_SUBSYSTEM ,
3604: SMS.RN_ADDRESS = p_RN_ADDRESS ,
3605: SMS.RN_SUBSYSTEM = p_RN_SUBSYSTEM ,
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

Line 3629: fnd_global.user_id ,

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 ,
3630: sysdate ,
3631: fnd_global.user_id ,
3632: sysdate
3633: );

Line 3631: fnd_global.user_id ,

3627: p_order_id ,
3628: p_workitem_instance_id ,
3629: fnd_global.user_id ,
3630: sysdate ,
3631: fnd_global.user_id ,
3632: sysdate
3633: );
3634:
3635: EXCEPTION

Line 3761: soa.last_updated_by = fnd_global.user_id,

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
3763: WHERE soa.sv_soa_id = l_sv_soa_id(i);
3764:
3765: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 3785: fnd_global.user_id ,

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 ,
3786: sysdate ,
3787: fnd_global.user_id ,
3788: sysdate
3789: );

Line 3787: fnd_global.user_id ,

3783: p_order_id ,
3784: p_workitem_instance_id ,
3785: fnd_global.user_id ,
3786: sysdate ,
3787: fnd_global.user_id ,
3788: sysdate
3789: );
3790:
3791: EXCEPTION

Line 3844: soa.last_updated_by = fnd_global.user_id,

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
3846: WHERE soa.sv_soa_id = l_sv_soa_id(i);
3847:
3848: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 3868: fnd_global.user_id ,

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 ,
3869: sysdate ,
3870: fnd_global.user_id ,
3871: sysdate
3872: );

Line 3870: fnd_global.user_id ,

3866: p_order_id ,
3867: p_workitem_instance_id ,
3868: fnd_global.user_id ,
3869: sysdate ,
3870: fnd_global.user_id ,
3871: sysdate
3872: );
3873:
3874: EXCEPTION

Line 4029: soa.last_updated_by = fnd_global.user_id,

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
4031: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4032:
4033: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 4053: fnd_global.user_id ,

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 ,
4054: sysdate ,
4055: fnd_global.user_id ,
4056: sysdate
4057: );

Line 4055: fnd_global.user_id ,

4051: p_order_id ,
4052: p_workitem_instance_id ,
4053: fnd_global.user_id ,
4054: sysdate ,
4055: fnd_global.user_id ,
4056: sysdate
4057: );
4058:
4059: EXCEPTION

Line 4115: soa.last_updated_by = fnd_global.user_id,

4111: soa.price_code = p_price_code,
4112: soa.price_per_call = p_price_per_call,
4113: soa.price_per_minute = p_price_per_minute,
4114: soa.modified_date = sysdate,
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

Line 4139: fnd_global.user_id ,

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 ,
4140: sysdate ,
4141: fnd_global.user_id ,
4142: sysdate
4143: );

Line 4141: fnd_global.user_id ,

4137: p_order_id ,
4138: p_workitem_instance_id ,
4139: fnd_global.user_id ,
4140: sysdate ,
4141: fnd_global.user_id ,
4142: sysdate
4143: );
4144:
4145: EXCEPTION

Line 4241: soa.last_updated_by = fnd_global.user_id,

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
4243: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4244:
4245: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 4265: fnd_global.user_id ,

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 ,
4266: sysdate ,
4267: fnd_global.user_id ,
4268: sysdate
4269: );

Line 4267: fnd_global.user_id ,

4263: p_order_id ,
4264: p_workitem_instance_id ,
4265: fnd_global.user_id ,
4266: sysdate ,
4267: fnd_global.user_id ,
4268: sysdate
4269: );
4270:
4271: EXCEPTION

Line 4320: soa.last_updated_by = fnd_global.user_id,

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
4322: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4323:
4324: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 4344: fnd_global.user_id ,

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 ,
4345: sysdate ,
4346: fnd_global.user_id ,
4347: sysdate
4348: );

Line 4346: fnd_global.user_id ,

4342: p_order_id ,
4343: p_workitem_instance_id ,
4344: fnd_global.user_id ,
4345: sysdate ,
4346: fnd_global.user_id ,
4347: sysdate
4348: );
4349:
4350: EXCEPTION

Line 4482: last_updated_by = fnd_global.user_id ,

4478: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
4479:
4480: UPDATE xnp_sv_sms_fe_maps
4481: SET provision_status = p_deprovision_status ,
4482: last_updated_by = fnd_global.user_id ,
4483: last_update_date = sysdate
4484: WHERE feature_type = p_feature_type
4485: AND sv_sms_id = l_sv_sms_id(i);
4486:

Line 4507: fnd_global.user_id ,

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 ,
4508: sysdate ,
4509: fnd_global.user_id ,
4510: sysdate
4511: );

Line 4509: fnd_global.user_id ,

4505: p_order_id ,
4506: p_workitem_instance_id ,
4507: fnd_global.user_id ,
4508: sysdate ,
4509: fnd_global.user_id ,
4510: sysdate
4511: );
4512:
4513: EXCEPTION

Line 4560: soa.last_updated_by = fnd_global.user_id,

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
4562: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4563:
4564: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 4584: fnd_global.user_id ,

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 ,
4585: sysdate ,
4586: fnd_global.user_id ,
4587: sysdate
4588: );

Line 4586: fnd_global.user_id ,

4582: p_order_id ,
4583: p_workitem_instance_id ,
4584: fnd_global.user_id ,
4585: sysdate ,
4586: fnd_global.user_id ,
4587: sysdate
4588: );
4589: EXCEPTION
4590: WHEN dup_val_on_index THEN

Line 4804: soa.last_updated_by = fnd_global.user_id,

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
4806: WHERE soa.sv_soa_id = l_sv_soa_id(i);
4807:
4808: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 4828: fnd_global.user_id ,

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 ,
4829: sysdate ,
4830: fnd_global.user_id ,
4831: sysdate
4832: );

Line 4830: fnd_global.user_id ,

4826: p_order_id ,
4827: p_workitem_instance_id ,
4828: fnd_global.user_id ,
4829: sysdate ,
4830: fnd_global.user_id ,
4831: sysdate
4832: );
4833:
4834: EXCEPTION

Line 5078: soa.last_updated_by = fnd_global.user_id,

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
5080: WHERE soa.sv_soa_id = l_sv_soa_id(i);
5081:
5082: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 5102: fnd_global.user_id ,

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 ,
5103: sysdate ,
5104: fnd_global.user_id ,
5105: sysdate
5106: );

Line 5104: fnd_global.user_id ,

5100: p_order_id ,
5101: p_workitem_instance_id ,
5102: fnd_global.user_id ,
5103: sysdate ,
5104: fnd_global.user_id ,
5105: sysdate
5106: );
5107:
5108: EXCEPTION

Line 5283: last_updated_by = fnd_global.user_id,

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,
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

Line 5307: fnd_global.user_id ,

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 ,
5308: sysdate ,
5309: fnd_global.user_id ,
5310: sysdate
5311: );

Line 5309: fnd_global.user_id ,

5305: p_order_id ,
5306: p_workitem_instance_id ,
5307: fnd_global.user_id ,
5308: sysdate ,
5309: fnd_global.user_id ,
5310: sysdate
5311: );
5312: EXCEPTION
5313: WHEN dup_val_on_index THEN

Line 5390: soa.last_updated_by = fnd_global.user_id ,

5386: soa.wsmsc_subsystem = p_wsmsc_subsystem ,
5387: soa.rn_address = p_rn_address ,
5388: soa.rn_subsystem = p_rn_subsystem ,
5389: soa.modified_date = sysdate ,
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

Line 5414: fnd_global.user_id ,

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 ,
5415: sysdate ,
5416: fnd_global.user_id ,
5417: sysdate
5418: );

Line 5416: fnd_global.user_id ,

5412: p_order_id ,
5413: p_workitem_instance_id ,
5414: fnd_global.user_id ,
5415: sysdate ,
5416: fnd_global.user_id ,
5417: sysdate
5418: );
5419:
5420: EXCEPTION

Line 5505: soa.last_updated_by = fnd_global.user_id,

5501: soa.pager = p_pager ,
5502: soa.pager_pin = p_pager_pin ,
5503: soa.internet_address = p_internet_address ,
5504: soa.modified_date = sysdate,
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

Line 5529: fnd_global.user_id ,

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 ,
5530: sysdate ,
5531: fnd_global.user_id ,
5532: sysdate
5533: );

Line 5531: fnd_global.user_id ,

5527: p_order_id ,
5528: p_workitem_instance_id ,
5529: fnd_global.user_id ,
5530: sysdate ,
5531: fnd_global.user_id ,
5532: sysdate
5533: );
5534:
5535: EXCEPTION

Line 5623: soa.last_updated_by = fnd_global.user_id,

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
5625: WHERE soa.sv_soa_id = l_sv_soa_id(i);
5626:
5627: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 5647: fnd_global.user_id ,

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 ,
5648: sysdate ,
5649: fnd_global.user_id ,
5650: sysdate
5651: );

Line 5649: fnd_global.user_id ,

5645: p_order_id ,
5646: p_workitem_instance_id ,
5647: fnd_global.user_id ,
5648: sysdate ,
5649: fnd_global.user_id ,
5650: sysdate
5651: );
5652:
5653: -- Update the order header with the porting id

Line 5718: sms.last_updated_by = fnd_global.user_id,

5714: FORALL i IN l_sv_sms_id.first..l_sv_sms_id.last
5715:
5716: UPDATE xnp_sv_sms sms
5717: SET sms.provision_done_date = sysdate,
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

Line 5742: fnd_global.user_id ,

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 ,
5743: sysdate ,
5744: fnd_global.user_id ,
5745: sysdate
5746: );

Line 5744: fnd_global.user_id ,

5740: p_order_id ,
5741: p_workitem_instance_id ,
5742: fnd_global.user_id ,
5743: sysdate ,
5744: fnd_global.user_id ,
5745: sysdate
5746: );
5747:
5748: EXCEPTION

Line 5856: l_error_message:= FND_GLOBAL.NEWLINE|| l_error_message||x_error_message;

5852: ,x_ERROR_MESSAGE =>x_ERROR_MESSAGE
5853: );
5854:
5855: IF (x_error_code <> 0) THEN
5856: l_error_message:= FND_GLOBAL.NEWLINE|| l_error_message||x_error_message;
5857:
5858: END IF;
5859:
5860: -- Get the SP id for this recipient code

Line 5869: l_error_message:=FND_GLOBAL.NEWLINE||l_error_message||x_error_message;

5865: ,x_ERROR_MESSAGE => x_ERROR_MESSAGE
5866: );
5867:
5868: IF x_ERROR_CODE <> 0 THEN
5869: l_error_message:=FND_GLOBAL.NEWLINE||l_error_message||x_error_message;
5870: END IF;
5871:
5872: --Check for RN belongs to Recipient
5873: IF l_ROUTING_NUMBER_ID<>0 AND l_RECIPIENT_SP_ID <>0 THEN

Line 5882: l_error_message:= FND_GLOBAL.NEWLINE||l_error_message||x_error_message;

5878: );
5879:
5880:
5881: IF x_ERROR_CODE <> 0 THEN
5882: l_error_message:= FND_GLOBAL.NEWLINE||l_error_message||x_error_message;
5883: END IF;
5884: END IF;
5885:
5886:

Line 5896: l_error_message:=FND_GLOBAL.NEWLINE|| l_error_message||x_error_message;

5892: x_error_code => x_error_code,
5893: x_error_message => x_error_message
5894: );
5895: IF (x_error_code <> 0) THEN
5896: l_error_message:=FND_GLOBAL.NEWLINE|| l_error_message||x_error_message;
5897:
5898: END IF;
5899:
5900:

Line 5911: l_error_message:= FND_GLOBAL.NEWLINE|| l_error_message||x_error_message;

5907: );
5908:
5909: IF x_ERROR_CODE <> 0 THEN
5910:
5911: l_error_message:= FND_GLOBAL.NEWLINE|| l_error_message||x_error_message;
5912: END IF;
5913:
5914:
5915: -- Return x_error code and x_error_message

Line 5973: fnd_global.user_id ,

5969: p_sv_soa_id ,
5970: p_sv_sms_id ,
5971: p_order_id ,
5972: p_workitem_instance_id ,
5973: fnd_global.user_id ,
5974: sysdate ,
5975: fnd_global.user_id ,
5976: sysdate
5977: );

Line 5975: fnd_global.user_id ,

5971: p_order_id ,
5972: p_workitem_instance_id ,
5973: fnd_global.user_id ,
5974: sysdate ,
5975: fnd_global.user_id ,
5976: sysdate
5977: );
5978:
5979: EXCEPTION

Line 6025: soa.last_updated_by = fnd_global.user_id,

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
6027: WHERE soa.sv_soa_id = l_sv_soa_id(i);
6028:
6029: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 6049: fnd_global.user_id ,

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 ,
6050: sysdate ,
6051: fnd_global.user_id ,
6052: sysdate
6053: );

Line 6051: fnd_global.user_id ,

6047: p_order_id ,
6048: p_workitem_instance_id ,
6049: fnd_global.user_id ,
6050: sysdate ,
6051: fnd_global.user_id ,
6052: sysdate
6053: );
6054:
6055: EXCEPTION

Line 6106: soa.last_updated_by = fnd_global.user_id,

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
6108: WHERE soa.sv_soa_id = l_sv_soa_id(i);
6109:
6110: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 6130: fnd_global.user_id ,

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 ,
6131: sysdate ,
6132: fnd_global.user_id ,
6133: sysdate
6134: );

Line 6132: fnd_global.user_id ,

6128: p_order_id ,
6129: p_workitem_instance_id ,
6130: fnd_global.user_id ,
6131: sysdate ,
6132: fnd_global.user_id ,
6133: sysdate
6134: );
6135:
6136: EXCEPTION

Line 6186: soa.last_updated_by = fnd_global.user_id,

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
6188: WHERE soa.sv_soa_id = l_sv_soa_id(i);
6189:
6190: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 6210: fnd_global.user_id ,

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 ,
6211: sysdate ,
6212: fnd_global.user_id ,
6213: sysdate
6214: );

Line 6212: fnd_global.user_id ,

6208: p_order_id ,
6209: p_workitem_instance_id ,
6210: fnd_global.user_id ,
6211: sysdate ,
6212: fnd_global.user_id ,
6213: sysdate
6214: );
6215:
6216: EXCEPTION

Line 6262: soa.last_updated_by = fnd_global.user_id,

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
6264: WHERE soa.sv_soa_id = l_sv_soa_id(i);
6265:
6266: -- Create a mapping record in XNP_SV_ORDER_MAPPINGS table

Line 6286: fnd_global.user_id ,

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 ,
6287: sysdate ,
6288: fnd_global.user_id ,
6289: sysdate
6290: );

Line 6288: fnd_global.user_id ,

6284: p_order_id ,
6285: p_workitem_instance_id ,
6286: fnd_global.user_id ,
6287: sysdate ,
6288: fnd_global.user_id ,
6289: sysdate
6290: );
6291: EXCEPTION
6292: WHEN dup_val_on_index THEN