APPS.INL_TCAMERGE_GRP dependencies on INL_CHARGE_LINES

Line 61: FROM inl_charge_lines cl

57: AND ship_line_src_type_code = 'PO';
58:
59: CURSOR c_charge_lines IS
60: SELECT charge_line_id
61: FROM inl_charge_lines cl
62: WHERE (cl.party_id = p_from_party_id or cl.party_site_id = p_from_party_site_id)
63: AND ((cl.ship_from_party_id = p_from_id AND cl.ship_from_party_site_id = p_from_site_id)
64: OR (cl.bill_from_party_id = p_from_id AND cl.bill_from_party_site_id = p_from_site_id)
65: OR (cl.poa_party_id = p_from_id AND cl.poa_party_site_id = p_from_site_id));

Line 250: UPDATE inl_charge_lines

246:
247: IF l_charge_line_list.COUNT > 0 THEN
248: --
249: FORALL j IN l_charge_line_list.FIRST..l_charge_line_list.LAST
250: UPDATE inl_charge_lines
251: SET ship_from_party_id = decode(ship_from_party_id,p_from_id,p_to_id,ship_from_party_id),
252: ship_from_party_site_id = decode(nvl(ship_from_party_site_id,-1),-1,null,p_from_site_id,p_to_site_id,ship_from_party_site_id),
253: bill_from_party_id = decode(bill_from_party_id,p_from_id,p_to_id,bill_from_party_id),
254: bill_from_party_site_id = decode(nvl(bill_from_party_site_id,-1),-1,null,p_from_site_id,p_to_site_id,bill_from_party_site_id),

Line 602: FROM inl_charge_lines cl

598: ) IS
599:
600: CURSOR c_charge_lines IS
601: SELECT charge_line_id
602: FROM inl_charge_lines cl
603: WHERE cl.party_id = p_from_fk_id
604: AND cl.ship_from_party_id is null
605: AND cl.bill_from_party_id is null
606: AND cl.poa_party_id is null;

Line 674: UPDATE inl_charge_lines

670:
671: IF l_charge_line_list.COUNT > 0 THEN
672: --
673: FORALL j IN l_charge_line_list.FIRST..l_charge_line_list.LAST
674: UPDATE inl_charge_lines
675: SET party_id = p_to_fk_id,
676: last_update_date = sysdate,
677: last_updated_by = fnd_global.user_id,
678: last_update_login = fnd_global.login_id

Line 754: FROM inl_charge_lines cl

750: ) IS
751:
752: CURSOR c_charge_lines IS
753: SELECT charge_line_id
754: FROM inl_charge_lines cl
755: WHERE cl.party_site_id = p_from_fk_id
756: AND cl.ship_from_party_site_id is null
757: AND cl.bill_from_party_site_id is null
758: AND cl.poa_party_site_id is null;

Line 826: UPDATE inl_charge_lines

822:
823: IF l_charge_line_list.COUNT > 0 THEN
824: --
825: FORALL j IN l_charge_line_list.FIRST..l_charge_line_list.LAST
826: UPDATE inl_charge_lines
827: SET party_site_id = p_to_fk_id,
828: last_update_date = sysdate,
829: last_updated_by = fnd_global.user_id,
830: last_update_login = fnd_global.login_id