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.QP_LIST_HEADERS_PVT dependencies on QP_GLOBALS

Line 12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

8: -- Price_List
9:
10: PROCEDURE Price_List
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
14: , p_old_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type
15: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
16: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 20: l_control_rec QP_GLOBALS.Control_Rec_Type;

16: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
22: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
23: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
24: l_pte_code VARCHAR2(30);

Line 38: l_control_rec := QP_GLOBALS.Init_Control_Rec

34: --Added for Bug 2444971 - End
35:
36: -- Load API control record
37:
38: l_control_rec := QP_GLOBALS.Init_Control_Rec
39: ( p_operation => l_PRICE_LIST_rec.operation
40: , p_control_rec => p_control_rec
41: );
42:

Line 48: if l_PRICE_LIST_rec.operation in (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)

44:
45: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
46:
47: --added for moac for inline BSA PL and locked PL --fix for bug 4748511
48: if l_PRICE_LIST_rec.operation in (QP_GLOBALS.G_OPR_CREATE, QP_GLOBALS.G_OPR_UPDATE)
49: --and l_control_rec.called_from_ui = 'N' --this is not true for price locking API call
50: and l_PRICE_LIST_rec.list_source_code IS NOT NULL
51: and l_PRICE_LIST_rec.global_flag = 'N'
52: and nvl(QP_SECURITY.security_on, 'N') = 'N' then

Line 59: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

55: end if;
56:
57: -- Prepare record.
58:
59: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
60:
61: l_PRICE_LIST_rec.db_flag := FND_API.G_FALSE;
62:
63: -- Set missing old record elements to NULL.

Line 68: ELSIF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE

64:
65: l_old_PRICE_LIST_rec :=
66: QP_Price_List_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_rec);
67:
68: ELSIF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
69: OR l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE
70: THEN
71:
72: l_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;

Line 69: OR l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE

65: l_old_PRICE_LIST_rec :=
66: QP_Price_List_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_rec);
67:
68: ELSIF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
69: OR l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE
70: THEN
71:
72: l_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;
73:

Line 130: IF ( l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE

126: END IF;
127:
128: -- Attribute level validation.
129:
130: IF ( l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
131: or l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
132: or l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
133:
134: IF l_control_rec.default_attributes

Line 131: or l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE

127:
128: -- Attribute level validation.
129:
130: IF ( l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
131: or l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
132: or l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
133:
134: IF l_control_rec.default_attributes
135: OR l_control_rec.change_attributes

Line 132: or l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN

128: -- Attribute level validation.
129:
130: IF ( l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
131: or l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
132: or l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
133:
134: IF l_control_rec.default_attributes
135: OR l_control_rec.change_attributes
136: THEN

Line 199: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

195: -- Entity level validation.
196:
197: IF l_control_rec.validate_entity THEN
198:
199: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
200:
201: QP_Validate_Price_List.Entity_Delete
202: ( x_return_status => l_return_status
203: , p_PRICE_LIST_rec => l_PRICE_LIST_rec

Line 229: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

225: -- Step 4. Write to DB
226:
227: IF l_control_rec.write_to_db THEN
228:
229: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
230:
231: FND_MESSAGE.SET_NAME('QP', 'QP_CANNOT_DELETE_PRICE_LIST');
232: OE_MSG_PUB.Add;
233:

Line 248: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

244: l_PRICE_LIST_rec.last_update_date := SYSDATE;
245: l_PRICE_LIST_rec.last_updated_by := FND_GLOBAL.USER_ID;
246: l_PRICE_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
247:
248: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
249:
250: QP_Price_List_Util.Update_Row (l_PRICE_LIST_rec);
251:
252: ELSIF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 252: ELSIF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

248: IF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
249:
250: QP_Price_List_Util.Update_Row (l_PRICE_LIST_rec);
251:
252: ELSIF l_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
253:
254: l_PRICE_LIST_rec.creation_date := SYSDATE;
255: l_PRICE_LIST_rec.created_by := FND_GLOBAL.USER_ID;
256:

Line 284: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST,

280: -- mkarya If process_price_list has been called from public package, then ONLY call
281: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
282: if l_control_rec.called_from_ui = 'N' then
283: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
284: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST,
285: p_entity_id => l_PRICE_LIST_rec.list_header_id,
286: x_return_status => l_return_status );
287: end if;
288:

Line 301: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST,

297: -- mkarya If process_price_list has been called from public package, then ONLY call
298: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
299: if l_control_rec.called_from_ui = 'N' then
300: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
301: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST,
302: p_entity_id => l_PRICE_LIST_rec.list_header_id,
303: x_return_status => l_return_status );
304: end if;
305:

Line 326: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST,

322: -- mkarya If process_price_list has been called from public package, then ONLY call
323: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
324: if l_control_rec.called_from_ui = 'N' then
325: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
326: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST,
327: p_entity_id => l_PRICE_LIST_rec.list_header_id,
328: x_return_status => l_return_status );
329: end if;
330:

Line 339: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

335: -- Price_List_Lines
336:
337: PROCEDURE Price_List_Lines
338: ( p_validation_level IN NUMBER
339: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
340: , p_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
341: , p_old_PRICE_LIST_LINE_tbl IN QP_Price_List_PUB.Price_List_Line_Tbl_Type
342: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
343: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type

Line 347: l_control_rec QP_GLOBALS.Control_Rec_Type;

343: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
344: )
345: IS
346: l_return_status VARCHAR2(1);
347: l_control_rec QP_GLOBALS.Control_Rec_Type;
348: l_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
349: l_p_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;
350: l_PRICE_LIST_LINE_tbl QP_Price_List_PUB.Price_List_Line_Tbl_Type;
351: l_old_PRICE_LIST_LINE_rec QP_Price_List_PUB.Price_List_Line_Rec_Type;

Line 385: l_control_rec := QP_GLOBALS.Init_Control_Rec

381: END IF;
382:
383: -- Load API control record
384:
385: l_control_rec := QP_GLOBALS.Init_Control_Rec
386: ( p_operation => l_PRICE_LIST_LINE_rec.operation
387: , p_control_rec => p_control_rec
388: );
389:

Line 396: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

392: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
393:
394: -- Prepare record.
395:
396: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
397:
398: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_FALSE;
399:
400: -- Set missing old record elements to NULL.

Line 405: ELSIF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE

401:
402: l_old_PRICE_LIST_LINE_rec :=
403: QP_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);
404:
405: ELSIF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
406: OR l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE
407: THEN
408:
409: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;

Line 406: OR l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE

402: l_old_PRICE_LIST_LINE_rec :=
403: QP_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);
404:
405: ELSIF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
406: OR l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE
407: THEN
408:
409: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;
410:

Line 467: IF ( l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE

463: END IF;
464:
465: -- Attribute level validation.
466:
467: IF ( l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
468: or l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE
469: or l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
470:
471: IF l_control_rec.default_attributes

Line 468: or l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE

464:
465: -- Attribute level validation.
466:
467: IF ( l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
468: or l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE
469: or l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
470:
471: IF l_control_rec.default_attributes
472: OR l_control_rec.change_attributes

Line 469: or l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN

465: -- Attribute level validation.
466:
467: IF ( l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
468: or l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE
469: or l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
470:
471: IF l_control_rec.default_attributes
472: OR l_control_rec.change_attributes
473: THEN

Line 519: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

515:
516: END IF;
517:
518: --Start of code added for Bug 2444971. Added for Patchset H
519: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
520: BEGIN
521: SELECT pte_code, source_system_code
522: INTO l_saved_pte_code, l_saved_source_system_code
523: FROM qp_list_headers_b

Line 565: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

561: -- Entity level validation.
562:
563: IF l_control_rec.validate_entity THEN
564:
565: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
566:
567: QP_Validate_Price_List_Line.Entity_Delete
568: ( x_return_status => l_return_status
569: , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec

Line 594: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

590: -- Step 4. Write to DB
591:
592: IF l_control_rec.write_to_db THEN
593:
594: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
595:
596: QP_Price_List_Line_Util.Delete_Row
597: ( p_list_line_id => l_PRICE_LIST_LINE_rec.list_line_id
598: );

Line 608: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

604: l_PRICE_LIST_LINE_rec.last_update_date := SYSDATE;
605: l_PRICE_LIST_LINE_rec.last_updated_by := FND_GLOBAL.USER_ID;
606: l_PRICE_LIST_LINE_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
607:
608: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
609:
610: QP_Price_List_Line_Util.Update_Row (l_PRICE_LIST_LINE_rec);
611:
612: ELSIF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 612: ELSIF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

608: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
609:
610: QP_Price_List_Line_Util.Update_Row (l_PRICE_LIST_LINE_rec);
611:
612: ELSIF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
613:
614: l_PRICE_LIST_LINE_rec.creation_date := SYSDATE;
615: l_PRICE_LIST_LINE_rec.created_by := FND_GLOBAL.USER_ID;
616:

Line 619: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE

615: l_PRICE_LIST_LINE_rec.created_by := FND_GLOBAL.USER_ID;
616:
617: QP_Price_List_Line_Util.Insert_Row (l_PRICE_LIST_LINE_rec);
618:
619: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE
620: AND l_PRICE_LIST_LINE_rec.PRICE_BREAK_HEADER_index IS NOT NULL
621: AND l_PRICE_LIST_LINE_rec.PRICE_BREAK_HEADER_index <> FND_API.G_MISS_NUM
622: AND (l_PRICE_LIST_LINE_rec.from_rltd_modifier_id IS NULL OR
623: l_PRICE_LIST_LINE_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM)

Line 678: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

674: , null
675: );
676:
677: qp_delayed_requests_PVT.log_request(
678: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
679: p_entity_id => l_price_list_line_rec.list_line_id,
680: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
681: p_requesting_entity_id => l_price_list_line_rec.list_line_id,
682: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

Line 680: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

676:
677: qp_delayed_requests_PVT.log_request(
678: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
679: p_entity_id => l_price_list_line_rec.list_line_id,
680: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
681: p_requesting_entity_id => l_price_list_line_rec.list_line_id,
682: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
683: x_return_status => l_return_status);
684:

Line 682: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,

678: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
679: p_entity_id => l_price_list_line_rec.list_line_id,
680: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
681: p_requesting_entity_id => l_price_list_line_rec.list_line_id,
682: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
683: x_return_status => l_return_status);
684:
685: END IF;
686:

Line 715: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

711: -- mkarya If process_price_list has been called from public package, then ONLY call
712: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
713: if l_control_rec.called_from_ui = 'N' then
714: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
715: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
716: p_entity_id => l_PRICE_LIST_LINE_rec.list_line_id,
717: x_return_status => l_return_status );
718:
719: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 720: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

716: p_entity_id => l_PRICE_LIST_LINE_rec.list_line_id,
717: x_return_status => l_return_status );
718:
719: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
720: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
721: p_entity_id => l_PRICE_LIST_LINE_rec.list_line_id,
722: x_return_status => l_return_status );
723: end if;
724:

Line 735: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

731: -- mkarya If process_price_list has been called from public package, then ONLY call
732: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
733: if l_control_rec.called_from_ui = 'N' then
734: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
735: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
736: p_entity_id => l_PRICE_LIST_LINE_rec.list_line_id,
737: x_return_status => l_return_status );
738:
739: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 740: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

736: p_entity_id => l_PRICE_LIST_LINE_rec.list_line_id,
737: x_return_status => l_return_status );
738:
739: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
740: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
741: p_entity_id => l_PRICE_LIST_LINE_rec.list_line_id,
742: x_return_status => l_return_status );
743: end if;
744:

Line 765: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

761: -- mkarya If process_price_list has been called from public package, then ONLY call
762: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
763: if l_control_rec.called_from_ui = 'N' then
764: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
765: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
766: p_entity_id => l_PRICE_LIST_LINE_rec.list_line_id,
767: x_return_status => l_return_status );
768:
769: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 770: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

766: p_entity_id => l_PRICE_LIST_LINE_rec.list_line_id,
767: x_return_status => l_return_status );
768:
769: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
770: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
771: p_entity_id => l_PRICE_LIST_LINE_rec.list_line_id,
772: x_return_status => l_return_status );
773: end if;
774:

Line 816: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

