DBA Data[Home] [Help]

APPS.WIP_FLOWUTIL_PRIV dependencies on FND_GLOBAL

Line 940: fnd_global.user_id,

936: decode(l_compTbl(l_count).wip_supply_type,
937: 6, -1*l_compTbl(l_count).operation_seq_num,
938: l_compTbl(l_count).operation_seq_num),
939: sysdate,
940: fnd_global.user_id,
941: sysdate,
942: fnd_global.user_id,
943: fnd_global.login_id,
944: fnd_global.conc_request_id,

Line 942: fnd_global.user_id,

938: l_compTbl(l_count).operation_seq_num),
939: sysdate,
940: fnd_global.user_id,
941: sysdate,
942: fnd_global.user_id,
943: fnd_global.login_id,
944: fnd_global.conc_request_id,
945: fnd_global.prog_appl_id,
946: fnd_global.conc_program_id,

Line 943: fnd_global.login_id,

939: sysdate,
940: fnd_global.user_id,
941: sysdate,
942: fnd_global.user_id,
943: fnd_global.login_id,
944: fnd_global.conc_request_id,
945: fnd_global.prog_appl_id,
946: fnd_global.conc_program_id,
947: sysdate,

Line 944: fnd_global.conc_request_id,

940: fnd_global.user_id,
941: sysdate,
942: fnd_global.user_id,
943: fnd_global.login_id,
944: fnd_global.conc_request_id,
945: fnd_global.prog_appl_id,
946: fnd_global.conc_program_id,
947: sysdate,
948: 1, -- process flag

Line 945: fnd_global.prog_appl_id,

941: sysdate,
942: fnd_global.user_id,
943: fnd_global.login_id,
944: fnd_global.conc_request_id,
945: fnd_global.prog_appl_id,
946: fnd_global.conc_program_id,
947: sysdate,
948: 1, -- process flag
949: p_lockFlag,

Line 946: fnd_global.conc_program_id,

942: fnd_global.user_id,
943: fnd_global.login_id,
944: fnd_global.conc_request_id,
945: fnd_global.prog_appl_id,
946: fnd_global.conc_program_id,
947: sysdate,
948: 1, -- process flag
949: p_lockFlag,
950: 1, -- validation required

Line 1736: last_updated_by = fnd_global.user_id,

1732: -- set the transaction_source_id for the assembly record (if from MTI)
1733: --and its components
1734: update mtl_transactions_interface
1735: set last_update_date = sysdate,
1736: last_updated_by = fnd_global.user_id,
1737: last_update_login = fnd_global.login_id,
1738: program_application_id = fnd_global.prog_appl_id,
1739: program_id = fnd_global.conc_program_id,
1740: program_update_date = sysdate,

Line 1737: last_update_login = fnd_global.login_id,

1733: --and its components
1734: update mtl_transactions_interface
1735: set last_update_date = sysdate,
1736: last_updated_by = fnd_global.user_id,
1737: last_update_login = fnd_global.login_id,
1738: program_application_id = fnd_global.prog_appl_id,
1739: program_id = fnd_global.conc_program_id,
1740: program_update_date = sysdate,
1741: request_id = fnd_global.conc_request_id,

Line 1738: program_application_id = fnd_global.prog_appl_id,

1734: update mtl_transactions_interface
1735: set last_update_date = sysdate,
1736: last_updated_by = fnd_global.user_id,
1737: last_update_login = fnd_global.login_id,
1738: program_application_id = fnd_global.prog_appl_id,
1739: program_id = fnd_global.conc_program_id,
1740: program_update_date = sysdate,
1741: request_id = fnd_global.conc_request_id,
1742: transaction_source_id = l_wipEntityID,

Line 1739: program_id = fnd_global.conc_program_id,

