79: AND RT.SHIPMENT_LINE_ID = RL.SHIPMENT_LINE_ID
80: AND RT.PO_HEADER_ID = PH.PO_HEADER_ID(+)
81: AND RT.OE_ORDER_HEADER_ID = OH.HEADER_ID(+);
82:
83: x_user_org_id := MO_GLOBAL.get_current_org_id;
84:
85: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
86: mo_global.set_policy_context(p_access_mode => 'S',
87: p_org_id => x_txn_org_id);
81: AND RT.OE_ORDER_HEADER_ID = OH.HEADER_ID(+);
82:
83: x_user_org_id := MO_GLOBAL.get_current_org_id;
84:
85: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
86: mo_global.set_policy_context(p_access_mode => 'S',
87: p_org_id => x_txn_org_id);
88: end if;
89:
82:
83: x_user_org_id := MO_GLOBAL.get_current_org_id;
84:
85: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
86: mo_global.set_policy_context(p_access_mode => 'S',
87: p_org_id => x_txn_org_id);
88: end if;
89:
90: x_user_id := fnd_global.user_id;
315: p_Comments ,
316: x_parent_interface_txn_id);
317: end if;
318:
319: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
320: mo_global.set_policy_context(p_access_mode => 'S',
321: p_org_id => x_user_org_id);
322: end if;
323:
316: x_parent_interface_txn_id);
317: end if;
318:
319: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
320: mo_global.set_policy_context(p_access_mode => 'S',
321: p_org_id => x_user_org_id);
322: end if;
323:
324: return 0;
324: return 0;
325:
326: exception
327: when others THEN
328: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
329: mo_global.set_policy_context(p_access_mode => 'S',
330: p_org_id => x_user_org_id);
331: end if;
332: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
325:
326: exception
327: when others THEN
328: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
329: mo_global.set_policy_context(p_access_mode => 'S',
330: p_org_id => x_user_org_id);
331: end if;
332: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
333: return 1;
769: select
770: rh.receipt_source_code,
771: x_interface_id,
772: p_group_id,
773: MO_GLOBAL.get_current_org_id,
774: SYSDATE,
775: fnd_global.user_id,
776: fnd_global.user_id,
777: SYSDATE,