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 2005/06/13 02:39:35 appldev $ */
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 126: UPDATE qp_qualifiers

122: IF p_to_id IS NOT NULL THEN /* Duplicate Exists. Therefore Merge and set
123: the status of the entity as Merged. The
124: Merged_To Id is the duplicate found on the
125: new parent */
126: UPDATE qp_qualifiers
127: SET qualifier_attr_value = to_char(p_to_fk_id),
128: end_date_active = sysdate,
129: last_update_date = hz_utility_pub.last_update_date,
130: last_updated_by = hz_utility_pub.user_id,