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: IF l_QUALIFIERS_rec.QUALIFIER_CONTEXT = 'MODLIST' AND
1198: l_QUALIFIERS_rec.QUALIFIER_ATTRIBUTE =

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

1199: 'QUALIFIER_ATTRIBUTE3' THEN
1200: QP_Qualifiers_Util.Update_Coupon_Row (l_QUALIFIERS_rec); ---Added for bug 7315016
1201: END IF;
1202:
1203: ELSIF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1204:
1205: l_QUALIFIERS_rec.creation_date := SYSDATE;
1206: l_QUALIFIERS_rec.created_by := FND_GLOBAL.USER_ID;
1207:

Line 1238: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1234: -- mkarya If process_price_list has been called from public package, then ONLY call
1235: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1236: if l_control_rec.called_from_ui = 'N' then
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_header_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_header_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.list_line_id,
1245: x_return_status => l_return_status );
1246:
1247: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1248: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1244: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1245: x_return_status => l_return_status );
1246:
1247: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1248: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1249: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1250: x_return_status => l_return_status );
1251: end if;
1252:

Line 1263: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1259: -- mkarya If process_price_list has been called from public package, then ONLY call
1260: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1261: if l_control_rec.called_from_ui = 'N' then
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_header_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_header_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.list_line_id,
1270: x_return_status => l_return_status );
1271:
1272: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1273: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1269: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1270: x_return_status => l_return_status );
1271:
1272: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1273: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1274: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1275: x_return_status => l_return_status );
1276: end if;
1277:

Line 1298: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1294: -- mkarya If process_price_list has been called from public package, then ONLY call
1295: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1296: if l_control_rec.called_from_ui = 'N' then
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_header_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_header_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.list_line_id,
1305: x_return_status => l_return_status );
1306:
1307: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1308: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,

1304: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1305: x_return_status => l_return_status );
1306:
1307: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1308: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1309: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1310: x_return_status => l_return_status );
1311: end if;
1312:

Line 1355: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

1351: -- Pricing_Attrs
1352:
1353: PROCEDURE Pricing_Attrs
1354: ( p_validation_level IN NUMBER
1355: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1356: , p_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1357: , p_old_PRICING_ATTR_tbl IN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1358: , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1359: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type

Line 1363: l_control_rec QP_GLOBALS.Control_Rec_Type;

1359: , x_old_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1360: )
1361: IS
1362: l_return_status VARCHAR2(1);
1363: l_control_rec QP_GLOBALS.Control_Rec_Type;
1364: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1365: l_p_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1366: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
1367: l_old_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;

Line 1431: l_control_rec := QP_GLOBALS.Init_Control_Rec

1427:
1428: -- Load API control record
1429: oe_debug_pub.add('before init control rec');
1430:
1431: l_control_rec := QP_GLOBALS.Init_Control_Rec
1432: ( p_operation => l_PRICING_ATTR_rec.operation
1433: , p_control_rec => p_control_rec
1434: );
1435:

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

1438: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1439:
1440: -- Prepare record.
1441:
1442: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1443:
1444: oe_debug_pub.add(' operation is create ');
1445:
1446: l_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;

Line 1453: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE

1449:
1450: l_old_PRICING_ATTR_rec :=
1451: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1452:
1453: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1454: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1455: THEN
1456: oe_debug_pub.add('operation is update');
1457:

Line 1454: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE

1450: l_old_PRICING_ATTR_rec :=
1451: Qp_pll_pricing_attr_Util.Convert_Miss_To_Null (l_old_PRICING_ATTR_rec);
1452:
1453: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1454: OR l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE
1455: THEN
1456: oe_debug_pub.add('operation is update');
1457:
1458: l_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;

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

