APPS.QP_PARTY_MERGE_PKG dependencies on QP_QUALIFIERS

Line 5: Procedure to Merge those qualifier_attr_value's in QP_QUALIFIERS which

1: PACKAGE BODY QP_PARTY_MERGE_PKG AS
2: /* $Header: QPXPMRGB.pls 120.1.12010000.2 2009/04/24 11:20:37 smbalara ship $ */
3:
4: /***********************************************************************
5: Procedure to Merge those qualifier_attr_value's in QP_QUALIFIERS which
6: reference Party_Id or Party_Site_Id. To be called by TCA when Parties
7: or Party Sites are merged.
8: ***********************************************************************/
9:

Line 79: FROM qp_qualifiers a

75: */
76: BEGIN
77: SELECT a.qualifier_id
78: INTO p_to_id
79: FROM qp_qualifiers a
80: WHERE a.qualifier_attr_value = to_char(p_to_fk_id)
81: AND trunc(l_temp_date) between nvl(trunc(start_date_active), trunc(l_temp_date)) and
82: nvl(trunc(end_date_active), trunc(l_temp_date))
83: AND (a.qualifier_context,

Line 94: FROM qp_qualifiers b

90: nvl(b.list_header_id, -1),
91: nvl(b.list_line_id, -1),
92: nvl(qualifier_rule_id, -1),
93: b.qualifier_grouping_no
94: FROM qp_qualifiers b
95: WHERE b.qualifier_id = p_from_id
96: AND b.qualifier_id <> a.qualifier_id)
97: AND rownum = 1;
98:

Line 106: UPDATE qp_qualifiers

102: END;
103:
104: IF p_to_id IS NULL THEN /* Duplicate Does Not Exist. Therefore Transfer*/
105:
106: UPDATE qp_qualifiers
107: SET qualifier_attr_value = to_char(p_to_fk_id),
108: last_update_date = hz_utility_pub.last_update_date,
109: last_updated_by = hz_utility_pub.user_id,
110: last_update_login = hz_utility_pub.last_update_login,

Line 127: /* UPDATE qp_qualifiers

123: the status of the entity as Merged. The
124: Merged_To Id is the duplicate found on the
125: new parent */
126: -- Start for bug 8399342 / 8210994 - deleting instead of end dating duplicate qualifiers
127: /* UPDATE qp_qualifiers
128: SET qualifier_attr_value = to_char(p_to_fk_id),
129: end_date_active = sysdate,
130: last_update_date = hz_utility_pub.last_update_date,
131: last_updated_by = hz_utility_pub.user_id,

Line 139: DELETE qp_qualifiers

135: program_id = hz_utility_pub.program_id,
136: program_update_date = sysdate
137: WHERE qualifier_id = p_from_id;
138: */
139: DELETE qp_qualifiers
140: WHERE qualifier_id = p_from_id;
141: -- End for bug 8399342 / 8210994 - deleting instead of end dating duplicate qualifiers
142: RETURN;
143: