DBA Data[Home] [Help]

APPS.WIP_FLOWUTIL_PRIV dependencies on FND_GLOBAL

Line 971: fnd_global.user_id,

967: decode(l_compTbl(l_count).wip_supply_type,
968: 6, -1*l_compTbl(l_count).operation_seq_num,
969: l_compTbl(l_count).operation_seq_num),
970: sysdate,
971: fnd_global.user_id,
972: sysdate,
973: fnd_global.user_id,
974: fnd_global.login_id,
975: fnd_global.conc_request_id,

Line 973: fnd_global.user_id,

969: l_compTbl(l_count).operation_seq_num),
970: sysdate,
971: fnd_global.user_id,
972: sysdate,
973: fnd_global.user_id,
974: fnd_global.login_id,
975: fnd_global.conc_request_id,
976: fnd_global.prog_appl_id,
977: fnd_global.conc_program_id,

Line 974: fnd_global.login_id,

970: sysdate,
971: fnd_global.user_id,
972: sysdate,
973: fnd_global.user_id,
974: fnd_global.login_id,
975: fnd_global.conc_request_id,
976: fnd_global.prog_appl_id,
977: fnd_global.conc_program_id,
978: sysdate,

Line 975: fnd_global.conc_request_id,

971: fnd_global.user_id,
972: sysdate,
973: fnd_global.user_id,
974: fnd_global.login_id,
975: fnd_global.conc_request_id,
976: fnd_global.prog_appl_id,
977: fnd_global.conc_program_id,
978: sysdate,
979: 1, -- process flag

Line 976: fnd_global.prog_appl_id,

972: sysdate,
973: fnd_global.user_id,
974: fnd_global.login_id,
975: fnd_global.conc_request_id,
976: fnd_global.prog_appl_id,
977: fnd_global.conc_program_id,
978: sysdate,
979: 1, -- process flag
980: p_lockFlag,

Line 977: fnd_global.conc_program_id,

973: fnd_global.user_id,
974: fnd_global.login_id,
975: fnd_global.conc_request_id,
976: fnd_global.prog_appl_id,
977: fnd_global.conc_program_id,
978: sysdate,
979: 1, -- process flag
980: p_lockFlag,
981: 1, -- validation required

Line 1767: last_updated_by = fnd_global.user_id,

1763: -- set the transaction_source_id for the assembly record (if from MTI)
1764: --and its components
1765: update mtl_transactions_interface
1766: set last_update_date = sysdate,
1767: last_updated_by = fnd_global.user_id,
1768: last_update_login = fnd_global.login_id,
1769: program_application_id = fnd_global.prog_appl_id,
1770: program_id = fnd_global.conc_program_id,
1771: program_update_date = sysdate,

Line 1768: last_update_login = fnd_global.login_id,

1764: --and its components
1765: update mtl_transactions_interface
1766: set last_update_date = sysdate,
1767: last_updated_by = fnd_global.user_id,
1768: last_update_login = fnd_global.login_id,
1769: program_application_id = fnd_global.prog_appl_id,
1770: program_id = fnd_global.conc_program_id,
1771: program_update_date = sysdate,
1772: request_id = fnd_global.conc_request_id,

Line 1769: program_application_id = fnd_global.prog_appl_id,

1765: update mtl_transactions_interface
1766: set last_update_date = sysdate,
1767: last_updated_by = fnd_global.user_id,
1768: last_update_login = fnd_global.login_id,
1769: program_application_id = fnd_global.prog_appl_id,
1770: program_id = fnd_global.conc_program_id,
1771: program_update_date = sysdate,
1772: request_id = fnd_global.conc_request_id,
1773: transaction_source_id = l_wipEntityID,

Line 1770: program_id = fnd_global.conc_program_id,

1766: set last_update_date = sysdate,
1767: last_updated_by = fnd_global.user_id,
1768: last_update_login = fnd_global.login_id,
1769: program_application_id = fnd_global.prog_appl_id,
1770: program_id = fnd_global.conc_program_id,
1771: program_update_date = sysdate,
1772: request_id = fnd_global.conc_request_id,
1773: transaction_source_id = l_wipEntityID,
1774: wip_entity_type = l_flowRec.wip_entity_type