1517:
1518: END IF;
1519:
1520: -- Attribute level validation.
1521: IF ( l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1522: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1523: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
1524:
1525: IF l_control_rec.default_attributes

Line 1522: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

1518: END IF;
1519:
1520: -- Attribute level validation.
1521: IF ( l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1522: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1523: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
1524:
1525: IF l_control_rec.default_attributes
1526: OR l_control_rec.change_attributes

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

1519:
1520: -- Attribute level validation.
1521: IF ( l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1522: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1523: or l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
1524:
1525: IF l_control_rec.default_attributes
1526: OR l_control_rec.change_attributes
1527: THEN

Line 1579: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

1575:
1576: END IF;
1577:
1578: --Start of code added for Bug 2444971. Added for Patchset H
1579: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
1580: THEN
1581: BEGIN
1582: SELECT h.pte_code, h.source_system_code
1583: INTO l_saved_pte_code, l_saved_source_system_code

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

1625: -- Entity level validation.
1626:
1627: IF l_control_rec.validate_entity THEN
1628:
1629: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1630:
1631: QP_Validate_pll_pricing_attr.Entity_Delete
1632: ( x_return_status => l_return_status
1633: , p_PRICING_ATTR_rec => l_PRICING_ATTR_rec

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

1663: -- Step 4. Write to DB
1664:
1665: IF l_control_rec.write_to_db THEN
1666:
1667: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1668:
1669: Qp_pll_pricing_attr_Util.Delete_Row
1670: ( p_pricing_attribute_id => l_PRICING_ATTR_rec.pricing_attribute_id
1671: );

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

1677: l_PRICING_ATTR_rec.last_update_date := SYSDATE;
1678: l_PRICING_ATTR_rec.last_updated_by := FND_GLOBAL.USER_ID;
1679: l_PRICING_ATTR_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1680:
1681: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1682:
1683: oe_debug_Pub.add('before update row');
1684: Qp_pll_pricing_attr_Util.Update_Row (l_PRICING_ATTR_rec);
1685:

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

1682:
1683: oe_debug_Pub.add('before update row');
1684: Qp_pll_pricing_attr_Util.Update_Row (l_PRICING_ATTR_rec);
1685:
1686: ELSIF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1687:
1688: l_PRICING_ATTR_rec.creation_date := SYSDATE;
1689: l_PRICING_ATTR_rec.created_by := FND_GLOBAL.USER_ID;
1690:

Line 1723: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

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

Line 1728: (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:
1727: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1728: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1729: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1730: x_return_status => l_return_status );
1731: end if;
1732:

Line 1743: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

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

Line 1748: (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:
1747: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1748: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1749: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1750: x_return_status => l_return_status );
1751: end if;
1752:

Line 1773: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE,

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

Line 1778: (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:
1777: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1778: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1779: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1780: x_return_status => l_return_status );
1781: end if;
1782:

Line 1842: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=

1838: ( p_api_version_number IN NUMBER
1839: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1840: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1841: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1842: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1843: QP_GLOBALS.G_MISS_CONTROL_REC
1844: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1845: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1846: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1843: QP_GLOBALS.G_MISS_CONTROL_REC

1839: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1840: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1841: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1842: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1843: QP_GLOBALS.G_MISS_CONTROL_REC
1844: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1845: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1846: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1847: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=

Line 1874: l_control_rec QP_GLOBALS.Control_Rec_Type;

1870: IS
1871: l_api_version_number CONSTANT NUMBER := 1.0;
1872: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
1873: l_return_status VARCHAR2(1);
1874: l_control_rec QP_GLOBALS.Control_Rec_Type;
1875: l_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1876: l_p_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
1877: l_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
1878: l_p_old_PRICE_LIST_rec QP_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

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

1967:
1968: -- Perform PRICE_LIST group requests.
1969:
1970: IF p_control_rec.process AND
1971: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1972: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST)
1973: THEN
1974:
1975: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1972: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST)

1968: -- Perform PRICE_LIST group requests.
1969:
1970: IF p_control_rec.process AND
1971: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1972: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST)
1973: THEN
1974:
1975: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1976: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST

Line 1976: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST

1972: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST)
1973: THEN
1974:
1975: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1976: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST
1977: ,p_delete => FND_API.G_TRUE
1978: ,x_return_status => l_return_status
1979: );
1980: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1994: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE

1990: FOR I IN 1..l_PRICE_LIST_LINE_tbl.COUNT LOOP
1991:
1992: l_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_tbl(I);
1993:
1994: IF l_PRICE_LIST_LINE_rec.operation = QP_GLOBALS.G_OPR_CREATE
1995: AND (l_PRICE_LIST_LINE_rec.list_header_id IS NULL OR
1996: l_PRICE_LIST_LINE_rec.list_header_id = FND_API.G_MISS_NUM)
1997: THEN
1998:

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

2019:
2020: -- Perform PRICE_LIST_LINE group requests.
2021:
2022: IF p_control_rec.process AND
2023: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2024: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE)
2025: THEN
2026:
2027: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 2024: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE)

2020: -- Perform PRICE_LIST_LINE group requests.
2021:
2022: IF p_control_rec.process AND
2023: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2024: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE)
2025: THEN
2026:
2027: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2028: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE

Line 2028: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE

2024: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE)
2025: THEN
2026:
2027: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2028: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE
2029: ,p_delete => FND_API.G_TRUE
2030: ,x_return_status => l_return_status
2031: );
2032: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2046: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE

2042: FOR I IN 1..l_QUALIFIERS_tbl.COUNT LOOP
2043:
2044: l_QUALIFIERS_rec := l_QUALIFIERS_tbl(I);
2045:
2046: IF l_QUALIFIERS_rec.operation = QP_GLOBALS.G_OPR_CREATE
2047: AND (l_QUALIFIERS_rec.list_header_id IS NULL OR
2048: l_QUALIFIERS_rec.list_header_id = FND_API.G_MISS_NUM)
2049: THEN
2050:

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

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

Line 2077: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)

2073: -- Perform QUALIFIERS group requests.
2074:
2075: IF p_control_rec.process AND
2076: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2077: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_QUALIFIERS)
2078: THEN
2079: oe_debug_pub.add('process_Price_List 12');
2080: NULL;
2081:

Line 2091: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE

2087:
2088: oe_debug_pub.add('process_Price_List 13');
2089: l_PRICING_ATTR_rec := l_PRICING_ATTR_tbl(I);
2090:
2091: IF l_PRICING_ATTR_rec.operation = QP_GLOBALS.G_OPR_CREATE
2092: AND (l_PRICING_ATTR_rec.list_line_id IS NULL OR
2093: l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM)
2094: THEN
2095:

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

2149:
2150: -- Perform PRICING_ATTR group requests.
2151:
2152: IF p_control_rec.process AND
2153: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2154: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)
2155: THEN
2156:
2157: NULL;

Line 2154: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)

2150: -- Perform PRICING_ATTR group requests.
2151:
2152: IF p_control_rec.process AND
2153: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2154: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)
2155: THEN
2156:
2157: NULL;
2158:

Line 2164: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

2160:
2161: -- Step 6. Perform Object group logic
2162:
2163: IF p_control_rec.process AND
2164: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2165: THEN
2166:
2167: oe_debug_pub.add('Ren: before processing delayed request');
2168:

Line 2251: AND x_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE

2247:
2248: -- Create blanket header qualifier
2249:
2250: IF ( p_control_rec.write_to_db --Bug#3309455
2251: AND x_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_CREATE
2252: AND x_PRICE_LIST_rec.list_source_code = 'BSO'
2253: AND ( x_PRICE_LIST_rec.orig_system_header_ref <> NULL
2254: OR x_PRICE_LIST_rec.orig_system_header_ref <> FND_API.G_MISS_CHAR)
2255: )

Line 2278: , p_operation => QP_GLOBALS.G_OPR_CREATE

2274: QP_Qualifier_Rules_PVT.Create_Blanket_Qualifier
2275: ( p_list_header_id => x_PRICE_LIST_rec.list_header_id
2276: , p_old_list_header_id => x_PRICE_LIST_rec.list_header_id
2277: , p_blanket_id => to_number(x_PRICE_LIST_rec.orig_system_header_ref)
2278: , p_operation => QP_GLOBALS.G_OPR_CREATE
2279: , x_return_status => l_return_status
2280: );
2281:
2282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2425: SAVEPOINT Lock_Price_List_PVT;
2426:
2427: -- Lock PRICE_LIST
2428:
2429: IF p_PRICE_LIST_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
2430:
2431: QP_Price_List_Util.Lock_Row
2432: ( p_PRICE_LIST_rec => p_PRICE_LIST_rec
2433: , x_PRICE_LIST_rec => x_PRICE_LIST_rec

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

2446: -- Lock PRICE_LIST_LINE
2447:
2448: FOR I IN 1..p_PRICE_LIST_LINE_tbl.COUNT LOOP
2449:
2450: IF p_PRICE_LIST_LINE_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2451:
2452: QP_Price_List_Line_Util.Lock_Row
2453: ( p_PRICE_LIST_LINE_rec => p_PRICE_LIST_LINE_tbl(I)
2454: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec

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

2470: -- Lock QUALIFIERS
2471:
2472: FOR I IN 1..p_QUALIFIERS_tbl.COUNT LOOP
2473:
2474: IF p_QUALIFIERS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2475:
2476: QP_Qualifiers_Util.Lock_Row
2477: ( p_QUALIFIERS_rec => p_QUALIFIERS_tbl(I)
2478: , x_QUALIFIERS_rec => l_QUALIFIERS_rec

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

2495: -- Lock PRICING_ATTR
2496:
2497: FOR I IN 1..p_PRICING_ATTR_tbl.COUNT LOOP
2498:
2499: IF p_PRICING_ATTR_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2500:
2501: Qp_pll_pricing_attr_Util.Lock_Row
2502: ( p_PRICING_ATTR_rec => p_PRICING_ATTR_tbl(I)
2503: , x_PRICING_ATTR_rec => l_PRICING_ATTR_rec