DBA Data[Home] [Help]

APPS.QA_SKIPLOT_UTILITY dependencies on FND_GLOBAL

Line 544: fnd_global.user_id,

540: decode(p_lot_id, null, null, sysdate),
541: nvl(p_lot_id,last_receipt_lot),
542: nvl(last_date,sysdate),
543: sysdate,
544: fnd_global.user_id,
545: sysdate,
546: fnd_global.user_id,
547: fnd_global.login_id);
548:

Line 546: fnd_global.user_id,

542: nvl(last_date,sysdate),
543: sysdate,
544: fnd_global.user_id,
545: sysdate,
546: fnd_global.user_id,
547: fnd_global.login_id);
548:
549: update_state_history (
550: p_process_plan_id => p_process_plan_id,

Line 547: fnd_global.login_id);

543: sysdate,
544: fnd_global.user_id,
545: sysdate,
546: fnd_global.user_id,
547: fnd_global.login_id);
548:
549: update_state_history (
550: p_process_plan_id => p_process_plan_id,
551: p_criteria_id => p_criteria_id,

Line 609: last_updated_by = fnd_global.user_id,

605: BEGIN
606: UPDATE qa_skiplot_plan_states
607: SET last_receipt_date = SYSDATE,
608: last_update_date = SYSDATE,
609: last_updated_by = fnd_global.user_id,
610: last_update_login = fnd_global.login_id
611: WHERE process_plan_id = p_process_plan_id AND
612: criteria_id = p_criteria_id;
613: END RESET_LAST_RECEIPT_DATE;

Line 610: last_update_login = fnd_global.login_id

606: UPDATE qa_skiplot_plan_states
607: SET last_receipt_date = SYSDATE,
608: last_update_date = SYSDATE,
609: last_updated_by = fnd_global.user_id,
610: last_update_login = fnd_global.login_id
611: WHERE process_plan_id = p_process_plan_id AND
612: criteria_id = p_criteria_id;
613: END RESET_LAST_RECEIPT_DATE;
614:

Line 867: last_updated_by = fnd_global.user_id,

863: last_receipt_date = decode(p_last_receipt_lot_id, null, last_receipt_date, sysdate),
864: rule_start_lot_id = nvl(p_rule_start_lotid, rule_start_lot_id),
865: rule_start_date = x_rule_start_date,
866: last_update_date = sysdate,
867: last_updated_by = fnd_global.user_id,
868: last_update_login = fnd_global.login_id
869: where process_plan_id = p_process_plan_id and
870: criteria_id = p_criteria_id;
871:

Line 868: last_update_login = fnd_global.login_id

864: rule_start_lot_id = nvl(p_rule_start_lotid, rule_start_lot_id),
865: rule_start_date = x_rule_start_date,
866: last_update_date = sysdate,
867: last_updated_by = fnd_global.user_id,
868: last_update_login = fnd_global.login_id
869: where process_plan_id = p_process_plan_id and
870: criteria_id = p_criteria_id;
871:
872: if p_next_rule is not null then

Line 1229: fnd_global.user_id,

1225: p_old_freq_denom,
1226: p_new_freq_num,
1227: p_new_freq_denom,
1228: sysdate,
1229: fnd_global.user_id,
1230: sysdate,
1231: fnd_global.user_id,
1232: fnd_global.login_id);
1233:

Line 1231: fnd_global.user_id,

1227: p_new_freq_denom,
1228: sysdate,
1229: fnd_global.user_id,
1230: sysdate,
1231: fnd_global.user_id,
1232: fnd_global.login_id);
1233:
1234: launch_workflow (
1235: p_process_plan_id => p_process_plan_id,

Line 1232: fnd_global.login_id);

1228: sysdate,
1229: fnd_global.user_id,
1230: sysdate,
1231: fnd_global.user_id,
1232: fnd_global.login_id);
1233:
1234: launch_workflow (
1235: p_process_plan_id => p_process_plan_id,
1236: p_criteria_id => p_criteria_id,

Line 1301: fnd_global.user_id,

1297: p_module_name,
1298: p_error_message,
1299: p_comments,
1300: sysdate,
1301: fnd_global.user_id,
1302: sysdate,
1303: fnd_global.user_id,
1304: fnd_global.login_id);
1305: else

Line 1303: fnd_global.user_id,

1299: p_comments,
1300: sysdate,
1301: fnd_global.user_id,
1302: sysdate,
1303: fnd_global.user_id,
1304: fnd_global.login_id);
1305: else
1306: update qa_skiplot_log
1307: set MODULE_NAME = p_module_name,

Line 1304: fnd_global.login_id);

1300: sysdate,
1301: fnd_global.user_id,
1302: sysdate,
1303: fnd_global.user_id,
1304: fnd_global.login_id);
1305: else
1306: update qa_skiplot_log
1307: set MODULE_NAME = p_module_name,
1308: ERROR_MESSAGE = p_error_message,

Line 1311: LAST_UPDATED_BY = fnd_global.user_id,

1307: set MODULE_NAME = p_module_name,
1308: ERROR_MESSAGE = p_error_message,
1309: COMMENTS = p_comments,
1310: LAST_UPDATE_DATE = sysdate,
1311: LAST_UPDATED_BY = fnd_global.user_id,
1312: CREATION_DATE = sysdate,
1313: CREATED_BY = fnd_global.user_id,
1314: LAST_UPDATE_LOGIN = fnd_global.login_id
1315: where LOG_ID = x_logid;

Line 1313: CREATED_BY = fnd_global.user_id,

1309: COMMENTS = p_comments,
1310: LAST_UPDATE_DATE = sysdate,
1311: LAST_UPDATED_BY = fnd_global.user_id,
1312: CREATION_DATE = sysdate,
1313: CREATED_BY = fnd_global.user_id,
1314: LAST_UPDATE_LOGIN = fnd_global.login_id
1315: where LOG_ID = x_logid;
1316: end if;
1317:

Line 1314: LAST_UPDATE_LOGIN = fnd_global.login_id

1310: LAST_UPDATE_DATE = sysdate,
1311: LAST_UPDATED_BY = fnd_global.user_id,
1312: CREATION_DATE = sysdate,
1313: CREATED_BY = fnd_global.user_id,
1314: LAST_UPDATE_LOGIN = fnd_global.login_id
1315: where LOG_ID = x_logid;
1316: end if;
1317:
1318: COMMIT;