Line 1772: request_id = fnd_global.conc_request_id,

1768: last_update_login = fnd_global.login_id,
1769: program_application_id = fnd_global.prog_appl_id,
1770: program_id = fnd_global.conc_program_id,
1771: program_update_date = sysdate,
1772: request_id = fnd_global.conc_request_id,
1773: transaction_source_id = l_wipEntityID,
1774: wip_entity_type = l_flowRec.wip_entity_type
1775: where transaction_header_id = l_flowRec.transaction_header_id
1776: and completion_transaction_id = l_flowRec.completion_transaction_id;

Line 1787: last_updated_by = fnd_global.user_id,

1783: --if txn originated from MMTT, update the assy record
1784: if(p_txnTmpID is not null) then
1785: update mtl_material_transactions_temp
1786: set last_update_date = sysdate,
1787: last_updated_by = fnd_global.user_id,
1788: last_update_login = fnd_global.login_id,
1789: program_application_id = fnd_global.prog_appl_id,
1790: program_id = fnd_global.conc_program_id,
1791: program_update_date = sysdate,

Line 1788: last_update_login = fnd_global.login_id,

1784: if(p_txnTmpID is not null) then
1785: update mtl_material_transactions_temp
1786: set last_update_date = sysdate,
1787: last_updated_by = fnd_global.user_id,
1788: last_update_login = fnd_global.login_id,
1789: program_application_id = fnd_global.prog_appl_id,
1790: program_id = fnd_global.conc_program_id,
1791: program_update_date = sysdate,
1792: request_id = fnd_global.conc_request_id,

Line 1789: program_application_id = fnd_global.prog_appl_id,

1785: update mtl_material_transactions_temp
1786: set last_update_date = sysdate,
1787: last_updated_by = fnd_global.user_id,
1788: last_update_login = fnd_global.login_id,
1789: program_application_id = fnd_global.prog_appl_id,
1790: program_id = fnd_global.conc_program_id,
1791: program_update_date = sysdate,
1792: request_id = fnd_global.conc_request_id,
1793: transaction_source_id = l_wipEntityID,

Line 1790: program_id = fnd_global.conc_program_id,

1786: set last_update_date = sysdate,
1787: last_updated_by = fnd_global.user_id,
1788: last_update_login = fnd_global.login_id,
1789: program_application_id = fnd_global.prog_appl_id,
1790: program_id = fnd_global.conc_program_id,
1791: program_update_date = sysdate,
1792: request_id = fnd_global.conc_request_id,
1793: transaction_source_id = l_wipEntityID,
1794: wip_entity_type = l_flowRec.wip_entity_type

Line 1792: request_id = fnd_global.conc_request_id,

1788: last_update_login = fnd_global.login_id,
1789: program_application_id = fnd_global.prog_appl_id,
1790: program_id = fnd_global.conc_program_id,
1791: program_update_date = sysdate,
1792: request_id = fnd_global.conc_request_id,
1793: transaction_source_id = l_wipEntityID,
1794: wip_entity_type = l_flowRec.wip_entity_type
1795: where transaction_temp_id = p_txnTmpID;
1796: end if;

Line 1924: last_updated_by = FND_GLOBAL.user_id,--bugfix 7379879

1920: decode(l_statusChange, 0, status,
1921: 1, 1,
1922: 2, 2),
1923: status),
1924: last_updated_by = FND_GLOBAL.user_id,--bugfix 7379879
1925: last_update_date = sysdate
1926: where wip_entity_id = l_wipEntityID;
1927:
1928: if (l_logLevel <= wip_constants.trace_logging) then

Line 1957: last_updated_by = fnd_global.user_id,

1953: p_msgData in varchar2) is
1954: begin
1955: update mtl_material_transactions_temp
1956: set last_update_date = sysdate,
1957: last_updated_by = fnd_global.user_id,
1958: last_update_login = fnd_global.login_id,
1959: program_application_id = fnd_global.prog_appl_id,
1960: program_id = fnd_global.conc_program_id,
1961: program_update_date = sysdate,

