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_RECALLS_PVT dependencies on FND_GLOBAL

Line 65: l_user_id NUMBER := fnd_global.user_id;

61: x_return_status VARCHAR2(1);
62: x_msg_count NUMBER;
63: x_msg_data VARCHAR2(2000);
64: x_job_xref_id NUMBER;
65: l_user_id NUMBER := fnd_global.user_id;
66: l_rep_hist_id NUMBER;
67: l_operation_seq_num NUMBER;
68: l_department_id NUMBER;
69: l_supply_subinventory VARCHAR2(30);

Line 1081: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;

1077: l_job_header_tbl(l_job_header_index).process_phase := 2;
1078: l_job_header_tbl(l_job_header_index).process_status := 1;
1079: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
1080: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
1081: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
1082: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
1083: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
1084: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_item_id,l_csd_recall_lines_tbl(l_index).inventory_item_id);
1085: l_job_header_tbl(l_job_header_index).start_quantity := l_csd_recall_lines_tbl(l_index).quantity;

Line 1082: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;

1078: l_job_header_tbl(l_job_header_index).process_status := 1;
1079: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
1080: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
1081: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
1082: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
1083: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
1084: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_item_id,l_csd_recall_lines_tbl(l_index).inventory_item_id);
1085: l_job_header_tbl(l_job_header_index).start_quantity := l_csd_recall_lines_tbl(l_index).quantity;
1086: l_job_header_tbl(l_job_header_index).first_unit_start_date := sysdate;

Line 1083: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;

1079: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
1080: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
1081: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
1082: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
1083: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
1084: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_item_id,l_csd_recall_lines_tbl(l_index).inventory_item_id);
1085: l_job_header_tbl(l_job_header_index).start_quantity := l_csd_recall_lines_tbl(l_index).quantity;
1086: l_job_header_tbl(l_job_header_index).first_unit_start_date := sysdate;
1087: l_job_header_tbl(l_job_header_index).last_unit_completion_date := sysdate + 1;

Line 1112: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;

1108: l_job_header_tbl(l_job_header_index).process_phase := 2;
1109: l_job_header_tbl(l_job_header_index).process_status := 1;
1110: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
1111: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
1112: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
1113: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
1114: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
1115: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_item_id,l_csd_recall_lines_tbl(l_index).inventory_item_id);
1116: l_job_header_tbl(l_job_header_index).start_quantity := l_csd_recall_lines_tbl(l_index).quantity;

Line 1113: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;

1109: l_job_header_tbl(l_job_header_index).process_status := 1;
1110: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
1111: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
1112: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
1113: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
1114: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
1115: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_item_id,l_csd_recall_lines_tbl(l_index).inventory_item_id);
1116: l_job_header_tbl(l_job_header_index).start_quantity := l_csd_recall_lines_tbl(l_index).quantity;
1117: l_job_header_tbl(l_job_header_index).routing_reference_id := g_routing_id(l_job_index);

Line 1114: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;

1110: l_job_header_tbl(l_job_header_index).creation_date := SYSDATE;
1111: l_job_header_tbl(l_job_header_index).last_update_date := SYSDATE;
1112: l_job_header_tbl(l_job_header_index).created_by := fnd_global.user_id;
1113: l_job_header_tbl(l_job_header_index).last_updated_by := fnd_global.user_id;
1114: l_job_header_tbl(l_job_header_index).last_update_login := fnd_global.login_id;
1115: l_job_header_tbl(l_job_header_index).primary_item_id := NVL(p_upgrade_item_id,l_csd_recall_lines_tbl(l_index).inventory_item_id);
1116: l_job_header_tbl(l_job_header_index).start_quantity := l_csd_recall_lines_tbl(l_index).quantity;
1117: l_job_header_tbl(l_job_header_index).routing_reference_id := g_routing_id(l_job_index);
1118: l_job_header_tbl(l_job_header_index).bom_reference_id := g_bill_id(l_job_index);

Line 1512: last_updated_by = fnd_global.user_id,

1508: -- customers un remediated. also update the WHO columns.
1509: FORALL i IN 1 ..l_metric_ids.COUNT
1510: UPDATE csd_recall_metrics SET customers_un_remediated = (customers_impacted-nvl(customers_remediated,0)),
1511: last_update_date = sysdate,
1512: last_updated_by = fnd_global.user_id,
1513: last_update_login = fnd_global.user_id,
1514: object_version_number = object_version_number+1
1515: WHERE metric_id = l_metric_ids(i);
1516:

Line 1513: last_update_login = fnd_global.user_id,

1509: FORALL i IN 1 ..l_metric_ids.COUNT
1510: UPDATE csd_recall_metrics SET customers_un_remediated = (customers_impacted-nvl(customers_remediated,0)),
1511: last_update_date = sysdate,
1512: last_updated_by = fnd_global.user_id,
1513: last_update_login = fnd_global.user_id,
1514: object_version_number = object_version_number+1
1515: WHERE metric_id = l_metric_ids(i);
1516:
1517: EXCEPTION