[Home] [Help]
437: l_prod_txn_tbl(i).ship_from_org,
438: l_prod_txn_tbl(i).rcv_into_ou,
439: l_prod_txn_tbl(i).rcv_into_org,
440: SYSDATE,
441: fnd_global.user_id,
442: SYSDATE,
443: fnd_global.login_id,
444: fnd_global.user_id,
445: 1
439: l_prod_txn_tbl(i).rcv_into_org,
440: SYSDATE,
441: fnd_global.user_id,
442: SYSDATE,
443: fnd_global.login_id,
444: fnd_global.user_id,
445: 1
446: )
447: RETURNING product_transaction_id BULK COLLECT INTO l_product_txn_ids;
440: SYSDATE,
441: fnd_global.user_id,
442: SYSDATE,
443: fnd_global.login_id,
444: fnd_global.user_id,
445: 1
446: )
447: RETURNING product_transaction_id BULK COLLECT INTO l_product_txn_ids;
448:
827: if NOT csd_repairs_pvt.is_flwsts_update_allowed
828: (p_repair_type_id => p_orig_ro_type_ids(j),
829: p_from_flow_status_id => p_from_ro_status(j) ,
830: p_to_flow_status_id => p_to_ro_status,
831: p_responsibility_id => FND_GLOBAL.RESP_ID)
832: then
833: -- flow status update is not allowed.
834: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_FLWSTS_NO_ACCESS');
835: Fnd_Msg_Pub.ADD;
899: if NOT csd_repairs_pvt.is_rt_update_allowed
900: (p_from_repair_type_id => p_orig_ro_type_ids(j),
901: p_to_repair_type_id => p_ro_type_id,
902: p_common_flow_status_id => p_from_ro_status(j),
903: p_responsibility_id => fnd_global.resp_id)
904: then
905: -- repair type update is not allowed. log a message.
906: Fnd_Message.Set_Name('CSD', 'CSD_FLEX_RT_TRANS_NO_ACCESS');
907: Fnd_Msg_Pub.ADD;
1225:
1226: x_rowid_tmp varchar2(100);
1227: x_document_id_tmp number;
1228:
1229: l_user_id number := fnd_global.user_id;
1230: x_media_id number;
1231: l_file_format varchar2(20);
1232: l_oracle_charset varchar2(30);
1233: l_seq_num number;
1403: null,
1404: null,
1405: null,
1406: 'Y',
1407: FND_GLOBAL.prog_appl_id,
1408: null,
1409: sysdate,
1410: null,
1411: null,