DBA Data[Home] [Help]

APPS.PO_CLM_CAR_UTIL dependencies on FND_GLOBAL

Line 139: fnd_global.user_id,

135: NVL(p_clm_car_row.prepared_user, get_prepared_user()),
136: p_clm_car_row.date_signed,
137: p_clm_car_row.car_xml,
138: sysdate,
139: fnd_global.user_id,
140: sysdate,
141: fnd_global.user_id,
142: fnd_global.login_id)
143: WHEN MATCHED THEN UPDATE SET c.report_type = NVL(p_clm_car_row.report_type, c.report_type),

Line 141: fnd_global.user_id,

137: p_clm_car_row.car_xml,
138: sysdate,
139: fnd_global.user_id,
140: sysdate,
141: fnd_global.user_id,
142: fnd_global.login_id)
143: WHEN MATCHED THEN UPDATE SET c.report_type = NVL(p_clm_car_row.report_type, c.report_type),
144: c.award_idv_type = NVL(p_clm_car_row.award_idv_type, c.award_idv_type),
145: c.car_status = NVL(p_clm_car_row.car_status, c.car_status),

Line 142: fnd_global.login_id)

138: sysdate,
139: fnd_global.user_id,
140: sysdate,
141: fnd_global.user_id,
142: fnd_global.login_id)
143: WHEN MATCHED THEN UPDATE SET c.report_type = NVL(p_clm_car_row.report_type, c.report_type),
144: c.award_idv_type = NVL(p_clm_car_row.award_idv_type, c.award_idv_type),
145: c.car_status = NVL(p_clm_car_row.car_status, c.car_status),
146: c.car_number = NVL(p_clm_car_row.car_number,

Line 166: c.last_updated_by = fnd_global.user_id,

162: c.prepared_user = NVL(p_clm_car_row.prepared_user, c.prepared_user),
163: c.date_signed = NVL(p_clm_car_row.date_signed, c.date_signed),
164: c.car_xml = NVL(p_clm_car_row.car_xml, c.car_xml),
165: c.last_update_date = sysdate,
166: c.last_updated_by = fnd_global.user_id,
167: c.creation_date = sysdate,
168: c.created_by = fnd_global.user_id,
169: c.last_update_login = fnd_global.login_id;
170: IF p_commit = 'T' THEN

Line 168: c.created_by = fnd_global.user_id,

164: c.car_xml = NVL(p_clm_car_row.car_xml, c.car_xml),
165: c.last_update_date = sysdate,
166: c.last_updated_by = fnd_global.user_id,
167: c.creation_date = sysdate,
168: c.created_by = fnd_global.user_id,
169: c.last_update_login = fnd_global.login_id;
170: IF p_commit = 'T' THEN
171: COMMIT;
172: END IF;

Line 169: c.last_update_login = fnd_global.login_id;

165: c.last_update_date = sysdate,
166: c.last_updated_by = fnd_global.user_id,
167: c.creation_date = sysdate,
168: c.created_by = fnd_global.user_id,
169: c.last_update_login = fnd_global.login_id;
170: IF p_commit = 'T' THEN
171: COMMIT;
172: END IF;
173: x_car_id := l_car_id;

Line 336: fnd_global.user_id,

332: p_clm_car_log_tab(i).module,
333: p_clm_car_log_tab(i).message_level,
334: p_clm_car_log_tab(i).message_text,
335: sysdate,
336: fnd_global.user_id,
337: sysdate,
338: fnd_global.user_id,
339: fnd_global.login_id,
340: p_clm_car_log_tab(i).message_code);

Line 338: fnd_global.user_id,

334: p_clm_car_log_tab(i).message_text,
335: sysdate,
336: fnd_global.user_id,
337: sysdate,
338: fnd_global.user_id,
339: fnd_global.login_id,
340: p_clm_car_log_tab(i).message_code);
341: END LOOP;
342: END IF;

Line 339: fnd_global.login_id,

335: sysdate,
336: fnd_global.user_id,
337: sysdate,
338: fnd_global.user_id,
339: fnd_global.login_id,
340: p_clm_car_log_tab(i).message_code);
341: END LOOP;
342: END IF;
343:

Line 766: FND_GLOBAL.user_id,

762: '0',
763: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes
764: po_clm_car_util.get_prepared_user(),
765: SYSDATE,
766: FND_GLOBAL.user_id,
767: SYSDATE,
768: FND_GLOBAL.user_id,
769: FND_GLOBAL.login_id,
770: po_clm_car_util.get_piid(p_po_header_id, p_draft_id));

Line 768: FND_GLOBAL.user_id,

764: po_clm_car_util.get_prepared_user(),
765: SYSDATE,
766: FND_GLOBAL.user_id,
767: SYSDATE,
768: FND_GLOBAL.user_id,
769: FND_GLOBAL.login_id,
770: po_clm_car_util.get_piid(p_po_header_id, p_draft_id));
771: END;
772: END;

Line 769: FND_GLOBAL.login_id,

765: SYSDATE,
766: FND_GLOBAL.user_id,
767: SYSDATE,
768: FND_GLOBAL.user_id,
769: FND_GLOBAL.login_id,
770: po_clm_car_util.get_piid(p_po_header_id, p_draft_id));
771: END;
772: END;
773:

Line 978: last_updated_by = FND_GLOBAL.user_id,

974: 2),
975: rel_without_rpt_reason = l_fpds_reason,
976: exemption_reason = l_exemptiom_reason,
977: last_update_date = sysdate,
978: last_updated_by = FND_GLOBAL.user_id,
979: last_update_login = FND_GLOBAL.login_id
980: WHERE car_id = l_car_id
981: AND reporting_method <> l_fpds_reporting_method
982: AND rel_without_rpt_reason <> l_fpds_reason;

Line 979: last_update_login = FND_GLOBAL.login_id

975: rel_without_rpt_reason = l_fpds_reason,
976: exemption_reason = l_exemptiom_reason,
977: last_update_date = sysdate,
978: last_updated_by = FND_GLOBAL.user_id,
979: last_update_login = FND_GLOBAL.login_id
980: WHERE car_id = l_car_id
981: AND reporting_method <> l_fpds_reporting_method
982: AND rel_without_rpt_reason <> l_fpds_reason;
983:

Line 1054: FND_GLOBAL.user_id,

1050: '0',
1051: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes
1052: po_clm_car_util.get_prepared_user(),
1053: SYSDATE,
1054: FND_GLOBAL.user_id,
1055: SYSDATE,
1056: FND_GLOBAL.user_id,
1057: FND_GLOBAL.login_id,
1058: l_PIID);

Line 1056: FND_GLOBAL.user_id,

1052: po_clm_car_util.get_prepared_user(),
1053: SYSDATE,
1054: FND_GLOBAL.user_id,
1055: SYSDATE,
1056: FND_GLOBAL.user_id,
1057: FND_GLOBAL.login_id,
1058: l_PIID);
1059: END; -- End for main begin
1060: END IF; -- End if for FPDS.REPORTING_METHOD and REASON

Line 1057: FND_GLOBAL.login_id,

1053: SYSDATE,
1054: FND_GLOBAL.user_id,
1055: SYSDATE,
1056: FND_GLOBAL.user_id,
1057: FND_GLOBAL.login_id,
1058: l_PIID);
1059: END; -- End for main begin
1060: END IF; -- End if for FPDS.REPORTING_METHOD and REASON
1061: