APPS.OE_PRICE_LIST_UTIL dependencies on QP_QUALIFIERS

Line 949: delete from qp_qualifiers

945: p_Price_List_rec.price_list_id);
946:
947: IF l_sec_price_list_id is not null THEN
948:
949: delete from qp_qualifiers
950: where qualifier_context = l_context
951: and qualifier_attribute = l_attribute
952: and qualifier_attr_value = p_PRICE_LIST_rec.price_list_id
953: and list_header_id = l_sec_price_list_id

Line 958: INSERT INTO QP_QUALIFIERS (

954: and qualifier_rule_id is null;
955:
956: /* create a new qualifier for the new secondary price list id */
957:
958: INSERT INTO QP_QUALIFIERS (
959: QUALIFIER_ID,
960: CREATION_DATE,
961: CREATED_BY,
962: LAST_UPDATE_DATE,

Line 977: QP_QUALIFIERS_S.nextval,

973: ,ORIG_SYS_QUALIFIER_REF
974: ,ORIG_SYS_HEADER_REF
975: )
976: VALUES (
977: QP_QUALIFIERS_S.nextval,
978: sysdate,
979: 1,
980: sysdate,
981: 1,

Line 991: ,to_char(QP_QUALIFIERS_S.CURRVAL)

987: to_char(p_PRICE_LIST_rec.price_list_id),
988: qp.qp_qualifier_group_no_s.nextval,
989: 'N'
990: --ENH Upgrade BOAPI for orig_sys...ref RAVI
991: ,to_char(QP_QUALIFIERS_S.CURRVAL)
992: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.secondary_price_list_id)
993: );
994:
995: END IF;

Line 1078: INSERT INTO QP_QUALIFIERS (

1074:
1075: QP_UTIL.Get_Context_Attribute('PRICE_LIST_ID', l_context, l_attribute);
1076:
1077:
1078: INSERT INTO QP_QUALIFIERS (
1079: QUALIFIER_ID,
1080: CREATION_DATE,
1081: CREATED_BY,
1082: LAST_UPDATE_DATE,

Line 1096: QP_QUALIFIERS_S.nextval,

1092: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1093: ,ORIG_SYS_QUALIFIER_REF
1094: ,ORIG_SYS_HEADER_REF)
1095: VALUES (
1096: QP_QUALIFIERS_S.nextval,
1097: sysdate,
1098: 1,
1099: sysdate,
1100: 1,

Line 1110: ,to_char(QP_QUALIFIERS_S.CURRVAL)

1106: to_char(p_PRICE_LIST_rec.price_list_id),
1107: qp_qualifier_group_no_s.nextval,
1108: 'N'
1109: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1110: ,to_char(QP_QUALIFIERS_S.CURRVAL)
1111: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.price_list_id)
1112: );
1113:
1114: /* create qualifier for secondary price list */

Line 1118: INSERT INTO QP_QUALIFIERS (

1114: /* create qualifier for secondary price list */
1115:
1116: IF p_PRICE_LIST_rec.secondary_price_list_id is not null THEN
1117:
1118: INSERT INTO QP_QUALIFIERS (
1119: QUALIFIER_ID,
1120: CREATION_DATE,
1121: CREATED_BY,
1122: LAST_UPDATE_DATE,

Line 1137: QP_QUALIFIERS_S.nextval,

1133: ,ORIG_SYS_QUALIFIER_REF
1134: ,ORIG_SYS_HEADER_REF
1135: )
1136: VALUES (
1137: QP_QUALIFIERS_S.nextval,
1138: sysdate,
1139: 1,
1140: sysdate,
1141: 1,

Line 1151: ,to_char(QP_QUALIFIERS_S.CURRVAL)

1147: to_char(p_PRICE_LIST_rec.price_list_id),
1148: qp_qualifier_group_no_s.nextval,
1149: 'N'
1150: --ENH Upgrade BOAPI for orig_sys...ref RAVI
1151: ,to_char(QP_QUALIFIERS_S.CURRVAL)
1152: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_PRICE_LIST_rec.secondary_price_list_id)
1153: );
1154: END IF;
1155:

Line 1344: delete from qp_qualifiers

1340: QP_LIST_HEADERS_PKG.Delete_Row(p_price_list_id);
1341:
1342: IF l_sec_price_list_id is not null THEN
1343:
1344: delete from qp_qualifiers
1345: where qualifier_context = l_context
1346: and qualifier_attribute = l_attribute
1347: and qualifier_attr_value = p_price_list_id
1348: and list_header_id = l_sec_price_list_id