DBA Data[Home] [Help]

APPS.QP_LIST_HEADERS_PVT dependencies on QP_QUALIFIERS

Line 883: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);

879:
880: -- Set missing old record elements to NULL.
881:
882: l_old_QUALIFIERS_rec :=
883: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
884:
885: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
886: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE
887: THEN

Line 896: l_old_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row

892:
893: IF l_old_QUALIFIERS_rec.qualifier_id = FND_API.G_MISS_NUM
894: THEN
895:
896: l_old_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row
897: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
898: );
899:
900: ELSE

Line 905: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);

901:
902: -- Set missing old record elements to NULL.
903:
904: l_old_QUALIFIERS_rec :=
905: QP_Qualifiers_Util.Convert_Miss_To_Null (l_old_QUALIFIERS_rec);
906:
907: END IF;
908:
909: -- Complete new record from old

Line 911: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record

907: END IF;
908:
909: -- Complete new record from old
910:
911: l_QUALIFIERS_rec := QP_Qualifiers_Util.Complete_Record
912: ( p_QUALIFIERS_rec => l_QUALIFIERS_rec
913: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
914: );
915:

Line 921: FROM qp_list_headers_b h, qp_qualifiers q

917: BEGIN
918: SELECT h.pte_code, h.source_system_code, h.list_type_code
919: INTO l_saved_pte_code, l_saved_source_system_code,
920: l_list_type_code
921: FROM qp_list_headers_b h, qp_qualifiers q
922: WHERE h.list_header_id = q.list_header_id
923: AND q.qualifier_id = l_QUALIFIERS_rec.qualifier_id;
924:
925: EXCEPTION

Line 979: QP_Qualifiers_Util.Clear_Dependent_Attr

975: -- Clear dependent attributes.
976:
977: IF l_control_rec.change_attributes THEN
978: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
979: QP_Qualifiers_Util.Clear_Dependent_Attr
980: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
981: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
982: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
983: );

Line 1040: QP_Qualifiers_Util.Apply_Attribute_Changes

1036: IF l_control_rec.default_attributes
1037: OR l_control_rec.change_attributes
1038: THEN
1039: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
1040: QP_Qualifiers_Util.Apply_Attribute_Changes
1041: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
1042: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1043: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
1044: );

Line 1101: QP_QUALIFIERS WHERE

1097: oe_debug_pub.add('in modifier qual test'||l_list_type_code);
1098: BEGIN
1099:
1100: SELECT COUNT(*) INTO v_count FROM
1101: QP_QUALIFIERS WHERE
1102: LIST_HEADER_ID = l_QUALIFIERS_rec.list_header_id
1103: AND QUALIFIER_CONTEXT = 'MODLIST'
1104: AND QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4';
1105:

Line 1157: QP_QUALIFIERS_UTIL.PRE_WRITE_PROCESS

1153: END IF;
1154:
1155: IF l_control_rec.write_to_db THEN
1156: l_p_QUALIFIERS_rec := l_QUALIFIERS_rec;
1157: QP_QUALIFIERS_UTIL.PRE_WRITE_PROCESS
1158: ( p_QUALIFIERS_rec => l_p_QUALIFIERS_rec
1159: , p_old_QUALIFIERS_rec => l_old_QUALIFIERS_rec
1160: , x_QUALIFIERS_rec => l_QUALIFIERS_rec);
1161:

Line 1181: QP_Qualifiers_Util.Delete_Row

1177: OE_MSG_PUB.ADD;
1178: RAISE FND_API.G_EXC_ERROR;
1179: ELSE
1180:
1181: QP_Qualifiers_Util.Delete_Row
1182: ( p_qualifier_id => l_QUALIFIERS_rec.qualifier_id
1183: );
1184: END IF;
1185:

Line 1196: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);

1192: l_QUALIFIERS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1193:
1194: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1195:
1196: QP_Qualifiers_Util.Update_Row (l_QUALIFIERS_rec);
1197:
1198: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1199:
1200: l_QUALIFIERS_rec.creation_date := SYSDATE;

Line 1203: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);

1199:
1200: l_QUALIFIERS_rec.creation_date := SYSDATE;
1201: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
1202:
1203: QP_Qualifiers_Util.Insert_Row (l_QUALIFIERS_rec);
1204:
1205: END IF;
1206:
1207: END IF;

Line 2256: from qp_qualifiers

2252: oe_debug_pub.add('inside create qualifier for blanket modifier');
2253:
2254: BEGIN
2255: select 'Y' into l_qual_exists
2256: from qp_qualifiers
2257: where list_header_id = x_PRICE_LIST_rec.list_header_id
2258: and qualifier_context = 'ORDER'
2259: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE5'
2260: and qualifier_attr_value = x_PRICE_LIST_rec.orig_system_header_ref;

Line 2471: QP_Qualifiers_Util.Lock_Row

2467: FOR I IN 1..p_QUALIFIERS_tbl.COUNT LOOP
2468:
2469: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2470:
2471: QP_Qualifiers_Util.Lock_Row
2472: ( p_QUALIFIERS_rec => p_QUALIFIERS_tbl(I)
2473: , x_QUALIFIERS_rec => l_QUALIFIERS_rec
2474: , x_return_status => l_return_status
2475: );

Line 2674: l_QUALIFIERS_tbl := QP_Qualifiers_Util_Mod.Query_Rows

2670:
2671:
2672: -- Get QUALIFIERS ( parent = PRICE_LIST )
2673:
2674: l_QUALIFIERS_tbl := QP_Qualifiers_Util_Mod.Query_Rows
2675: ( p_list_header_id => l_PRICE_LIST_rec.list_header_id
2676: );
2677:
2678: