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.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 908: -- fnd_global.apps_initialize(1000200,52284,512,0);

904:
905: -- Api body starts
906:
907: -- dbms_application_info.set_client_info('204');
908: -- fnd_global.apps_initialize(1000200,52284,512,0);
909:
910: IF (g_debug > 0)
911: THEN
912: Csd_Gen_Utility_Pvt.dump_api_info(p_pkg_name => G_PKG_NAME,

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

1399:
1400: -- Api body starts
1401:
1402: -- dbms_application_info.set_client_info('204');
1403: -- fnd_global.apps_initialize(1000200,52284,512,0);
1404:
1405: Debug('Validate the action code', l_mod_name, 1);
1406:
1407: -- Validate the action code

Line 1543: l_user_id := Fnd_Global.USER_ID;

1539: RAISE Fnd_Api.G_EXC_ERROR;
1540: END IF;
1541:
1542: -- Fetch user and login information
1543: l_user_id := Fnd_Global.USER_ID;
1544: l_login_id := Fnd_Global.CONC_LOGIN_ID;
1545:
1546: -- Validate Picking Rule
1547: OPEN pick_rule(p_order_rec.PICKING_RULE_ID);

Line 1544: l_login_id := Fnd_Global.CONC_LOGIN_ID;

1540: END IF;
1541:
1542: -- Fetch user and login information
1543: l_user_id := Fnd_Global.USER_ID;
1544: l_login_id := Fnd_Global.CONC_LOGIN_ID;
1545:
1546: -- Validate Picking Rule
1547: OPEN pick_rule(p_order_rec.PICKING_RULE_ID);
1548: FETCH pick_rule

Line 2971: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

2967: p_PROD_TXN_STATUS => 'ENTERED',
2968: p_PROD_TXN_CODE => x_product_txn_rec.PROD_TXN_CODE,
2969: p_LAST_UPDATE_DATE => SYSDATE,
2970: p_CREATION_DATE => SYSDATE,
2971: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2972: p_CREATED_BY => Fnd_Global.USER_ID,
2973: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
2974: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
2975: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,

Line 2972: p_CREATED_BY => Fnd_Global.USER_ID,

2968: p_PROD_TXN_CODE => x_product_txn_rec.PROD_TXN_CODE,
2969: p_LAST_UPDATE_DATE => SYSDATE,
2970: p_CREATION_DATE => SYSDATE,
2971: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2972: p_CREATED_BY => Fnd_Global.USER_ID,
2973: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
2974: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
2975: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,
2976: p_ATTRIBUTE3 => x_product_txn_rec.ATTRIBUTE3,

Line 2973: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,

2969: p_LAST_UPDATE_DATE => SYSDATE,
2970: p_CREATION_DATE => SYSDATE,
2971: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
2972: p_CREATED_BY => Fnd_Global.USER_ID,
2973: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
2974: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
2975: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,
2976: p_ATTRIBUTE3 => x_product_txn_rec.ATTRIBUTE3,
2977: p_ATTRIBUTE4 => x_product_txn_rec.ATTRIBUTE4,

Line 4462: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

4458: p_PROD_TXN_STATUS => 'SUBMITTED',
4459: p_PROD_TXN_CODE => x_product_txn_rec.PROD_TXN_CODE,
4460: p_LAST_UPDATE_DATE => SYSDATE,
4461: p_CREATION_DATE => SYSDATE,
4462: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4463: p_CREATED_BY => Fnd_Global.USER_ID,
4464: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
4465: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
4466: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,

Line 4463: p_CREATED_BY => Fnd_Global.USER_ID,

4459: p_PROD_TXN_CODE => x_product_txn_rec.PROD_TXN_CODE,
4460: p_LAST_UPDATE_DATE => SYSDATE,
4461: p_CREATION_DATE => SYSDATE,
4462: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4463: p_CREATED_BY => Fnd_Global.USER_ID,
4464: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
4465: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
4466: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,
4467: p_ATTRIBUTE3 => x_product_txn_rec.ATTRIBUTE3,

Line 4464: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,

4460: p_LAST_UPDATE_DATE => SYSDATE,
4461: p_CREATION_DATE => SYSDATE,
4462: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4463: p_CREATED_BY => Fnd_Global.USER_ID,
4464: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID,
4465: p_ATTRIBUTE1 => x_product_txn_rec.ATTRIBUTE1,
4466: p_ATTRIBUTE2 => x_product_txn_rec.ATTRIBUTE2,
4467: p_ATTRIBUTE3 => x_product_txn_rec.ATTRIBUTE3,
4468: p_ATTRIBUTE4 => x_product_txn_rec.ATTRIBUTE4,

Line 6029: p_CREATED_BY => Fnd_Global.USER_ID,

6025: p_REQUEST_ID => NULL,
6026: p_PROGRAM_ID => NULL,
6027: p_PROGRAM_APPLICATION_ID => NULL,
6028: p_PROGRAM_UPDATE_DATE => NULL,
6029: p_CREATED_BY => Fnd_Global.USER_ID,
6030: p_CREATION_DATE => SYSDATE,
6031: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6032: p_LAST_UPDATE_DATE => SYSDATE,
6033: p_repair_line_id => p_repair_line_id,

Line 6031: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

6027: p_PROGRAM_APPLICATION_ID => NULL,
6028: p_PROGRAM_UPDATE_DATE => NULL,
6029: p_CREATED_BY => Fnd_Global.USER_ID,
6030: p_CREATION_DATE => SYSDATE,
6031: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6032: p_LAST_UPDATE_DATE => SYSDATE,
6033: p_repair_line_id => p_repair_line_id,
6034: p_EVENT_CODE => l_event_code,
6035: p_EVENT_DATE => SYSDATE,

Line 6046: p_PARAMN10 => Fnd_Global.USER_ID,

6042: p_PARAMN6 => NULL,
6043: p_PARAMN7 => NULL,
6044: p_PARAMN8 => NULL,
6045: p_PARAMN9 => NULL,
6046: p_PARAMN10 => Fnd_Global.USER_ID,
6047: p_PARAMC1 => l_paramc1,
6048: p_PARAMC2 => l_paramc2,
6049: p_PARAMC3 => l_paramc3,
6050: p_PARAMC4 => l_paramc4,

Line 6083: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

6079: p_ATTRIBUTE12 => NULL,
6080: p_ATTRIBUTE13 => NULL,
6081: p_ATTRIBUTE14 => NULL,
6082: p_ATTRIBUTE15 => NULL,
6083: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
6084: X_Return_Status => x_return_status,
6085: X_Msg_Count => x_msg_count,
6086: X_Msg_Data => x_msg_data);
6087: --

Line 6348: p_CREATED_BY => FND_GLOBAL.USER_ID,

6344: p_REQUEST_ID => NULL,
6345: p_PROGRAM_ID => NULL,
6346: p_PROGRAM_APPLICATION_ID => NULL,
6347: p_PROGRAM_UPDATE_DATE => NULL,
6348: p_CREATED_BY => FND_GLOBAL.USER_ID,
6349: p_CREATION_DATE => SYSDATE,
6350: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
6351: p_LAST_UPDATE_DATE => SYSDATE,
6352: p_repair_line_id => p_repair_line_id,

Line 6350: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

6346: p_PROGRAM_APPLICATION_ID => NULL,
6347: p_PROGRAM_UPDATE_DATE => NULL,
6348: p_CREATED_BY => FND_GLOBAL.USER_ID,
6349: p_CREATION_DATE => SYSDATE,
6350: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
6351: p_LAST_UPDATE_DATE => SYSDATE,
6352: p_repair_line_id => p_repair_line_id,
6353: p_EVENT_CODE => l_event_code,
6354: p_EVENT_DATE => SYSDATE,

Line 6365: p_PARAMN10 => FND_GLOBAL.USER_ID,

6361: p_PARAMN6 => NULL,
6362: p_PARAMN7 => NULL,
6363: p_PARAMN8 => NULL,
6364: p_PARAMN9 => NULL,
6365: p_PARAMN10 => FND_GLOBAL.USER_ID,
6366: p_PARAMC1 => l_paramc1,
6367: p_PARAMC2 => l_paramc2,
6368: p_PARAMC3 => l_paramc3,
6369: p_PARAMC4 => l_paramc4,

Line 6402: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

6398: p_ATTRIBUTE12 => NULL,
6399: p_ATTRIBUTE13 => NULL,
6400: p_ATTRIBUTE14 => NULL,
6401: p_ATTRIBUTE15 => NULL,
6402: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
6403: X_Return_Status => x_return_status,
6404: X_Msg_Count => x_msg_count,
6405: X_Msg_Data => x_msg_data
6406: );

Line 6634: p_CREATED_BY => Fnd_Global.USER_ID,

6630: p_REQUEST_ID => NULL,
6631: p_PROGRAM_ID => NULL,
6632: p_PROGRAM_APPLICATION_ID => NULL,
6633: p_PROGRAM_UPDATE_DATE => NULL,
6634: p_CREATED_BY => Fnd_Global.USER_ID,
6635: p_CREATION_DATE => SYSDATE,
6636: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6637: p_LAST_UPDATE_DATE => SYSDATE,
6638: p_repair_line_id => p_task_activity_rec.repair_line_id,

Line 6636: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

6632: p_PROGRAM_APPLICATION_ID => NULL,
6633: p_PROGRAM_UPDATE_DATE => NULL,
6634: p_CREATED_BY => Fnd_Global.USER_ID,
6635: p_CREATION_DATE => SYSDATE,
6636: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6637: p_LAST_UPDATE_DATE => SYSDATE,
6638: p_repair_line_id => p_task_activity_rec.repair_line_id,
6639: p_EVENT_CODE => l_event_code,
6640: p_EVENT_DATE => SYSDATE,

Line 6651: p_PARAMN10 => Fnd_Global.USER_ID,

6647: p_PARAMN6 => p_task_activity_rec.new_resource_id, --l_paramn6,--assignee_id
6648: p_PARAMN7 => NULL,
6649: p_PARAMN8 => NULL,
6650: p_PARAMN9 => NULL,
6651: p_PARAMN10 => Fnd_Global.USER_ID,
6652: p_PARAMC1 => l_task_number,
6653: p_PARAMC2 => p_task_activity_rec.new_owner_type_code,
6654: p_PARAMC3 => p_task_activity_rec.new_owner_name,
6655: p_PARAMC4 => p_task_activity_rec.new_resource_type_code, --resource_type_code sangiguptask

Line 6688: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

6684: p_ATTRIBUTE12 => NULL,
6685: p_ATTRIBUTE13 => NULL,
6686: p_ATTRIBUTE14 => NULL,
6687: p_ATTRIBUTE15 => NULL,
6688: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
6689: X_Return_Status => x_return_status,
6690: X_Msg_Count => x_msg_count,
6691: X_Msg_Data => x_msg_data);
6692: --

Line 6890: p_CREATED_BY => Fnd_Global.USER_ID,

6886: p_REQUEST_ID => NULL,
6887: p_PROGRAM_ID => NULL,
6888: p_PROGRAM_APPLICATION_ID => NULL,
6889: p_PROGRAM_UPDATE_DATE => NULL,
6890: p_CREATED_BY => Fnd_Global.USER_ID,
6891: p_CREATION_DATE => SYSDATE,
6892: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6893: p_LAST_UPDATE_DATE => SYSDATE,
6894: p_repair_line_id => p_task_activity_rec.repair_line_id,

Line 6892: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

6888: p_PROGRAM_APPLICATION_ID => NULL,
6889: p_PROGRAM_UPDATE_DATE => NULL,
6890: p_CREATED_BY => Fnd_Global.USER_ID,
6891: p_CREATION_DATE => SYSDATE,
6892: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6893: p_LAST_UPDATE_DATE => SYSDATE,
6894: p_repair_line_id => p_task_activity_rec.repair_line_id,
6895: p_EVENT_CODE => l_event_code,
6896: p_EVENT_DATE => SYSDATE,

Line 6907: p_PARAMN10 => Fnd_Global.USER_ID,

