eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_PRICELIST_PVT dependencies on QP_GLOBALS

Line 73: IF p_operation = QP_GLOBALS.G_OPR_CREATE THEN

69: FROM ams_custom_setups_vl
70: WHERE object_type = 'PRIC';
71:
72: BEGIN
73: IF p_operation = QP_GLOBALS.G_OPR_CREATE THEN
74: OZF_PRICE_LIST_PVT.create_price_list(p_api_version_number => 1
75: ,p_init_msg_list => FND_API.G_FALSE
76: ,p_commit => FND_API.G_FALSE
77: ,x_return_status => l_return_status

Line 106: ELSIF p_operation = QP_GLOBALS.G_OPR_UPDATE THEN

102: END IF;
103: */
104: -- end of comment
105:
106: ELSIF p_operation = QP_GLOBALS.G_OPR_UPDATE THEN
107: OZF_PRICE_LIST_PVT.update_price_list(p_api_version_number => 1
108: ,p_init_msg_list => FND_API.G_FALSE
109: ,p_commit => FND_API.G_FALSE
110: ,x_return_status => l_return_status

Line 117: ELSIF p_operation = QP_GLOBALS.G_OPR_DELETE THEN

113: ,p_ozf_PRICE_LIST_rec => p_price_list_attr_rec
114: ,x_object_version_number => l_object_version_number);
115:
116:
117: ELSIF p_operation = QP_GLOBALS.G_OPR_DELETE THEN
118:
119: OZF_PRICE_LIST_PVT.delete_price_list( p_api_version_number => 1
120: ,p_init_msg_list => FND_API.G_FALSE
121: ,p_commit => FND_API.G_FALSE

Line 255: /* IF p_price_list_rec.operation <> QP_GLOBALS.G_OPR_CREATE THEN

251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252:
253:
254: -- Commented to allow product association to Price Lists Created in QP
255: /* IF p_price_list_rec.operation <> QP_GLOBALS.G_OPR_CREATE THEN
256: IF AMS_ACCESS_PVT.check_update_access(p_price_list_rec.list_header_id, 'PRIC',l_resource_id,'USER') NOT IN ('F','R') THEN
257: FND_MESSAGE.SET_NAME('OZF','OZF_EVO_NO_UPDATE_ACCESS');
258: FND_MESSAGE.SET_TOKEN('ERROR_MSG',l_msg_data);
259: FND_MSG_PUB.ADD;

Line 371: IF p_price_list_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

367: END IF;
368:
369: /****************Uncomment once upgraded to R3 LEVEL **********************/
370:
371: IF p_price_list_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
372: l_price_list_rec.list_type_code := 'PRL';
373: l_price_list_rec.active_flag := 'N';
374: l_price_list_rec.list_header_id := FND_API.G_MISS_NUM;
375: ELSE

Line 421: IF p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_CREATE THEN

417: l_price_list_line_tbl(i).attribute14 := p_price_list_line_tbl(i).attribute14;
418: l_price_list_line_tbl(i).attribute15 := p_price_list_line_tbl(i).attribute15;
419: -- julou end
420:
421: IF p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_CREATE THEN
422: l_price_list_line_tbl(i).list_line_type_code := 'PLL';
423: l_price_list_line_tbl(i).operation := p_price_list_line_tbl(i).operation ;
424: l_price_list_line_tbl(i).arithmetic_operator := 'UNIT_PRICE';
425: l_price_list_line_tbl(i).print_on_invoice_flag := 'N';

Line 439: ELSIF p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_UPDATE THEN

435: l_price_list_line_tbl(i).product_precedence := p_price_list_line_tbl(i).product_precedence;
436: l_price_list_line_tbl(i).primary_uom_flag := p_price_list_line_tbl(i).primary_uom_flag;
437: l_price_list_line_tbl(i).generate_using_formula_id := p_price_list_line_tbl(i).static_formula_id;
438: l_price_list_line_tbl(i).price_by_formula_id := p_price_list_line_tbl(i).dynamic_formula_id;
439: ELSIF p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_UPDATE THEN
440: l_price_list_line_tbl(i).operation := p_price_list_line_tbl(i).operation ;
441: l_price_list_line_tbl(i).start_date_active := p_price_list_line_tbl(i).start_date_active;
442: l_price_list_line_tbl(i).end_date_active := p_price_list_line_tbl(i).end_date_active;
443: l_price_list_line_tbl(i).operand := p_price_list_line_tbl(i).operand;

Line 469: IF p_pricing_attr_tbl(i).operation = QP_GLOBALS.G_OPR_CREATE THEN

465: l_pricing_attr_tbl(i).operation := p_pricing_attr_tbl(i).operation ;
466: l_pricing_attr_tbl(i).PRODUCT_ATTR_VALUE := p_pricing_attr_tbl(i).PRODUCT_ATTR_VALUE;
467: l_pricing_attr_tbl(i).PRODUCT_UOM_CODE := p_pricing_attr_tbl(i).PRODUCT_UOM_CODE;
468:
469: IF p_pricing_attr_tbl(i).operation = QP_GLOBALS.G_OPR_CREATE THEN
470:
471: l_pricing_attr_tbl(i).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
472: l_pricing_attr_tbl(i).PRODUCT_ATTRIBUTE := p_pricing_attr_tbl(i).PRODUCT_ATTRIBUTE;
473: l_pricing_attr_tbl(i).EXCLUDER_FLAG := 'N';

Line 546: IF p_price_list_line_tbl.exists(i) AND p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_DELETE THEN

542: l_pricing_attr_tbl.delete;
543: j := 1;
544: FOR i in p_price_list_line_tbl.first..p_price_list_line_tbl.last LOOP
545:
546: IF p_price_list_line_tbl.exists(i) AND p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_DELETE THEN
547:
548: l_price_list_line_tbl(j).list_line_id := p_price_list_line_tbl(i).list_line_id;
549: l_price_list_line_tbl(j).list_header_id := p_price_list_line_tbl(i).list_header_id;
550: l_price_list_line_tbl(j).operation := p_price_list_line_tbl(i).operation ;

Line 625: IF p_price_list_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

621: l_ozf_price_list_attr_rec.user_status_id := p_price_list_rec.user_status_id;
622: l_ozf_price_list_attr_rec.owner_id := p_price_list_rec.owner_id;
623: l_ozf_price_list_attr_rec.custom_setup_id := p_price_list_rec.custom_setup_id ;
624:
625: IF p_price_list_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
626: FND_MESSAGE.SET_NAME('OZF','CREATE');
627: l_ozf_price_list_attr_rec.object_version_number := 1;
628: l_ozf_price_list_attr_rec.qp_list_header_id := v_price_list_rec.list_header_id ;
629: l_ozf_price_list_attr_rec.custom_setup_id := p_price_list_rec.custom_setup_id ;

Line 775: IF p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_UPDATE

771: END IF;
772: /*-- added by julou 08/16/2001 create or update note info in jtf notes tables.
773: IF p_price_list_line_tbl.count > 0 THEN
774: FOR i in p_price_list_line_tbl.first .. p_price_list_line_tbl.last LOOP
775: IF p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_UPDATE
776: OR p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_CREATE THEN
777: IF p_price_list_line_tbl(i).jtf_note_id IS NULL THEN
778: IF p_price_list_line_tbl(i).note IS NOT NULL THEN
779: JTF_NOTES_PUB.Create_note(

Line 776: OR p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_CREATE THEN

772: /*-- added by julou 08/16/2001 create or update note info in jtf notes tables.
773: IF p_price_list_line_tbl.count > 0 THEN
774: FOR i in p_price_list_line_tbl.first .. p_price_list_line_tbl.last LOOP
775: IF p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_UPDATE
776: OR p_price_list_line_tbl(i).operation = QP_GLOBALS.G_OPR_CREATE THEN
777: IF p_price_list_line_tbl(i).jtf_note_id IS NULL THEN
778: IF p_price_list_line_tbl(i).note IS NOT NULL THEN
779: JTF_NOTES_PUB.Create_note(
780: p_parent_note_id => FND_API.g_miss_num,

Line 997: l_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

993: l_qualifiers_tbl(i).list_header_id := p_price_list_id;
994: l_qualifiers_tbl(i).qualifier_context := 'SEGMENT';
995: l_qualifiers_tbl(i).qualifier_attribute := 'QUALIFIER_ATTRIBUTE1';
996: l_qualifiers_tbl(i).comparison_operator_code := '=';
997: l_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
998: i := i+1;
999: END LOOP;
1000:
1001: --Create Target segments

Line 1009: l_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;

1005: l_qualifiers_tbl(i).list_header_id := p_price_list_id;
1006: l_qualifiers_tbl(i).qualifier_context := 'SEGMENT';
1007: l_qualifiers_tbl(i).qualifier_attribute := 'QUALIFER_ATTRIBUTE2';
1008: l_qualifiers_tbl(i).comparison_operator_code := '=';
1009: l_qualifiers_tbl(i).operation := QP_GLOBALS.G_OPR_CREATE;
1010: i := i+1;
1011: END LOOP;
1012:
1013: IF l_qualifiers_tbl.count > 0 THEN

Line 1573: l_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

1569: l_price_list_rec.currency_header_id := l_list_header_detail.currency_header_id;
1570: l_price_list_rec.active_flag := l_list_header_detail.active_flag;
1571: l_price_list_rec.list_type_code := l_list_header_detail.list_type_code;
1572: l_price_list_rec.list_header_id := l_list_header_line_id.list_header_id;
1573: l_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1574: l_price_list_rec.rounding_factor := l_list_header_detail.rounding_factor;
1575: l_price_list_rec.created_by := l_list_header_detail.created_by;
1576: l_price_list_rec.creation_date := l_list_header_detail.creation_date;
1577:

Line 1650: l_price_list_line_tbl(l_index).operation := QP_GLOBALS.G_OPR_CREATE;

1646: l_price_list_line_tbl(l_index).substitution_context := l_list_line_detail.substitution_context;
1647: l_price_list_line_tbl(l_index).substitution_value := l_list_line_detail.substitution_value;
1648: l_price_list_line_tbl(l_index).product_precedence := l_list_line_detail.product_precedence;
1649: l_price_list_line_tbl(l_index).qualification_ind := l_list_line_detail.qualification_ind;
1650: l_price_list_line_tbl(l_index).operation := QP_GLOBALS.G_OPR_CREATE;
1651:
1652: l_pricing_attr_tbl(l_index).accumulate_flag := l_pricing_detail.accumulate_flag ;
1653: l_pricing_attr_tbl(l_index).attribute1 := l_pricing_detail.attribute1;
1654: l_pricing_attr_tbl(l_index).attribute2 := l_pricing_detail.attribute2;

Line 1691: l_pricing_attr_tbl(l_index).operation := QP_GLOBALS.G_OPR_CREATE;

1687: l_pricing_attr_tbl(l_index).product_attribute_datatype := l_pricing_detail.product_attribute_datatype;
1688: l_pricing_attr_tbl(l_index).pricing_attribute_datatype := l_pricing_detail.pricing_attribute_datatype;
1689: l_pricing_attr_tbl(l_index).list_header_id := l_pricing_detail.list_header_id;
1690: l_pricing_attr_tbl(l_index).pricing_phase_id := l_pricing_detail.pricing_phase_id;
1691: l_pricing_attr_tbl(l_index).operation := QP_GLOBALS.G_OPR_CREATE;
1692:
1693: l_index := l_index + 1;
1694: END IF;
1695: END LOOP;