DBA Data[Home] [Help]

APPS.CSD_REPAIRS_PVT dependencies on FND_GLOBAL

Line 48: G_USER_ID NUMBER := Fnd_Global.USER_ID;

44: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvdrab.pls';
45: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
46: --
47:
48: G_USER_ID NUMBER := Fnd_Global.USER_ID;
49: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
50: G_REQUEST_ID NUMBER := Fnd_Global.CONC_REQUEST_ID;
51: G_PROGRAM_ID NUMBER := Fnd_Global.CONC_PROGRAM_ID;
52: G_PROG_APPL_ID NUMBER := Fnd_Global.PROG_APPL_ID;

Line 49: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;

45: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
46: --
47:
48: G_USER_ID NUMBER := Fnd_Global.USER_ID;
49: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
50: G_REQUEST_ID NUMBER := Fnd_Global.CONC_REQUEST_ID;
51: G_PROGRAM_ID NUMBER := Fnd_Global.CONC_PROGRAM_ID;
52: G_PROG_APPL_ID NUMBER := Fnd_Global.PROG_APPL_ID;
53: --

Line 50: G_REQUEST_ID NUMBER := Fnd_Global.CONC_REQUEST_ID;

46: --
47:
48: G_USER_ID NUMBER := Fnd_Global.USER_ID;
49: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
50: G_REQUEST_ID NUMBER := Fnd_Global.CONC_REQUEST_ID;
51: G_PROGRAM_ID NUMBER := Fnd_Global.CONC_PROGRAM_ID;
52: G_PROG_APPL_ID NUMBER := Fnd_Global.PROG_APPL_ID;
53: --
54: procedure debug(l_msg varchar2) is

Line 51: G_PROGRAM_ID NUMBER := Fnd_Global.CONC_PROGRAM_ID;

47:
48: G_USER_ID NUMBER := Fnd_Global.USER_ID;
49: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
50: G_REQUEST_ID NUMBER := Fnd_Global.CONC_REQUEST_ID;
51: G_PROGRAM_ID NUMBER := Fnd_Global.CONC_PROGRAM_ID;
52: G_PROG_APPL_ID NUMBER := Fnd_Global.PROG_APPL_ID;
53: --
54: procedure debug(l_msg varchar2) is
55: --pragma autonomous_transaction;

Line 52: G_PROG_APPL_ID NUMBER := Fnd_Global.PROG_APPL_ID;

48: G_USER_ID NUMBER := Fnd_Global.USER_ID;
49: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
50: G_REQUEST_ID NUMBER := Fnd_Global.CONC_REQUEST_ID;
51: G_PROGRAM_ID NUMBER := Fnd_Global.CONC_PROGRAM_ID;
52: G_PROG_APPL_ID NUMBER := Fnd_Global.PROG_APPL_ID;
53: --
54: procedure debug(l_msg varchar2) is
55: --pragma autonomous_transaction;
56: begin

Line 3183: Fnd_Global.user_id,