1735: set last_update_date = sysdate,
1736: last_updated_by = fnd_global.user_id,
1737: last_update_login = fnd_global.login_id,
1738: program_application_id = fnd_global.prog_appl_id,
1739: program_id = fnd_global.conc_program_id,
1740: program_update_date = sysdate,
1741: request_id = fnd_global.conc_request_id,
1742: transaction_source_id = l_wipEntityID,
1743: wip_entity_type = l_flowRec.wip_entity_type

Line 1741: request_id = fnd_global.conc_request_id,

1737: last_update_login = fnd_global.login_id,
1738: program_application_id = fnd_global.prog_appl_id,
1739: program_id = fnd_global.conc_program_id,
1740: program_update_date = sysdate,
1741: request_id = fnd_global.conc_request_id,
1742: transaction_source_id = l_wipEntityID,
1743: wip_entity_type = l_flowRec.wip_entity_type
1744: where transaction_header_id = l_flowRec.transaction_header_id
1745: and completion_transaction_id = l_flowRec.completion_transaction_id;

Line 1756: last_updated_by = fnd_global.user_id,

1752: --if txn originated from MMTT, update the assy record
1753: if(p_txnTmpID is not null) then
1754: update mtl_material_transactions_temp
1755: set last_update_date = sysdate,
1756: last_updated_by = fnd_global.user_id,
1757: last_update_login = fnd_global.login_id,
1758: program_application_id = fnd_global.prog_appl_id,
1759: program_id = fnd_global.conc_program_id,
1760: program_update_date = sysdate,

Line 1757: last_update_login = fnd_global.login_id,

1753: if(p_txnTmpID is not null) then
1754: update mtl_material_transactions_temp
1755: set last_update_date = sysdate,
1756: last_updated_by = fnd_global.user_id,
1757: last_update_login = fnd_global.login_id,
1758: program_application_id = fnd_global.prog_appl_id,
1759: program_id = fnd_global.conc_program_id,
1760: program_update_date = sysdate,
1761: request_id = fnd_global.conc_request_id,

Line 1758: program_application_id = fnd_global.prog_appl_id,

1754: update mtl_material_transactions_temp
1755: set last_update_date = sysdate,
1756: last_updated_by = fnd_global.user_id,
1757: last_update_login = fnd_global.login_id,
1758: program_application_id = fnd_global.prog_appl_id,
1759: program_id = fnd_global.conc_program_id,
1760: program_update_date = sysdate,
1761: request_id = fnd_global.conc_request_id,
1762: transaction_source_id = l_wipEntityID,

Line 1759: program_id = fnd_global.conc_program_id,

1755: set last_update_date = sysdate,
1756: last_updated_by = fnd_global.user_id,
1757: last_update_login = fnd_global.login_id,
1758: program_application_id = fnd_global.prog_appl_id,
1759: program_id = fnd_global.conc_program_id,
1760: program_update_date = sysdate,
1761: request_id = fnd_global.conc_request_id,
1762: transaction_source_id = l_wipEntityID,
1763: wip_entity_type = l_flowRec.wip_entity_type

Line 1761: request_id = fnd_global.conc_request_id,

1757: last_update_login = fnd_global.login_id,
1758: program_application_id = fnd_global.prog_appl_id,
1759: program_id = fnd_global.conc_program_id,
1760: program_update_date = sysdate,
1761: request_id = fnd_global.conc_request_id,
1762: transaction_source_id = l_wipEntityID,
1763: wip_entity_type = l_flowRec.wip_entity_type
1764: where transaction_temp_id = p_txnTmpID;
1765: end if;

Line 1924: last_updated_by = fnd_global.user_id,

1920: p_msgData in varchar2) is
1921: begin
1922: update mtl_material_transactions_temp
1923: set last_update_date = sysdate,
1924: last_updated_by = fnd_global.user_id,
1925: last_update_login = fnd_global.login_id,
1926: program_application_id = fnd_global.prog_appl_id,
1927: program_id = fnd_global.conc_program_id,
1928: program_update_date = sysdate,

Line 1925: last_update_login = fnd_global.login_id,

1921: begin
1922: update mtl_material_transactions_temp
1923: set last_update_date = sysdate,
1924: last_updated_by = fnd_global.user_id,
1925: last_update_login = fnd_global.login_id,
1926: program_application_id = fnd_global.prog_appl_id,
1927: program_id = fnd_global.conc_program_id,
1928: program_update_date = sysdate,
1929: request_id = fnd_global.conc_request_id,

Line 1926: program_application_id = fnd_global.prog_appl_id,

1922: update mtl_material_transactions_temp
1923: set last_update_date = sysdate,
1924: last_updated_by = fnd_global.user_id,
1925: last_update_login = fnd_global.login_id,
1926: program_application_id = fnd_global.prog_appl_id,
1927: program_id = fnd_global.conc_program_id,
1928: program_update_date = sysdate,
1929: request_id = fnd_global.conc_request_id,
1930: process_flag = 'E',

Line 1927: program_id = fnd_global.conc_program_id,

1923: set last_update_date = sysdate,
1924: last_updated_by = fnd_global.user_id,
1925: last_update_login = fnd_global.login_id,
1926: program_application_id = fnd_global.prog_appl_id,
1927: program_id = fnd_global.conc_program_id,
1928: program_update_date = sysdate,
1929: request_id = fnd_global.conc_request_id,
1930: process_flag = 'E',
1931: lock_flag = 2,

Line 1929: request_id = fnd_global.conc_request_id,

1925: last_update_login = fnd_global.login_id,
1926: program_application_id = fnd_global.prog_appl_id,
1927: program_id = fnd_global.conc_program_id,
1928: program_update_date = sysdate,
1929: request_id = fnd_global.conc_request_id,
1930: process_flag = 'E',
1931: lock_flag = 2,
1932: error_code = substrb(p_msgData, 1, 240),
1933: error_explanation = substrb(p_msgData, 1, 240)

Line 2393: fnd_global.user_id,

2389: flow_schedule
2390: )
2391: select
2392: sysdate,
2393: fnd_global.user_id,
2394: sysdate,
2395: fnd_global.user_id,
2396: fnd_global.login_id,
2397: fnd_global.conc_request_id,

Line 2395: fnd_global.user_id,

2391: select
2392: sysdate,
2393: fnd_global.user_id,
2394: sysdate,
2395: fnd_global.user_id,
2396: fnd_global.login_id,
2397: fnd_global.conc_request_id,
2398: fnd_global.prog_appl_id,
2399: fnd_global.conc_program_id,

Line 2396: fnd_global.login_id,

2392: sysdate,
2393: fnd_global.user_id,
2394: sysdate,
2395: fnd_global.user_id,
2396: fnd_global.login_id,
2397: fnd_global.conc_request_id,
2398: fnd_global.prog_appl_id,
2399: fnd_global.conc_program_id,
2400: sysdate,

Line 2397: fnd_global.conc_request_id,

2393: fnd_global.user_id,
2394: sysdate,
2395: fnd_global.user_id,
2396: fnd_global.login_id,
2397: fnd_global.conc_request_id,
2398: fnd_global.prog_appl_id,
2399: fnd_global.conc_program_id,
2400: sysdate,
2401: mmtt.transaction_header_id,

Line 2398: fnd_global.prog_appl_id,

2394: sysdate,
2395: fnd_global.user_id,
2396: fnd_global.login_id,
2397: fnd_global.conc_request_id,
2398: fnd_global.prog_appl_id,
2399: fnd_global.conc_program_id,
2400: sysdate,
2401: mmtt.transaction_header_id,
2402: mtl_material_transactions_s.nextval,

Line 2399: fnd_global.conc_program_id,

2395: fnd_global.user_id,
2396: fnd_global.login_id,
2397: fnd_global.conc_request_id,
2398: fnd_global.prog_appl_id,
2399: fnd_global.conc_program_id,
2400: sysdate,
2401: mmtt.transaction_header_id,
2402: mtl_material_transactions_s.nextval,
2403: mmtt.transaction_mode,