6903: p_PARAMN6 => p_task_activity_rec.old_owner_id, -- assignee_id sangiguptask
6904: p_PARAMN7 => NULL,
6905: p_PARAMN8 => NULL,
6906: p_PARAMN9 => NULL,
6907: p_PARAMN10 => Fnd_Global.USER_ID,
6908: p_PARAMC1 => l_task_number, -- l_paramc1,-- task number
6909: p_PARAMC2 => p_task_activity_rec.new_owner_type_code, -- new owner type code
6910: p_PARAMC3 => p_task_activity_rec.new_owner_name, -- task owner name
6911: p_PARAMC4 => NULL, -- l_paramc4,-- asisgnee type

Line 6944: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

6940: p_ATTRIBUTE12 => NULL,
6941: p_ATTRIBUTE13 => NULL,
6942: p_ATTRIBUTE14 => NULL,
6943: p_ATTRIBUTE15 => NULL,
6944: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
6945: X_Return_Status => x_return_status,
6946: X_Msg_Count => x_msg_count,
6947: X_Msg_Data => x_msg_data);
6948:

Line 6970: p_CREATED_BY => Fnd_Global.USER_ID,

6966: p_REQUEST_ID => NULL,
6967: p_PROGRAM_ID => NULL,
6968: p_PROGRAM_APPLICATION_ID => NULL,
6969: p_PROGRAM_UPDATE_DATE => NULL,
6970: p_CREATED_BY => Fnd_Global.USER_ID,
6971: p_CREATION_DATE => SYSDATE,
6972: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6973: p_LAST_UPDATE_DATE => SYSDATE,
6974: p_repair_line_id => p_task_activity_rec.repair_line_id,

Line 6972: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

6968: p_PROGRAM_APPLICATION_ID => NULL,
6969: p_PROGRAM_UPDATE_DATE => NULL,
6970: p_CREATED_BY => Fnd_Global.USER_ID,
6971: p_CREATION_DATE => SYSDATE,
6972: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
6973: p_LAST_UPDATE_DATE => SYSDATE,
6974: p_repair_line_id => p_task_activity_rec.repair_line_id,
6975: p_EVENT_CODE => l_event_code,
6976: p_EVENT_DATE => SYSDATE,

Line 6987: p_PARAMN10 => Fnd_Global.USER_ID,

6983: p_PARAMN6 => p_task_activity_rec.old_status_id,
6984: p_PARAMN7 => NULL,
6985: p_PARAMN8 => NULL,
6986: p_PARAMN9 => NULL,
6987: p_PARAMN10 => Fnd_Global.USER_ID,
6988: p_PARAMC1 => l_task_number, -- task number
6989: p_PARAMC2 => p_task_activity_rec.new_owner_type_code, -- new owner type code
6990: p_PARAMC3 => p_task_activity_rec.new_owner_name, -- task owner name
6991: p_PARAMC4 => NULL, -- asisgnee type

Line 7024: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

7020: p_ATTRIBUTE12 => NULL,
7021: p_ATTRIBUTE13 => NULL,
7022: p_ATTRIBUTE14 => NULL,
7023: p_ATTRIBUTE15 => NULL,
7024: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
7025: X_Return_Status => x_return_status,
7026: X_Msg_Count => x_msg_count,
7027: X_Msg_Data => x_msg_data);
7028:

Line 7050: p_CREATED_BY => Fnd_Global.USER_ID,

7046: p_REQUEST_ID => NULL,
7047: p_PROGRAM_ID => NULL,
7048: p_PROGRAM_APPLICATION_ID => NULL,
7049: p_PROGRAM_UPDATE_DATE => NULL,
7050: p_CREATED_BY => Fnd_Global.USER_ID,
7051: p_CREATION_DATE => SYSDATE,
7052: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
7053: p_LAST_UPDATE_DATE => SYSDATE,
7054: p_repair_line_id => p_task_activity_rec.repair_line_id,

Line 7052: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

