DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on FND_GLOBAL

Line 345: p_user_id => Fnd_Global.user_id,

341: x_msg_count => x_msg_count,
342: x_msg_data => x_msg_data,
343: p_resp_appl_id => NULL,
344: p_resp_id => NULL,
345: p_user_id => Fnd_Global.user_id,
346: p_login_id => Fnd_Global.conc_login_id,
347: p_org_id => NULL,
348: p_request_id => p_incident_id,
349: p_request_number => p_service_request_rec.incident_number, -- swai: FP 5157216,

Line 346: p_login_id => Fnd_Global.conc_login_id,

342: x_msg_data => x_msg_data,
343: p_resp_appl_id => NULL,
344: p_resp_id => NULL,
345: p_user_id => Fnd_Global.user_id,
346: p_login_id => Fnd_Global.conc_login_id,
347: p_org_id => NULL,
348: p_request_id => p_incident_id,
349: p_request_number => p_service_request_rec.incident_number, -- swai: FP 5157216,
350: p_service_request_rec => r_service_request_rec,

Line 936: -- fnd_global.apps_initialize(1000200,52284,512,0);

932:
933: -- Api body starts
934:
935: -- dbms_application_info.set_client_info('204');
936: -- fnd_global.apps_initialize(1000200,52284,512,0);
937:
938: IF (g_debug > 0)
939: THEN
940: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,

Line 1440: -- fnd_global.apps_initialize(1000200,52284,512,0);

1436:
1437: -- Api body starts
1438:
1439: -- dbms_application_info.set_client_info('204');
1440: -- fnd_global.apps_initialize(1000200,52284,512,0);
1441:
1442: Debug('Validate the action code', l_mod_name, 1);
1443:
1444: -- Validate the action code

Line 1580: l_user_id := Fnd_Global.USER_ID;

1576: RAISE Fnd_Api.G_EXC_ERROR;
1577: END IF;
1578:
1579: -- Fetch user and login information
1580: l_user_id := Fnd_Global.USER_ID;
1581: l_login_id := Fnd_Global.CONC_LOGIN_ID;
1582:
1583: -- Validate Picking Rule
1584: OPEN pick_rule(p_order_rec.PICKING_RULE_ID);

Line 1581: l_login_id := Fnd_Global.CONC_LOGIN_ID;

1577: END IF;
1578:
1579: -- Fetch user and login information
1580: l_user_id := Fnd_Global.USER_ID;
1581: l_login_id := Fnd_Global.CONC_LOGIN_ID;
1582:
1583: -- Validate Picking Rule
1584: OPEN pick_rule(p_order_rec.PICKING_RULE_ID);
1585: FETCH pick_rule

Line 3053: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

3049: p_PROD_TXN_STATUS => 'ENTERED',
3050: p_PROD_TXN_CODE => x_product_txn_rec.PROD_TXN_CODE,
3051: p_LAST_UPDATE_DATE => SYSDATE,
3052: p_CREATION_DATE => SYSDATE,
3053: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3054: p_CREATED_BY => Fnd_Global.USER_ID,
3055: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
3056: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
3057: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,

Line 3054: p_CREATED_BY => Fnd_Global.USER_ID,

3050: p_PROD_TXN_CODE => x_product_txn_rec.PROD_TXN_CODE,
3051: p_LAST_UPDATE_DATE => SYSDATE,
3052: p_CREATION_DATE => SYSDATE,
3053: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3054: p_CREATED_BY => Fnd_Global.USER_ID,
3055: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
3056: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
3057: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,
3058: p_ATTRIBUTE3 => x_product_txn_rec.ATTRIBUTE3,

Line 3055: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,

3051: p_LAST_UPDATE_DATE => SYSDATE,
3052: p_CREATION_DATE => SYSDATE,
3053: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
3054: p_CREATED_BY => Fnd_Global.USER_ID,
3055: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
3056: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
3057: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,
3058: p_ATTRIBUTE3 => x_product_txn_rec.ATTRIBUTE3,
3059: p_ATTRIBUTE4 => x_product_txn_rec.ATTRIBUTE4,

Line 4558: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

4554: p_PROD_TXN_STATUS => 'SUBMITTED',
4555: p_PROD_TXN_CODE => x_product_txn_rec.PROD_TXN_CODE,
4556: p_LAST_UPDATE_DATE => SYSDATE,
4557: p_CREATION_DATE => SYSDATE,
4558: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4559: p_CREATED_BY => Fnd_Global.USER_ID,
4560: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
4561: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
4562: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,

Line 4559: p_CREATED_BY => Fnd_Global.USER_ID,

4555: p_PROD_TXN_CODE => x_product_txn_rec.PROD_TXN_CODE,
4556: p_LAST_UPDATE_DATE => SYSDATE,
4557: p_CREATION_DATE => SYSDATE,
4558: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4559: p_CREATED_BY => Fnd_Global.USER_ID,
4560: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
4561: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
4562: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,
4563: p_ATTRIBUTE3 => x_product_txn_rec.ATTRIBUTE3,

Line 4560: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,

4556: p_LAST_UPDATE_DATE => SYSDATE,
4557: p_CREATION_DATE => SYSDATE,
4558: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4559: p_CREATED_BY => Fnd_Global.USER_ID,
4560: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
4561: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
4562: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,
4563: p_ATTRIBUTE3 => x_product_txn_rec.ATTRIBUTE3,
4564: p_ATTRIBUTE4 => x_product_txn_rec.ATTRIBUTE4,

Line 6184: p_CREATED_BY => Fnd_Global.USER_ID,

6180: p_REQUEST_ID => NULL,
6181: p_PROGRAM_ID => NULL,
6182: p_PROGRAM_APPLICATION_ID => NULL,
6183: p_PROGRAM_UPDATE_DATE => NULL,
6184: p_CREATED_BY => Fnd_Global.USER_ID,
6185: p_CREATION_DATE => SYSDATE,
6186: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6187: p_LAST_UPDATE_DATE => SYSDATE,
6188: p_repair_line_id => p_repair_line_id,

Line 6186: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

6182: p_PROGRAM_APPLICATION_ID => NULL,
6183: p_PROGRAM_UPDATE_DATE => NULL,
6184: p_CREATED_BY => Fnd_Global.USER_ID,
6185: p_CREATION_DATE => SYSDATE,
6186: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6187: p_LAST_UPDATE_DATE => SYSDATE,
6188: p_repair_line_id => p_repair_line_id,
6189: p_EVENT_CODE => l_event_code,
6190: p_EVENT_DATE => SYSDATE,

Line 6201: p_PARAMN10 => Fnd_Global.USER_ID,

6197: p_PARAMN6 => NULL,
6198: p_PARAMN7 => NULL,
6199: p_PARAMN8 => NULL,
6200: p_PARAMN9 => NULL,
6201: p_PARAMN10 => Fnd_Global.USER_ID,
6202: p_PARAMC1 => l_paramc1,
6203: p_PARAMC2 => l_paramc2,
6204: p_PARAMC3 => l_paramc3,
6205: p_PARAMC4 => l_paramc4,

Line 6238: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

6234: p_ATTRIBUTE12 => NULL,
6235: p_ATTRIBUTE13 => NULL,
6236: p_ATTRIBUTE14 => NULL,
6237: p_ATTRIBUTE15 => NULL,
6238: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
6239: X_Return_Status => x_return_status,
6240: X_Msg_Count => x_msg_count,
6241: X_Msg_Data => x_msg_data);
6242: --

Line 6503: p_CREATED_BY => FND_GLOBAL.USER_ID,

6499: p_REQUEST_ID => NULL,
6500: p_PROGRAM_ID => NULL,
6501: p_PROGRAM_APPLICATION_ID => NULL,
6502: p_PROGRAM_UPDATE_DATE => NULL,
6503: p_CREATED_BY => FND_GLOBAL.USER_ID,
6504: p_CREATION_DATE => SYSDATE,
6505: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
6506: p_LAST_UPDATE_DATE => SYSDATE,
6507: p_repair_line_id => p_repair_line_id,

Line 6505: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

6501: p_PROGRAM_APPLICATION_ID => NULL,
6502: p_PROGRAM_UPDATE_DATE => NULL,
6503: p_CREATED_BY => FND_GLOBAL.USER_ID,
6504: p_CREATION_DATE => SYSDATE,
6505: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
6506: p_LAST_UPDATE_DATE => SYSDATE,
6507: p_repair_line_id => p_repair_line_id,
6508: p_EVENT_CODE => l_event_code,
6509: p_EVENT_DATE => SYSDATE,

Line 6520: p_PARAMN10 => FND_GLOBAL.USER_ID,

6516: p_PARAMN6 => NULL,
6517: p_PARAMN7 => NULL,
6518: p_PARAMN8 => NULL,
6519: p_PARAMN9 => NULL,
6520: p_PARAMN10 => FND_GLOBAL.USER_ID,
6521: p_PARAMC1 => l_paramc1,
6522: p_PARAMC2 => l_paramc2,
6523: p_PARAMC3 => l_paramc3,
6524: p_PARAMC4 => l_paramc4,

Line 6557: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

6553: p_ATTRIBUTE12 => NULL,
6554: p_ATTRIBUTE13 => NULL,
6555: p_ATTRIBUTE14 => NULL,
6556: p_ATTRIBUTE15 => NULL,
6557: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
6558: X_Return_Status => x_return_status,
6559: X_Msg_Count => x_msg_count,
6560: X_Msg_Data => x_msg_data
6561: );

Line 6789: p_CREATED_BY => Fnd_Global.USER_ID,

6785: p_REQUEST_ID => NULL,
6786: p_PROGRAM_ID => NULL,
6787: p_PROGRAM_APPLICATION_ID => NULL,
6788: p_PROGRAM_UPDATE_DATE => NULL,
6789: p_CREATED_BY => Fnd_Global.USER_ID,
6790: p_CREATION_DATE => SYSDATE,
6791: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6792: p_LAST_UPDATE_DATE => SYSDATE,
6793: p_repair_line_id => p_task_activity_rec.repair_line_id,

Line 6791: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

6787: p_PROGRAM_APPLICATION_ID => NULL,
6788: p_PROGRAM_UPDATE_DATE => NULL,
6789: p_CREATED_BY => Fnd_Global.USER_ID,
6790: p_CREATION_DATE => SYSDATE,
6791: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6792: p_LAST_UPDATE_DATE => SYSDATE,
6793: p_repair_line_id => p_task_activity_rec.repair_line_id,
6794: p_EVENT_CODE => l_event_code,
6795: p_EVENT_DATE => SYSDATE,

Line 6806: p_PARAMN10 => Fnd_Global.USER_ID,

6802: p_PARAMN6 => p_task_activity_rec.new_resource_id, --l_paramn6,--assignee_id
6803: p_PARAMN7 => NULL,
6804: p_PARAMN8 => NULL,
6805: p_PARAMN9 => NULL,
6806: p_PARAMN10 => Fnd_Global.USER_ID,
6807: p_PARAMC1 => l_task_number,
6808: p_PARAMC2 => p_task_activity_rec.new_owner_type_code,
6809: p_PARAMC3 => p_task_activity_rec.new_owner_name,
6810: p_PARAMC4 => p_task_activity_rec.new_resource_type_code, --resource_type_code sangiguptask

Line 6843: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

6839: p_ATTRIBUTE12 => NULL,
6840: p_ATTRIBUTE13 => NULL,
6841: p_ATTRIBUTE14 => NULL,
6842: p_ATTRIBUTE15 => NULL,
6843: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
6844: X_Return_Status => x_return_status,
6845: X_Msg_Count => x_msg_count,
6846: X_Msg_Data => x_msg_data);
6847: --

Line 7045: p_CREATED_BY => Fnd_Global.USER_ID,

7041: p_REQUEST_ID => NULL,
7042: p_PROGRAM_ID => NULL,
7043: p_PROGRAM_APPLICATION_ID => NULL,
7044: p_PROGRAM_UPDATE_DATE => NULL,
7045: p_CREATED_BY => Fnd_Global.USER_ID,
7046: p_CREATION_DATE => SYSDATE,
7047: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
7048: p_LAST_UPDATE_DATE => SYSDATE,
7049: p_repair_line_id => p_task_activity_rec.repair_line_id,

Line 7047: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