3179:
3180: Fnd_Documents_Pkg.Insert_Row(l_row_id_tmp,
3181: l_document_id_tmp,
3182: SYSDATE,
3183: Fnd_Global.user_id,
3184: SYSDATE,
3185: Fnd_Global.user_id,
3186: Fnd_Global.user_id,
3187: docrec.datatype_id,

Line 3185: Fnd_Global.user_id,

3181: l_document_id_tmp,
3182: SYSDATE,
3183: Fnd_Global.user_id,
3184: SYSDATE,
3185: Fnd_Global.user_id,
3186: Fnd_Global.user_id,
3187: docrec.datatype_id,
3188: docrec.category_id,
3189: docrec.security_type,

Line 3186: Fnd_Global.user_id,

3182: SYSDATE,
3183: Fnd_Global.user_id,
3184: SYSDATE,
3185: Fnd_Global.user_id,
3186: Fnd_Global.user_id,
3187: docrec.datatype_id,
3188: docrec.category_id,
3189: docrec.security_type,
3190: docrec.security_id,

Line 3371: Fnd_Global.user_id,

3367: (SELECT
3368: fnd_attached_documents_s.NEXTVAL,
3369: docrec.document_id,
3370: SYSDATE,
3371: Fnd_Global.user_id,
3372: SYSDATE,
3373: Fnd_Global.user_id,
3374: Fnd_Global.user_id,
3375: docrec.seq_num,

Line 3373: Fnd_Global.user_id,

3369: docrec.document_id,
3370: SYSDATE,
3371: Fnd_Global.user_id,
3372: SYSDATE,
3373: Fnd_Global.user_id,
3374: Fnd_Global.user_id,
3375: docrec.seq_num,
3376: entity_name,
3377: TO_CHAR(p_new_ro_id),

Line 3374: Fnd_Global.user_id,

3370: SYSDATE,
3371: Fnd_Global.user_id,
3372: SYSDATE,
3373: Fnd_Global.user_id,
3374: Fnd_Global.user_id,
3375: docrec.seq_num,
3376: entity_name,
3377: TO_CHAR(p_new_ro_id),
3378: pk2_value,

Line 4217: p_responsibility_id => Fnd_Global.resp_id

4213:
4214: IF NOT Is_Flwsts_Update_Allowed(p_repair_type_id => p_repair_type_id,
4215: p_from_flow_status_id => p_from_flow_status_id,
4216: p_to_flow_status_id => p_to_flow_status_id,
4217: p_responsibility_id => Fnd_Global.resp_id
4218: ) THEN
4219: -- Unable to update repair status. The user does not
4220: -- have access to update the repair status.
4221: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_NO_ACCESS');

Line 4318: last_updated_by = Fnd_Global.USER_ID,

4314: status_reason_code = p_reason_code,
4315: date_closed = DECODE(l_to_status_code, 'C', SYSDATE, NULL),
4316: wf_item_key = NVL(l_wf_item_key, wf_item_key),
4317: wf_item_type = NVL(l_wf_item_type, wf_item_type),
4318: last_updated_by = Fnd_Global.USER_ID,
4319: last_update_date = SYSDATE,
4320: last_update_login = Fnd_Global.LOGIN_ID,
4321: object_version_number = object_version_number + 1
4322: WHERE repair_line_id = p_repair_line_id AND

Line 4320: last_update_login = Fnd_Global.LOGIN_ID,

4316: wf_item_key = NVL(l_wf_item_key, wf_item_key),
4317: wf_item_type = NVL(l_wf_item_type, wf_item_type),
4318: last_updated_by = Fnd_Global.USER_ID,
4319: last_update_date = SYSDATE,
4320: last_update_login = Fnd_Global.LOGIN_ID,
4321: object_version_number = object_version_number + 1
4322: WHERE repair_line_id = p_repair_line_id AND
4323: flow_status_id = p_from_flow_status_id; -- swai: bug 6937272 (FP of 6882484)
4324: -- object_version_number = p_object_version_number;

Line 4381: p_CREATED_BY => Fnd_Global.USER_ID,

4377: p_REQUEST_ID => NULL,
4378: p_PROGRAM_ID => NULL,
4379: p_PROGRAM_APPLICATION_ID => NULL,
4380: p_PROGRAM_UPDATE_DATE => NULL,
4381: p_CREATED_BY => Fnd_Global.USER_ID,
4382: p_CREATION_DATE => SYSDATE,
4383: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4384: p_LAST_UPDATE_DATE => SYSDATE,
4385: p_repair_line_id => p_repair_line_id,

Line 4383: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,

4379: p_PROGRAM_APPLICATION_ID => NULL,
4380: p_PROGRAM_UPDATE_DATE => NULL,
4381: p_CREATED_BY => Fnd_Global.USER_ID,
4382: p_CREATION_DATE => SYSDATE,
4383: p_LAST_UPDATED_BY => Fnd_Global.USER_ID,
4384: p_LAST_UPDATE_DATE => SYSDATE,
4385: p_repair_line_id => p_repair_line_id,
4386: p_EVENT_CODE => lc_update_fs_event_code,
4387: p_EVENT_DATE => SYSDATE,

Line 4392: p_PARAMN10 => Fnd_Global.USER_ID,

4388: -- p_QUANTITY => p_quantity,
4389: p_PARAMN1 => NULL,
4390: p_PARAMN2 => NULL,
4391: p_PARAMN3 => NULL,
4392: p_PARAMN10 => Fnd_Global.USER_ID,
4393: p_PARAMC1 => l_to_flow_status_code,
4394: p_PARAMC2 => l_from_flow_status_code,
4395: p_PARAMC3 => l_reason_meaning,
4396: p_PARAMC4 => NULL,

Line 4402: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,

4398: p_PARAMC6 => p_comments,
4399: p_PARAMC7 => l_wf_item_type,
4400: p_PARAMC8 => l_wf_item_key,
4401: p_PARAMC9 => l_wf_process_name,
4402: p_LAST_UPDATE_LOGIN => Fnd_Global.CONC_LOGIN_ID,
4403: X_Return_Status => x_return_status,
4404: X_Msg_Count => x_msg_count,
4405: X_Msg_Data => x_msg_data
4406: );

Line 4844: p_responsibility_id => Fnd_Global.resp_id

4840:
4841: IF NOT Is_Rt_Update_Allowed(p_from_repair_type_id => p_from_repair_type_id,
4842: p_to_repair_type_id => p_to_repair_type_id,
4843: p_common_flow_status_id => p_common_flow_status_id,
4844: p_responsibility_id => Fnd_Global.resp_id
4845: ) THEN
4846: -- Unable to update repair type. The user does not
4847: -- have access to update the repair type.
4848: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TRANS_NO_ACCESS');

Line 4888: last_updated_by = Fnd_Global.USER_ID,

4884: BEGIN
4885:
4886: UPDATE CSD_REPAIRS
4887: SET repair_type_id = p_to_repair_type_id,
4888: last_updated_by = Fnd_Global.USER_ID,
4889: last_update_date = SYSDATE,
4890: last_update_login = Fnd_Global.LOGIN_ID,
4891: object_version_number = object_version_number + 1
4892: WHERE repair_line_id = p_repair_line_id AND

Line 4890: last_update_login = Fnd_Global.LOGIN_ID,

4886: UPDATE CSD_REPAIRS
4887: SET repair_type_id = p_to_repair_type_id,
4888: last_updated_by = Fnd_Global.USER_ID,
4889: last_update_date = SYSDATE,
4890: last_update_login = Fnd_Global.LOGIN_ID,
4891: object_version_number = object_version_number + 1
4892: WHERE repair_line_id = p_repair_line_id AND
4893: object_version_number = p_object_version_number;
4894:

Line 4939: p_PARAMN3 => Fnd_Global.USER_ID,

4935: p_EVENT_CODE => lc_update_rt_event_code,
4936: p_EVENT_DATE => SYSDATE,
4937: p_PARAMN1 => p_from_repair_type_id,
4938: p_PARAMN2 => p_to_repair_type_id,
4939: p_PARAMN3 => Fnd_Global.USER_ID,
4940: p_PARAMC1 => p_reason_code,
4941: X_Return_Status => x_return_status,
4942: X_Msg_Count => x_msg_count,
4943: X_Msg_Data => x_msg_data

Line 4959: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

4955: p_PROGRAM_APPLICATION_ID => NULL,
4956: p_PROGRAM_UPDATE_DATE => NULL,
4957: p_CREATED_BY => 1,
4958: p_CREATION_DATE => SYSDATE,
4959: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
4960: p_LAST_UPDATE_DATE => SYSDATE,
4961: p_repair_line_id => p_repair_line_id,
4962: p_EVENT_CODE => 'RTU',
4963: p_EVENT_DATE => SYSDATE,

Line 4967: p_PARAMN3 => fnd_global.user_id,--NULL,

4963: p_EVENT_DATE => SYSDATE,
4964: p_QUANTITY => NULL,
4965: p_PARAMN1 => p_from_repair_type_id,
4966: p_PARAMN2 => p_to_repair_type_id,
4967: p_PARAMN3 => fnd_global.user_id,--NULL,
4968: p_PARAMN4 => NULL,
4969: p_PARAMN5 => NULL,
4970: p_PARAMN6 => NULL,
4971: p_PARAMN7 => NULL,

Line 5011: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

5007: p_ATTRIBUTE12 => NULL,
5008: p_ATTRIBUTE13 => NULL,
5009: p_ATTRIBUTE14 => NULL,
5010: p_ATTRIBUTE15 => NULL,
5011: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
5012: X_Return_Status => x_return_status,
5013: X_Msg_Count => x_msg_count,
5014: X_Msg_Data => x_msg_data
5015: );