7048: p_PROGRAM_APPLICATION_ID => NULL,
7049: p_PROGRAM_UPDATE_DATE => NULL,
7050: p_CREATED_BY => Fnd_Global.USER_ID,
7051: p_CREATION_DATE => SYSDATE,
7052: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
7053: p_LAST_UPDATE_DATE => SYSDATE,
7054: p_repair_line_id => p_task_activity_rec.repair_line_id,
7055: p_EVENT_CODE => l_event_code,
7056: p_EVENT_DATE => SYSDATE,

Line 7067: p_PARAMN10 => Fnd_Global.USER_ID,

7063: p_PARAMN6 => NULL,
7064: p_PARAMN7 => NULL,
7065: p_PARAMN8 => NULL,
7066: p_PARAMN9 => NULL,
7067: p_PARAMN10 => Fnd_Global.USER_ID,
7068: p_PARAMC1 => l_task_number, -- task number
7069: p_PARAMC2 => NULL,
7070: p_PARAMC3 => NULL,
7071: p_PARAMC4 => p_task_activity_rec.new_resource_type_code, -- new assignee type code

Line 7104: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

7100: p_ATTRIBUTE12 => NULL,
7101: p_ATTRIBUTE13 => NULL,
7102: p_ATTRIBUTE14 => NULL,
7103: p_ATTRIBUTE15 => NULL,
7104: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
7105: X_Return_Status => x_return_status,
7106: X_Msg_Count => x_msg_count,
7107: X_Msg_Data => x_msg_data);
7108:

Line 7556: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,

7552: p_commit => 'F',
7553: x_return_status => l_return_status,
7554: x_msg_count => l_msg_count,
7555: x_msg_data => l_msg_data,
7556: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7557: p_resp_id => Fnd_Global.RESP_ID,
7558: p_user_id => Fnd_Global.USER_ID,
7559: p_login_id => Fnd_Global.LOGIN_ID,
7560: p_request_id => p_incident_id,

Line 7557: p_resp_id => Fnd_Global.RESP_ID,

7553: x_return_status => l_return_status,
7554: x_msg_count => l_msg_count,
7555: x_msg_data => l_msg_data,
7556: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7557: p_resp_id => Fnd_Global.RESP_ID,
7558: p_user_id => Fnd_Global.USER_ID,
7559: p_login_id => Fnd_Global.LOGIN_ID,
7560: p_request_id => p_incident_id,
7561: p_request_number => NULL,

Line 7558: p_user_id => Fnd_Global.USER_ID,

7554: x_msg_count => l_msg_count,
7555: x_msg_data => l_msg_data,
7556: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7557: p_resp_id => Fnd_Global.RESP_ID,
7558: p_user_id => Fnd_Global.USER_ID,
7559: p_login_id => Fnd_Global.LOGIN_ID,
7560: p_request_id => p_incident_id,
7561: p_request_number => NULL,
7562: p_object_version_number => l_inc_obj_version_number,

Line 7559: p_login_id => Fnd_Global.LOGIN_ID,

7555: x_msg_data => l_msg_data,
7556: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7557: p_resp_id => Fnd_Global.RESP_ID,
7558: p_user_id => Fnd_Global.USER_ID,
7559: p_login_id => Fnd_Global.LOGIN_ID,
7560: p_request_id => p_incident_id,
7561: p_request_number => NULL,
7562: p_object_version_number => l_inc_obj_version_number,
7563: p_status_id => NULL,

Line 7792: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,

7788: p_commit => 'F',
7789: x_return_status => l_return_status,
7790: x_msg_count => l_msg_count,
7791: x_msg_data => l_msg_data,
7792: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7793: p_resp_id => Fnd_Global.RESP_ID,
7794: p_user_id => Fnd_Global.USER_ID,
7795: p_login_id => Fnd_Global.LOGIN_ID,
7796: p_request_id => l_incident_id,

Line 7793: p_resp_id => Fnd_Global.RESP_ID,

7789: x_return_status => l_return_status,
7790: x_msg_count => l_msg_count,
7791: x_msg_data => l_msg_data,
7792: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7793: p_resp_id => Fnd_Global.RESP_ID,
7794: p_user_id => Fnd_Global.USER_ID,
7795: p_login_id => Fnd_Global.LOGIN_ID,
7796: p_request_id => l_incident_id,
7797: p_request_number => NULL,