Line 1958: last_update_login = fnd_global.login_id,

1954: begin
1955: update mtl_material_transactions_temp
1956: set last_update_date = sysdate,
1957: last_updated_by = fnd_global.user_id,
1958: last_update_login = fnd_global.login_id,
1959: program_application_id = fnd_global.prog_appl_id,
1960: program_id = fnd_global.conc_program_id,
1961: program_update_date = sysdate,
1962: request_id = fnd_global.conc_request_id,

Line 1959: program_application_id = fnd_global.prog_appl_id,

1955: update mtl_material_transactions_temp
1956: set last_update_date = sysdate,
1957: last_updated_by = fnd_global.user_id,
1958: last_update_login = fnd_global.login_id,
1959: program_application_id = fnd_global.prog_appl_id,
1960: program_id = fnd_global.conc_program_id,
1961: program_update_date = sysdate,
1962: request_id = fnd_global.conc_request_id,
1963: process_flag = 'E',

Line 1960: program_id = fnd_global.conc_program_id,

1956: set last_update_date = sysdate,
1957: last_updated_by = fnd_global.user_id,
1958: last_update_login = fnd_global.login_id,
1959: program_application_id = fnd_global.prog_appl_id,
1960: program_id = fnd_global.conc_program_id,
1961: program_update_date = sysdate,
1962: request_id = fnd_global.conc_request_id,
1963: process_flag = 'E',
1964: lock_flag = 2,

Line 1962: request_id = fnd_global.conc_request_id,

1958: last_update_login = fnd_global.login_id,
1959: program_application_id = fnd_global.prog_appl_id,
1960: program_id = fnd_global.conc_program_id,
1961: program_update_date = sysdate,
1962: request_id = fnd_global.conc_request_id,
1963: process_flag = 'E',
1964: lock_flag = 2,
1965: error_code = substrb(p_msgData, 1, 240),
1966: error_explanation = substrb(p_msgData, 1, 240)

Line 2432: fnd_global.user_id,

2428: flow_schedule
2429: )
2430: select
2431: sysdate,
2432: fnd_global.user_id,
2433: sysdate,
2434: fnd_global.user_id,
2435: fnd_global.login_id,
2436: fnd_global.conc_request_id,

Line 2434: fnd_global.user_id,

2430: select
2431: sysdate,
2432: fnd_global.user_id,
2433: sysdate,
2434: fnd_global.user_id,
2435: fnd_global.login_id,
2436: fnd_global.conc_request_id,
2437: fnd_global.prog_appl_id,
2438: fnd_global.conc_program_id,

Line 2435: fnd_global.login_id,

2431: sysdate,
2432: fnd_global.user_id,
2433: sysdate,
2434: fnd_global.user_id,
2435: fnd_global.login_id,
2436: fnd_global.conc_request_id,
2437: fnd_global.prog_appl_id,
2438: fnd_global.conc_program_id,
2439: sysdate,

Line 2436: fnd_global.conc_request_id,

2432: fnd_global.user_id,
2433: sysdate,
2434: fnd_global.user_id,
2435: fnd_global.login_id,
2436: fnd_global.conc_request_id,
2437: fnd_global.prog_appl_id,
2438: fnd_global.conc_program_id,
2439: sysdate,
2440: mmtt.transaction_header_id,

Line 2437: fnd_global.prog_appl_id,

2433: sysdate,
2434: fnd_global.user_id,
2435: fnd_global.login_id,
2436: fnd_global.conc_request_id,
2437: fnd_global.prog_appl_id,
2438: fnd_global.conc_program_id,
2439: sysdate,
2440: mmtt.transaction_header_id,
2441: mtl_material_transactions_s.nextval,

Line 2438: fnd_global.conc_program_id,

2434: fnd_global.user_id,
2435: fnd_global.login_id,
2436: fnd_global.conc_request_id,
2437: fnd_global.prog_appl_id,
2438: fnd_global.conc_program_id,
2439: sysdate,
2440: mmtt.transaction_header_id,
2441: mtl_material_transactions_s.nextval,
2442: mmtt.transaction_mode,