7043: p_PROGRAM_APPLICATION_ID => NULL,
7044: p_PROGRAM_UPDATE_DATE => NULL,
7045: p_CREATED_BY => Fnd_Global.USER_ID,
7046: p_CREATION_DATE => SYSDATE,
7047: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
7048: p_LAST_UPDATE_DATE => SYSDATE,
7049: p_repair_line_id => p_task_activity_rec.repair_line_id,
7050: p_EVENT_CODE => l_event_code,
7051: p_EVENT_DATE => SYSDATE,

Line 7062: p_PARAMN10 => Fnd_Global.USER_ID,

7058: p_PARAMN6 => p_task_activity_rec.old_owner_id, -- assignee_id sangiguptask
7059: p_PARAMN7 => NULL,
7060: p_PARAMN8 => NULL,
7061: p_PARAMN9 => NULL,
7062: p_PARAMN10 => Fnd_Global.USER_ID,
7063: p_PARAMC1 => l_task_number, -- l_paramc1,-- task number
7064: p_PARAMC2 => p_task_activity_rec.new_owner_type_code, -- new owner type code
7065: p_PARAMC3 => p_task_activity_rec.new_owner_name, -- task owner name
7066: p_PARAMC4 => NULL, -- l_paramc4,-- asisgnee type

Line 7099: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

7095: p_ATTRIBUTE12 => NULL,
7096: p_ATTRIBUTE13 => NULL,
7097: p_ATTRIBUTE14 => NULL,
7098: p_ATTRIBUTE15 => NULL,
7099: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
7100: X_Return_Status => x_return_status,
7101: X_Msg_Count => x_msg_count,
7102: X_Msg_Data => x_msg_data);
7103:

Line 7125: p_CREATED_BY => Fnd_Global.USER_ID,

7121: p_REQUEST_ID => NULL,
7122: p_PROGRAM_ID => NULL,
7123: p_PROGRAM_APPLICATION_ID => NULL,
7124: p_PROGRAM_UPDATE_DATE => NULL,
7125: p_CREATED_BY => Fnd_Global.USER_ID,
7126: p_CREATION_DATE => SYSDATE,
7127: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
7128: p_LAST_UPDATE_DATE => SYSDATE,
7129: p_repair_line_id => p_task_activity_rec.repair_line_id,

Line 7127: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

7123: p_PROGRAM_APPLICATION_ID => NULL,
7124: p_PROGRAM_UPDATE_DATE => NULL,
7125: p_CREATED_BY => Fnd_Global.USER_ID,
7126: p_CREATION_DATE => SYSDATE,
7127: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
7128: p_LAST_UPDATE_DATE => SYSDATE,
7129: p_repair_line_id => p_task_activity_rec.repair_line_id,
7130: p_EVENT_CODE => l_event_code,
7131: p_EVENT_DATE => SYSDATE,

Line 7142: p_PARAMN10 => Fnd_Global.USER_ID,

7138: p_PARAMN6 => p_task_activity_rec.old_status_id,
7139: p_PARAMN7 => NULL,
7140: p_PARAMN8 => NULL,
7141: p_PARAMN9 => NULL,
7142: p_PARAMN10 => Fnd_Global.USER_ID,
7143: p_PARAMC1 => l_task_number, -- task number
7144: p_PARAMC2 => p_task_activity_rec.new_owner_type_code, -- new owner type code
7145: p_PARAMC3 => p_task_activity_rec.new_owner_name, -- task owner name
7146: p_PARAMC4 => NULL, -- asisgnee type

Line 7179: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

7175: p_ATTRIBUTE12 => NULL,
7176: p_ATTRIBUTE13 => NULL,
7177: p_ATTRIBUTE14 => NULL,
7178: p_ATTRIBUTE15 => NULL,
7179: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
7180: X_Return_Status => x_return_status,
7181: X_Msg_Count => x_msg_count,
7182: X_Msg_Data => x_msg_data);
7183:

Line 7205: p_CREATED_BY => Fnd_Global.USER_ID,