Line 7794: p_user_id => Fnd_Global.USER_ID,

7790: x_msg_count => l_msg_count,
7791: x_msg_data => l_msg_data,
7792: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7793: p_resp_id => Fnd_Global.RESP_ID,
7794: p_user_id => Fnd_Global.USER_ID,
7795: p_login_id => Fnd_Global.LOGIN_ID,
7796: p_request_id => l_incident_id,
7797: p_request_number => NULL,
7798: p_object_version_number => l_inc_obj_version_number,

Line 7795: p_login_id => Fnd_Global.LOGIN_ID,

7791: x_msg_data => l_msg_data,
7792: p_resp_appl_id => Fnd_Global.RESP_APPL_ID,
7793: p_resp_id => Fnd_Global.RESP_ID,
7794: p_user_id => Fnd_Global.USER_ID,
7795: p_login_id => Fnd_Global.LOGIN_ID,
7796: p_request_id => l_incident_id,
7797: p_request_number => NULL,
7798: p_object_version_number => l_inc_obj_version_number,
7799: p_status_id => NULL,

Line 8648: Last_Updated_By = Fnd_Global.User_Id,

8644: SET prod_txn_status = C_Status_Released,
8645: release_sales_order_flag = C_Yes,
8646: object_version_number = Object_Version_Number + 1,
8647: Last_Update_Date = SYSDATE,
8648: Last_Updated_By = Fnd_Global.User_Id,
8649: Last_Update_login = Fnd_Global.Login_Id
8650: WHERE order_header_id =
8651: released_line_rec.source_header_id
8652: AND order_line_id =

Line 8649: Last_Update_login = Fnd_Global.Login_Id

8645: release_sales_order_flag = C_Yes,
8646: object_version_number = Object_Version_Number + 1,
8647: Last_Update_Date = SYSDATE,
8648: Last_Updated_By = Fnd_Global.User_Id,
8649: Last_Update_login = Fnd_Global.Login_Id
8650: WHERE order_header_id =
8651: released_line_rec.source_header_id
8652: AND order_line_id =
8653: released_line_rec.source_line_id

Line 8680: Last_Updated_By = Fnd_Global.User_Id,

8676: update csd_repairs
8677: set ro_txn_status = 'OM_RELEASED' ,
8678: object_version_number = Object_Version_Number + 1,
8679: Last_Update_Date = Sysdate,
8680: Last_Updated_By = Fnd_Global.User_Id,
8681: Last_Update_login = Fnd_Global.Login_Id
8682: where repair_line_id = x_product_txn_rec.repair_line_id;
8683: if sql%notfound then
8684: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');

Line 8681: Last_Update_login = Fnd_Global.Login_Id

8677: set ro_txn_status = 'OM_RELEASED' ,
8678: object_version_number = Object_Version_Number + 1,
8679: Last_Update_Date = Sysdate,
8680: Last_Updated_By = Fnd_Global.User_Id,
8681: Last_Update_login = Fnd_Global.Login_Id
8682: where repair_line_id = x_product_txn_rec.repair_line_id;
8683: if sql%notfound then
8684: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
8685: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);

Line 8836: Last_Updated_By = Fnd_Global.User_Id,

8832: release_sales_order_flag = C_Yes,
8833: ship_sales_order_flag = C_Yes,
8834: object_version_number = Object_Version_Number + 1,
8835: Last_Update_Date = SYSDATE,
8836: Last_Updated_By = Fnd_Global.User_Id,
8837: Last_Update_login = Fnd_Global.Login_Id
8838: WHERE order_header_id =
8839: shipped_line_rec.source_header_id
8840: AND order_line_id =

Line 8837: Last_Update_login = Fnd_Global.Login_Id

8833: ship_sales_order_flag = C_Yes,
8834: object_version_number = Object_Version_Number + 1,
8835: Last_Update_Date = SYSDATE,
8836: Last_Updated_By = Fnd_Global.User_Id,
8837: Last_Update_login = Fnd_Global.Login_Id
8838: WHERE order_header_id =
8839: shipped_line_rec.source_header_id
8840: AND order_line_id =
8841: shipped_line_rec.source_line_id

Line 8870: Last_Updated_By = Fnd_Global.User_Id,

8866: Update csd_repairs
8867: Set ro_txn_status = 'OM_SHIPPED' ,
8868: object_version_number = Object_Version_Number + 1,
8869: Last_Update_Date = Sysdate,
8870: Last_Updated_By = Fnd_Global.User_Id,
8871: Last_Update_login = Fnd_Global.Login_Id
8872: Where repair_line_id = x_product_txn_rec.repair_line_id;
8873: If sql%notfound then
8874: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');

Line 8871: Last_Update_login = Fnd_Global.Login_Id

8867: Set ro_txn_status = 'OM_SHIPPED' ,
8868: object_version_number = Object_Version_Number + 1,
8869: Last_Update_Date = Sysdate,
8870: Last_Updated_By = Fnd_Global.User_Id,
8871: Last_Update_login = Fnd_Global.Login_Id
8872: Where repair_line_id = x_product_txn_rec.repair_line_id;
8873: If sql%notfound then
8874: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
8875: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);

Line 9391: p_CREATED_BY => Fnd_Global.USER_ID,

9387: p_TASK_ID => p_create_repair_task_rec.task_id,
9388: p_OBJECT_VERSION_NUMBER => 1,
9389: p_REPAIR_LINE_ID => p_create_repair_task_rec.repair_line_id,
9390: p_APPLICABLE_QA_PLANS => l_applicable_qa_plans,
9391: p_CREATED_BY => Fnd_Global.USER_ID,
9392: p_CREATION_DATE => SYSDATE,
9393: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9394: p_LAST_UPDATE_DATE => SYSDATE,
9395: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);

Line 9393: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

9389: p_REPAIR_LINE_ID => p_create_repair_task_rec.repair_line_id,
9390: p_APPLICABLE_QA_PLANS => l_applicable_qa_plans,
9391: p_CREATED_BY => Fnd_Global.USER_ID,
9392: p_CREATION_DATE => SYSDATE,
9393: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9394: p_LAST_UPDATE_DATE => SYSDATE,
9395: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);
9396:
9397: -- -------------------

Line 9395: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);

9391: p_CREATED_BY => Fnd_Global.USER_ID,
9392: p_CREATION_DATE => SYSDATE,
9393: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9394: p_LAST_UPDATE_DATE => SYSDATE,
9395: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);
9396:
9397: -- -------------------
9398: -- Api body ends here
9399: -- -------------------

Line 9608: p_CREATED_BY => Fnd_Global.USER_ID,

9604: p_task_id => p_update_repair_task_rec.task_id,
9605: p_OBJECT_VERSION_NUMBER => p_update_repair_task_rec.object_version_number,
9606: p_REPAIR_LINE_ID => p_update_repair_task_rec.repair_line_id,
9607: p_APPLICABLE_QA_PLANS => l_applicable_qa_plans,
9608: p_CREATED_BY => Fnd_Global.USER_ID,
9609: p_CREATION_DATE => SYSDATE,
9610: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9611: p_LAST_UPDATE_DATE => SYSDATE,
9612: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);

Line 9610: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

9606: p_REPAIR_LINE_ID => p_update_repair_task_rec.repair_line_id,
9607: p_APPLICABLE_QA_PLANS => l_applicable_qa_plans,
9608: p_CREATED_BY => Fnd_Global.USER_ID,
9609: p_CREATION_DATE => SYSDATE,
9610: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9611: p_LAST_UPDATE_DATE => SYSDATE,
9612: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);
9613:
9614: -- -------------------

Line 9612: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);

9608: p_CREATED_BY => Fnd_Global.USER_ID,
9609: p_CREATION_DATE => SYSDATE,
9610: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
9611: p_LAST_UPDATE_DATE => SYSDATE,
9612: p_LAST_UPDATE_LOGIN => Fnd_Global.USER_ID);
9613:
9614: -- -------------------
9615: -- Api body ends here
9616: -- -------------------