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,
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,
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,
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
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,
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
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,
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,
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,
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
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;
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,
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,
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,
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
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;
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,
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,
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',
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,
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)
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,
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,
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,
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,
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,
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,