7201: p_REQUEST_ID => NULL,
7202: p_PROGRAM_ID => NULL,
7203: p_PROGRAM_APPLICATION_ID => NULL,
7204: p_PROGRAM_UPDATE_DATE => NULL,
7205: p_CREATED_BY => Fnd_Global.USER_ID,
7206: p_CREATION_DATE => SYSDATE,
7207: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
7208: p_LAST_UPDATE_DATE => SYSDATE,
7209: p_repair_line_id => p_task_activity_rec.repair_line_id,

Line 7207: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

7203: p_PROGRAM_APPLICATION_ID => NULL,
7204: p_PROGRAM_UPDATE_DATE => NULL,
7205: p_CREATED_BY => Fnd_Global.USER_ID,
7206: p_CREATION_DATE => SYSDATE,
7207: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
7208: p_LAST_UPDATE_DATE => SYSDATE,
7209: p_repair_line_id => p_task_activity_rec.repair_line_id,
7210: p_EVENT_CODE => l_event_code,
7211: p_EVENT_DATE => SYSDATE,

Line 7222: p_PARAMN10 => Fnd_Global.USER_ID,

7218: p_PARAMN6 => NULL,
7219: p_PARAMN7 => NULL,
7220: p_PARAMN8 => NULL,
7221: p_PARAMN9 => NULL,
7222: p_PARAMN10 => Fnd_Global.USER_ID,
7223: p_PARAMC1 => l_task_number, -- task number
7224: p_PARAMC2 => NULL,
7225: p_PARAMC3 => NULL,
7226: p_PARAMC4 => p_task_activity_rec.new_resource_type_code, -- new assignee type code

Line 7259: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

7255: p_ATTRIBUTE12 => NULL,
7256: p_ATTRIBUTE13 => NULL,
7257: p_ATTRIBUTE14 => NULL,
7258: p_ATTRIBUTE15 => NULL,
7259: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
7260: X_Return_Status => x_return_status,
7261: X_Msg_Count => x_msg_count,
7262: X_Msg_Data => x_msg_data);
7263:

Line 7711: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,

7707: p_commit => 'F',
7708: x_return_status => l_return_status,
7709: x_msg_count => l_msg_count,
7710: x_msg_data => l_msg_data,
7711: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7712: p_resp_id => Fnd_Global.RESP_ID,
7713: p_user_id => Fnd_Global.USER_ID,
7714: p_login_id => Fnd_Global.LOGIN_ID,
7715: p_request_id => p_incident_id,

Line 7712: p_resp_id => Fnd_Global.RESP_ID,

7708: x_return_status => l_return_status,
7709: x_msg_count => l_msg_count,
7710: x_msg_data => l_msg_data,
7711: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7712: p_resp_id => Fnd_Global.RESP_ID,
7713: p_user_id => Fnd_Global.USER_ID,
7714: p_login_id => Fnd_Global.LOGIN_ID,
7715: p_request_id => p_incident_id,
7716: p_request_number => NULL,

Line 7713: p_user_id => Fnd_Global.USER_ID,

7709: x_msg_count => l_msg_count,
7710: x_msg_data => l_msg_data,
7711: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7712: p_resp_id => Fnd_Global.RESP_ID,
7713: p_user_id => Fnd_Global.USER_ID,
7714: p_login_id => Fnd_Global.LOGIN_ID,
7715: p_request_id => p_incident_id,
7716: p_request_number => NULL,
7717: p_object_version_number => l_inc_obj_version_number,

Line 7714: p_login_id => Fnd_Global.LOGIN_ID,

7710: x_msg_data => l_msg_data,
7711: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7712: p_resp_id => Fnd_Global.RESP_ID,
7713: p_user_id => Fnd_Global.USER_ID,
7714: p_login_id => Fnd_Global.LOGIN_ID,
7715: p_request_id => p_incident_id,
7716: p_request_number => NULL,
7717: p_object_version_number => l_inc_obj_version_number,
7718: p_status_id => NULL,

Line 7947: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,

7943: p_commit => 'F',
7944: x_return_status => l_return_status,
7945: x_msg_count => l_msg_count,
7946: x_msg_data => l_msg_data,
7947: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7948: p_resp_id => Fnd_Global.RESP_ID,
7949: p_user_id => Fnd_Global.USER_ID,
7950: p_login_id => Fnd_Global.LOGIN_ID,
7951: p_request_id => l_incident_id,

Line 7948: p_resp_id => Fnd_Global.RESP_ID,

7944: x_return_status => l_return_status,
7945: x_msg_count => l_msg_count,
7946: x_msg_data => l_msg_data,
7947: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7948: p_resp_id => Fnd_Global.RESP_ID,
7949: p_user_id => Fnd_Global.USER_ID,
7950: p_login_id => Fnd_Global.LOGIN_ID,
7951: p_request_id => l_incident_id,
7952: p_request_number => NULL,

Line 7949: p_user_id => Fnd_Global.USER_ID,

7945: x_msg_count => l_msg_count,
7946: x_msg_data => l_msg_data,
7947: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7948: p_resp_id => Fnd_Global.RESP_ID,
7949: p_user_id => Fnd_Global.USER_ID,
7950: p_login_id => Fnd_Global.LOGIN_ID,
7951: p_request_id => l_incident_id,
7952: p_request_number => NULL,
7953: p_object_version_number => l_inc_obj_version_number,

Line 7950: p_login_id => Fnd_Global.LOGIN_ID,

7946: x_msg_data => l_msg_data,
7947: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7948: p_resp_id => Fnd_Global.RESP_ID,
7949: p_user_id => Fnd_Global.USER_ID,
7950: p_login_id => Fnd_Global.LOGIN_ID,
7951: p_request_id => l_incident_id,
7952: p_request_number => NULL,
7953: p_object_version_number => l_inc_obj_version_number,
7954: p_status_id => NULL,

Line 8803: Last_Updated_By = Fnd_Global.User_Id,

8799: SET prod_txn_status = C_Status_Released,
8800: release_sales_order_flag = C_Yes,
8801: object_version_number = Object_Version_Number + 1,
8802: Last_Update_Date = SYSDATE,
8803: Last_Updated_By = Fnd_Global.User_Id,
8804: Last_Update_login = Fnd_Global.Login_Id
8805: WHERE order_header_id =
8806: released_line_rec.source_header_id
8807: AND order_line_id =

Line 8804: Last_Update_login = Fnd_Global.Login_Id

8800: release_sales_order_flag = C_Yes,
8801: object_version_number = Object_Version_Number + 1,
8802: Last_Update_Date = SYSDATE,
8803: Last_Updated_By = Fnd_Global.User_Id,
8804: Last_Update_login = Fnd_Global.Login_Id
8805: WHERE order_header_id =
8806: released_line_rec.source_header_id
8807: AND order_line_id =
8808: released_line_rec.source_line_id

Line 8835: Last_Updated_By = Fnd_Global.User_Id,

8831: update csd_repairs
8832: set ro_txn_status = 'OM_RELEASED' ,
8833: object_version_number = Object_Version_Number + 1,
8834: Last_Update_Date = Sysdate,
8835: Last_Updated_By = Fnd_Global.User_Id,
8836: Last_Update_login = Fnd_Global.Login_Id
8837: where repair_line_id = x_product_txn_rec.repair_line_id;
8838: if sql%notfound then
8839: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');

Line 8836: Last_Update_login = Fnd_Global.Login_Id

8832: set ro_txn_status = 'OM_RELEASED' ,
8833: object_version_number = Object_Version_Number + 1,
8834: Last_Update_Date = Sysdate,
8835: Last_Updated_By = Fnd_Global.User_Id,
8836: Last_Update_login = Fnd_Global.Login_Id
8837: where repair_line_id = x_product_txn_rec.repair_line_id;
8838: if sql%notfound then
8839: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
8840: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);

Line 8991: Last_Updated_By = Fnd_Global.User_Id,

8987: release_sales_order_flag = C_Yes,
8988: ship_sales_order_flag = C_Yes,
8989: object_version_number = Object_Version_Number + 1,
8990: Last_Update_Date = SYSDATE,
8991: Last_Updated_By = Fnd_Global.User_Id,
8992: Last_Update_login = Fnd_Global.Login_Id
8993: WHERE order_header_id =
8994: shipped_line_rec.source_header_id
8995: AND order_line_id =

Line 8992: Last_Update_login = Fnd_Global.Login_Id

8988: ship_sales_order_flag = C_Yes,
8989: object_version_number = Object_Version_Number + 1,
8990: Last_Update_Date = SYSDATE,
8991: Last_Updated_By = Fnd_Global.User_Id,
8992: Last_Update_login = Fnd_Global.Login_Id
8993: WHERE order_header_id =
8994: shipped_line_rec.source_header_id
8995: AND order_line_id =
8996: shipped_line_rec.source_line_id

Line 9025: Last_Updated_By = Fnd_Global.User_Id,

9021: Update csd_repairs
9022: Set ro_txn_status = 'OM_SHIPPED' ,
9023: object_version_number = Object_Version_Number + 1,
9024: Last_Update_Date = Sysdate,
9025: Last_Updated_By = Fnd_Global.User_Id,
9026: Last_Update_login = Fnd_Global.Login_Id
9027: Where repair_line_id = x_product_txn_rec.repair_line_id;
9028: If sql%notfound then
9029: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');

Line 9026: Last_Update_login = Fnd_Global.Login_Id

9022: Set ro_txn_status = 'OM_SHIPPED' ,
9023: object_version_number = Object_Version_Number + 1,
9024: Last_Update_Date = Sysdate,
9025: Last_Updated_By = Fnd_Global.User_Id,
9026: Last_Update_login = Fnd_Global.Login_Id
9027: Where repair_line_id = x_product_txn_rec.repair_line_id;
9028: If sql%notfound then
9029: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
9030: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);

Line 9550: p_CREATED_BY => Fnd_Global.USER_ID,

9546: p_TASK_ID => p_create_repair_task_rec.task_id,
9547: p_OBJECT_VERSION_NUMBER => 1,
9548: p_REPAIR_LINE_ID => p_create_repair_task_rec.repair_line_id,
9549: p_APPLICABLE_QA_PLANS => l_applicable_qa_plans,
9550: p_CREATED_BY => Fnd_Global.USER_ID,
9551: p_CREATION_DATE => SYSDATE,
9552: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9553: p_LAST_UPDATE_DATE => SYSDATE,
9554: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);

Line 9552: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

9548: p_REPAIR_LINE_ID => p_create_repair_task_rec.repair_line_id,
9549: p_APPLICABLE_QA_PLANS => l_applicable_qa_plans,
9550: p_CREATED_BY => Fnd_Global.USER_ID,
9551: p_CREATION_DATE => SYSDATE,
9552: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9553: p_LAST_UPDATE_DATE => SYSDATE,
9554: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);
9555:
9556: -- -------------------

Line 9554: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);

9550: p_CREATED_BY => Fnd_Global.USER_ID,
9551: p_CREATION_DATE => SYSDATE,
9552: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9553: p_LAST_UPDATE_DATE => SYSDATE,
9554: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);
9555:
9556: -- -------------------
9557: -- Api body ends here
9558: -- -------------------

Line 9767: p_CREATED_BY => Fnd_Global.USER_ID,

9763: p_task_id => p_update_repair_task_rec.task_id,
9764: p_OBJECT_VERSION_NUMBER => p_update_repair_task_rec.object_version_number,
9765: p_REPAIR_LINE_ID => p_update_repair_task_rec.repair_line_id,
9766: p_APPLICABLE_QA_PLANS => l_applicable_qa_plans,
9767: p_CREATED_BY => Fnd_Global.USER_ID,
9768: p_CREATION_DATE => SYSDATE,
9769: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9770: p_LAST_UPDATE_DATE => SYSDATE,
9771: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);

Line 9769: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

9765: p_REPAIR_LINE_ID => p_update_repair_task_rec.repair_line_id,
9766: p_APPLICABLE_QA_PLANS => l_applicable_qa_plans,
9767: p_CREATED_BY => Fnd_Global.USER_ID,
9768: p_CREATION_DATE => SYSDATE,
9769: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9770: p_LAST_UPDATE_DATE => SYSDATE,
9771: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);
9772:
9773: -- -------------------

Line 9771: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);

9767: p_CREATED_BY => Fnd_Global.USER_ID,
9768: p_CREATION_DATE => SYSDATE,
9769: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9770: p_LAST_UPDATE_DATE => SYSDATE,
9771: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);
9772:
9773: -- -------------------
9774: -- Api body ends here
9775: -- -------------------