812:
813:
814: PROCEDURE Qualifierss
815: ( p_validation_level IN NUMBER
816: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
817: , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
818: , p_old_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
819: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
820: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type

Line 824: l_control_rec QP_GLOBALS.Control_Rec_Type;

820: , x_old_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
821: )
822: IS
823: l_return_status VARCHAR2(1);
824: l_control_rec QP_GLOBALS.Control_Rec_Type;
825: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
826: l_p_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
827: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
828: l_old_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;

Line 865: l_control_rec := QP_GLOBALS.Init_Control_Rec

861: END IF;
862:
863: -- Load API control record
864:
865: l_control_rec := QP_GLOBALS.Init_Control_Rec
866: ( p_operation => l_QUALIFIERS_rec.operation
867: , p_control_rec => p_control_rec
868: );
869:

Line 876: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

872: l_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: -- Prepare record.
875:
876: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
877:
878: l_QUALIFIERS_rec.db_flag := FND_API.G_FALSE;
879:
880: -- Set missing old record elements to NULL.

Line 885: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

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
888:
889: l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;

Line 886: OR l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE

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
888:
889: l_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
890:

Line 949: IF ( l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

945:
946: END IF;
947:
948: -- Attribute level validation.
949: IF ( l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
950: or l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
951: or l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
952:
953: IF l_control_rec.default_attributes

Line 950: or l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

946: END IF;
947:
948: -- Attribute level validation.
949: IF ( l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
950: or l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
951: or l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
952:
953: IF l_control_rec.default_attributes
954: OR l_control_rec.change_attributes

Line 951: or l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN

947:
948: -- Attribute level validation.
949: IF ( l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
950: or l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
951: or l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
952:
953: IF l_control_rec.default_attributes
954: OR l_control_rec.change_attributes
955: THEN

Line 1001: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

997:
998: END IF;
999:
1000: --Start of code added for Bug 2444971. Added for Patchset H
1001: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
1002: THEN
1003: BEGIN
1004:
1005: SELECT pte_code, source_system_code, list_type_code

Line 1052: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1048: -- Entity level validation.
1049:
1050: IF l_control_rec.validate_entity THEN
1051:
1052: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1053:
1054: QP_Validate_Qualifiers.Entity_Delete
1055: ( x_return_status => l_return_status
1056: , p_QUALIFIERS_rec => l_QUALIFIERS_rec

Line 1130: if l_qualifiers_rec.operation <> QP_GLOBALS.G_OPR_DELETE

1126: /*end of modifications by spgopal 08/17/00*/
1127:
1128: /* The following if condition has been added for 1606695 */
1129:
1130: if l_qualifiers_rec.operation <> QP_GLOBALS.G_OPR_DELETE
1131: then
1132: SELECT COUNT(*)
1133: INTO v_count
1134: FROM qp_secondary_price_lists_v

Line 1168: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1164: -- Step 4. Write to DB
1165:
1166: IF l_control_rec.write_to_db THEN
1167:
1168: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1169:
1170: IF l_QUALIFIERS_rec.QUALIFIER_CONTEXT = 'MODLIST' AND
1171: l_QUALIFIERS_rec.QUALIFIER_ATTRIBUTE =
1172: 'QUALIFIER_ATTRIBUTE3' THEN

Line 1194: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

1190: l_QUALIFIERS_rec.last_update_date := SYSDATE;
1191: l_QUALIFIERS_rec.last_updated_by := FND_GLOBAL.USER_ID;
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

Line 1198: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

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;
1201: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
1202:

Line 1233: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1229: -- mkarya If process_price_list has been called from public package, then ONLY call
1230: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1231: if l_control_rec.called_from_ui = 'N' then
1232: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1233: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1234: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1235: x_return_status => l_return_status );
1236:
1237: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1238: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1234: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1235: x_return_status => l_return_status );
1236:
1237: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1238: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1239: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1240: x_return_status => l_return_status );
1241:
1242: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1243: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1239: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1240: x_return_status => l_return_status );
1241:
1242: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1243: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1244: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1245: x_return_status => l_return_status );
1246: end if;
1247:

Line 1258: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1254: -- mkarya If process_price_list has been called from public package, then ONLY call
1255: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1256: if l_control_rec.called_from_ui = 'N' then
1257: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1258: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1259: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1260: x_return_status => l_return_status );
1261:
1262: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1263: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1259: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1260: x_return_status => l_return_status );
1261:
1262: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1263: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1264: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1265: x_return_status => l_return_status );
1266:
1267: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1268: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1264: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1265: x_return_status => l_return_status );
1266:
1267: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1268: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1269: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1270: x_return_status => l_return_status );
1271: end if;
1272:

Line 1293: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1289: -- mkarya If process_price_list has been called from public package, then ONLY call
1290: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1291: if l_control_rec.called_from_ui = 'N' then
1292: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1293: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1294: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1295: x_return_status => l_return_status );
1296:
1297: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1298: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1294: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1295: x_return_status => l_return_status );
1296:
1297: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1298: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1299: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1300: x_return_status => l_return_status );
1301:
1302: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1303: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1299: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1300: x_return_status => l_return_status );
1301:
1302: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1303: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1304: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1305: x_return_status => l_return_status );
1306: end if;
1307:

Line 1350: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

1346: -- Pricing_Attrs
1347:
1348: PROCEDURE Pricing_Attrs
1349: ( p_validation_level IN NUMBER
1350: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1351: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1352: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1353: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1354: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 1358: l_control_rec QP_GLOBALS.Control_Rec_Type;

1354: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1355: )
1356: IS
1357: l_return_status VARCHAR2(1);
1358: l_control_rec QP_GLOBALS.Control_Rec_Type;
1359: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1360: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1361: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1362: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1426: l_control_rec := QP_GLOBALS.Init_Control_Rec

1422:
1423: -- Load API control record
1424: oe_debug_pub.add('before init control rec');
1425:
1426: l_control_rec := QP_GLOBALS.Init_Control_Rec
1427: ( p_operation => l_PRICING_ATTR_rec.operation
1428: , p_control_rec => p_control_rec
1429: );
1430:

Line 1437: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

1433: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1434:
1435: -- Prepare record.
1436:
1437: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1438:
1439: oe_debug_pub.add(' operation is create ');
1440:
1441: l_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;

Line 1448: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

1444:
1445: l_old_PRICING_ATTR_rec :=
1446: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1447:
1448: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1449: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1450: THEN
1451: oe_debug_pub.add('operation is update');
1452:

Line 1449: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE

1445: l_old_PRICING_ATTR_rec :=
1446: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1447:
1448: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1449: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1450: THEN
1451: oe_debug_pub.add('operation is update');
1452:
1453: l_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;

Line 1516: IF ( l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

1512:
1513: END IF;
1514:
1515: -- Attribute level validation.
1516: IF ( l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1517: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1518: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
1519:
1520: IF l_control_rec.default_attributes

Line 1517: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

1513: END IF;
1514:
1515: -- Attribute level validation.
1516: IF ( l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1517: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1518: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
1519:
1520: IF l_control_rec.default_attributes
1521: OR l_control_rec.change_attributes

Line 1518: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN

1514:
1515: -- Attribute level validation.
1516: IF ( l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1517: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1518: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
1519:
1520: IF l_control_rec.default_attributes
1521: OR l_control_rec.change_attributes
1522: THEN

Line 1574: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

1570:
1571: END IF;
1572:
1573: --Start of code added for Bug 2444971. Added for Patchset H
1574: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1575: THEN
1576: BEGIN
1577: SELECT h.pte_code, h.source_system_code
1578: INTO l_saved_pte_code, l_saved_source_system_code

Line 1624: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1620: -- Entity level validation.
1621:
1622: IF l_control_rec.validate_entity THEN
1623:
1624: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1625:
1626: QP_Validate_pll_pricing_attr.Entity_Delete
1627: ( x_return_status => l_return_status
1628: , p_PRICING_ATTR_rec => l_PRICING_ATTR_rec

Line 1662: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1658: -- Step 4. Write to DB
1659:
1660: IF l_control_rec.write_to_db THEN
1661:
1662: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1663:
1664: Qp_pll_pricing_attr_Util.Delete_Row
1665: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1666: );

Line 1676: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

1672: l_PRICING_ATTR_rec.last_update_date := SYSDATE;
1673: l_PRICING_ATTR_rec.last_updated_by := FND_GLOBAL.USER_ID;
1674: l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1675:
1676: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1677:
1678: oe_debug_Pub.add('before update row');
1679: Qp_pll_pricing_attr_Util.Update_Row (l_PRICING_ATTR_rec);
1680:

Line 1681: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

1677:
1678: oe_debug_Pub.add('before update row');
1679: Qp_pll_pricing_attr_Util.Update_Row (l_PRICING_ATTR_rec);
1680:
1681: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1682:
1683: l_PRICING_ATTR_rec.creation_date := SYSDATE;
1684: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;
1685:

Line 1718: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

1714: -- mkarya If process_price_list has been called from public package, then ONLY call
1715: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1716: if l_control_rec.called_from_ui = 'N' then
1717: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1718: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
1719: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1720: x_return_status => l_return_status );
1721:
1722: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1723: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1719: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1720: x_return_status => l_return_status );
1721:
1722: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1723: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1724: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1725: x_return_status => l_return_status );
1726: end if;
1727:

Line 1738: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

1734: -- mkarya If process_price_list has been called from public package, then ONLY call
1735: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1736: if l_control_rec.called_from_ui = 'N' then
1737: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1738: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
1739: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1740: x_return_status => l_return_status );
1741:
1742: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1743: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1739: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1740: x_return_status => l_return_status );
1741:
1742: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1743: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1744: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1745: x_return_status => l_return_status );
1746: end if;
1747:

Line 1768: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

1764: -- mkarya If process_price_list has been called from public package, then ONLY call
1765: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1766: if l_control_rec.called_from_ui = 'N' then
1767: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1768: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,
1769: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1770: x_return_status => l_return_status );
1771:
1772: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1773: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1769: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1770: x_return_status => l_return_status );
1771:
1772: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1773: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1774: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1775: x_return_status => l_return_status );
1776: end if;
1777:

Line 1837: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=

1833: ( p_api_version_number IN NUMBER
1834: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1835: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1836: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1837: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1838: QP_GLOBALS.G_MISS_CONTROL_REC
1839: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1840: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1841: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1838: QP_GLOBALS.G_MISS_CONTROL_REC

1834: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1835: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1836: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1837: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1838: QP_GLOBALS.G_MISS_CONTROL_REC
1839: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1840: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1841: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1842: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

Line 1869: l_control_rec QP_GLOBALS.Control_Rec_Type;

1865: IS
1866: l_api_version_number CONSTANT NUMBER := 1.0;
1867: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
1868: l_return_status VARCHAR2(1);
1869: l_control_rec QP_GLOBALS.Control_Rec_Type;
1870: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1871: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1872: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1873: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

Line 1966: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

1962:
1963: -- Perform PRICE_LIST group requests.
1964:
1965: IF p_control_rec.process AND
1966: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1967: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST)
1968: THEN
1969:
1970: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1967: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST)

1963: -- Perform PRICE_LIST group requests.
1964:
1965: IF p_control_rec.process AND
1966: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1967: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST)
1968: THEN
1969:
1970: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1971: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST

Line 1971: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST

1967: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST)
1968: THEN
1969:
1970: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1971: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST
1972: ,p_delete => FND_API.G_TRUE
1973: ,x_return_status => l_return_status
1974: );
1975: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1989: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE

1985: FOR I IN 1..l_PRICE_LIST_LINE_tbl.COUNT LOOP
1986:
1987: l_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_tbl(I);
1988:
1989: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE
1990: AND (l_PRICE_LIST_LINE_rec.list_header_id IS NULL OR
1991: l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM)
1992: THEN
1993:

Line 2018: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

2014:
2015: -- Perform PRICE_LIST_LINE group requests.
2016:
2017: IF p_control_rec.process AND
2018: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2019: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE)
2020: THEN
2021:
2022: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 2019: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE)

2015: -- Perform PRICE_LIST_LINE group requests.
2016:
2017: IF p_control_rec.process AND
2018: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2019: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE)
2020: THEN
2021:
2022: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2023: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE

Line 2023: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE

2019: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE)
2020: THEN
2021:
2022: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2023: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE
2024: ,p_delete => FND_API.G_TRUE
2025: ,x_return_status => l_return_status
2026: );
2027: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2041: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

2037: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
2038:
2039: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
2040:
2041: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2042: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR
2043: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2044: THEN
2045:

Line 2071: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

2067:
2068: -- Perform QUALIFIERS group requests.
2069:
2070: IF p_control_rec.process AND
2071: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2072: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2073: THEN
2074: oe_debug_pub.add('process_Price_List 12');
2075: NULL;

Line 2072: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)

2068: -- Perform QUALIFIERS group requests.
2069:
2070: IF p_control_rec.process AND
2071: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2072: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2073: THEN
2074: oe_debug_pub.add('process_Price_List 12');
2075: NULL;
2076:

Line 2086: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

2082:
2083: oe_debug_pub.add('process_Price_List 13');
2084: l_PRICING_ATTR_rec := l_PRICING_ATTR_tbl(I);
2085:
2086: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
2087: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2088: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2089: THEN
2090:

Line 2148: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

2144:
2145: -- Perform PRICING_ATTR group requests.
2146:
2147: IF p_control_rec.process AND
2148: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2149: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)
2150: THEN
2151:
2152: NULL;

Line 2149: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)

2145: -- Perform PRICING_ATTR group requests.
2146:
2147: IF p_control_rec.process AND
2148: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2149: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)
2150: THEN
2151:
2152: NULL;
2153:

Line 2159: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

2155:
2156: -- Step 6. Perform Object group logic
2157:
2158: IF p_control_rec.process AND
2159: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2160: THEN
2161:
2162: oe_debug_pub.add('Ren: before processing delayed request');
2163:

Line 2246: AND x_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE

2242:
2243: -- Create blanket header qualifier
2244:
2245: IF ( p_control_rec.write_to_db --Bug#3309455
2246: AND x_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
2247: AND x_PRICE_LIST_rec.list_source_code = 'BSO'
2248: AND ( x_PRICE_LIST_rec.orig_system_header_ref <> NULL
2249: OR x_PRICE_LIST_rec.orig_system_header_ref <> FND_API.G_MISS_CHAR)
2250: )

Line 2273: , p_operation => QP_GLOBALS.G_OPR_CREATE

2269: QP_Qualifier_Rules_PVT.Create_Blanket_Qualifier
2270: ( p_list_header_id => x_PRICE_LIST_rec.list_header_id
2271: , p_old_list_header_id => x_PRICE_LIST_rec.list_header_id
2272: , p_blanket_id => to_number(x_PRICE_LIST_rec.orig_system_header_ref)
2273: , p_operation => QP_GLOBALS.G_OPR_CREATE
2274: , x_return_status => l_return_status
2275: );
2276:
2277: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2424: IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN

2420: SAVEPOINT Lock_Price_List_PVT;
2421:
2422: -- Lock PRICE_LIST
2423:
2424: IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
2425:
2426: QP_Price_List_Util.Lock_Row
2427: ( p_PRICE_LIST_rec => p_PRICE_LIST_rec
2428: , x_PRICE_LIST_rec => x_PRICE_LIST_rec

Line 2445: IF p_PRICE_LIST_LINE_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2441: -- Lock PRICE_LIST_LINE
2442:
2443: FOR I IN 1..p_PRICE_LIST_LINE_tbl.COUNT LOOP
2444:
2445: IF p_PRICE_LIST_LINE_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2446:
2447: QP_Price_List_Line_Util.Lock_Row
2448: ( p_PRICE_LIST_LINE_rec => p_PRICE_LIST_LINE_tbl(I)
2449: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec

Line 2469: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2465: -- Lock QUALIFIERS
2466:
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

Line 2494: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2490: -- Lock PRICING_ATTR
2491:
2492: FOR I IN 1..p_PRICING_ATTR_tbl.COUNT LOOP
2493:
2494: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2495:
2496: Qp_pll_pricing_attr_Util.Lock_Row
2497: ( p_PRICING_ATTR_rec => p_PRICING_ATTR_tbl(I)
2498: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec