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_PRICE_LIST_PVT dependencies on OE_GLOBALS

Line 32: , p_control_rec IN OE_GLOBALS.Control_Rec_Type

28: -- Price_List
29:
30: PROCEDURE Price_List
31: ( p_validation_level IN NUMBER
32: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
33: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
34: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
35: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
36: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

Line 40: l_control_rec OE_GLOBALS.Control_Rec_Type;

36: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
37: )
38: IS
39: l_return_status VARCHAR2(1);
40: l_control_rec OE_GLOBALS.Control_Rec_Type;
41: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
42: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
43: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
44: BEGIN

Line 48: l_control_rec := OE_GLOBALS.Init_Control_Rec

44: BEGIN
45:
46: -- Load API control record
47:
48: l_control_rec := OE_GLOBALS.Init_Control_Rec
49: ( p_operation => l_PRICE_LIST_rec.operation
50: , p_control_rec => p_control_rec
51: );
52:

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

55: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: -- Prepare record.
58:
59: IF l_PRICE_LIST_rec.operation = OE_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 = OE_GLOBALS.G_OPR_UPDATE

64:
65: l_old_PRICE_LIST_rec :=
66: OE_Price_List_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_rec);
67:
68: ELSIF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE
69: OR l_PRICE_LIST_rec.operation = OE_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 = OE_GLOBALS.G_OPR_DELETE

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

Line 170: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

166: -- Entity level validation.
167:
168: IF l_control_rec.validate_entity THEN
169:
170: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
171:
172: OE_Validate_Price_List.Entity_Delete
173: ( x_return_status => l_return_status
174: , p_PRICE_LIST_rec => l_PRICE_LIST_rec

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

195: -- Step 4. Write to DB
196:
197: IF l_control_rec.write_to_db THEN
198:
199: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
200:
201: OE_Price_List_Util.Delete_Row
202: ( p_name => l_PRICE_LIST_rec.name
203: , p_price_list_id => l_PRICE_LIST_rec.price_list_id

Line 214: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

210: l_PRICE_LIST_rec.last_update_date := SYSDATE;
211: l_PRICE_LIST_rec.last_updated_by := FND_GLOBAL.USER_ID;
212: l_PRICE_LIST_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
213:
214: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
215:
216: OE_Price_List_Util.Update_Row (l_PRICE_LIST_rec);
217:
218: ELSIF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

Line 218: ELSIF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

214: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
215:
216: OE_Price_List_Util.Update_Row (l_PRICE_LIST_rec);
217:
218: ELSIF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
219:
220: l_PRICE_LIST_rec.creation_date := SYSDATE;
221: l_PRICE_LIST_rec.created_by := FND_GLOBAL.USER_ID;
222:

Line 275: , p_control_rec IN OE_GLOBALS.Control_Rec_Type

271: -- Price_List_Lines
272:
273: PROCEDURE Price_List_Lines
274: ( p_validation_level IN NUMBER
275: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
276: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
277: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
278: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
279: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

Line 283: l_control_rec OE_GLOBALS.Control_Rec_Type;

279: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
280: )
281: IS
282: l_return_status VARCHAR2(1);
283: l_control_rec OE_GLOBALS.Control_Rec_Type;
284: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
285: l_p_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
286: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
287: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

Line 311: l_control_rec := OE_GLOBALS.Init_Control_Rec

307: END IF;
308:
309: -- Load API control record
310:
311: l_control_rec := OE_GLOBALS.Init_Control_Rec
312: ( p_operation => l_PRICE_LIST_LINE_rec.operation
313: , p_control_rec => p_control_rec
314: );
315:

Line 322: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

318: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: -- Prepare record.
321:
322: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
323:
324: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_FALSE;
325:
326: -- Set missing old record elements to NULL.

Line 331: ELSIF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE

327:
328: l_old_PRICE_LIST_LINE_rec :=
329: OE_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);
330:
331: ELSIF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE
332: OR l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE
333: THEN
334:
335: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;

Line 332: OR l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE

328: l_old_PRICE_LIST_LINE_rec :=
329: OE_Price_List_Line_Util.Convert_Miss_To_Null (l_old_PRICE_LIST_LINE_rec);
330:
331: ELSIF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE
332: OR l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE
333: THEN
334:
335: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;
336:

Line 432: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

428: -- Entity level validation.
429:
430: IF l_control_rec.validate_entity THEN
431:
432: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
433:
434: OE_Validate_Price_List_Line.Entity_Delete
435: ( x_return_status => l_return_status
436: , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec

Line 461: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

457: -- Step 4. Write to DB
458:
459: IF l_control_rec.write_to_db THEN
460:
461: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
462:
463: OE_Price_List_Line_Util.Delete_Row
464: ( p_price_list_line_id => l_PRICE_LIST_LINE_rec.price_list_line_id
465: );

Line 475: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

471: l_PRICE_LIST_LINE_rec.last_update_date := SYSDATE;
472: l_PRICE_LIST_LINE_rec.last_updated_by := FND_GLOBAL.USER_ID;
473: l_PRICE_LIST_LINE_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
474:
475: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
476:
477: OE_Price_List_Line_Util.Update_Row (l_PRICE_LIST_LINE_rec);
478:
479: ELSIF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

Line 479: ELSIF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

475: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
476:
477: OE_Price_List_Line_Util.Update_Row (l_PRICE_LIST_LINE_rec);
478:
479: ELSIF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
480:
481: l_PRICE_LIST_LINE_rec.creation_date := SYSDATE;
482: l_PRICE_LIST_LINE_rec.created_by := FND_GLOBAL.USER_ID;
483:

Line 586: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=

582: ( p_api_version_number IN NUMBER
583: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
584: , p_commit IN VARCHAR2 := FND_API.G_FALSE
585: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
586: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
587: OE_GLOBALS.G_MISS_CONTROL_REC
588: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
589: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
590: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 587: OE_GLOBALS.G_MISS_CONTROL_REC

583: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
584: , p_commit IN VARCHAR2 := FND_API.G_FALSE
585: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
586: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
587: OE_GLOBALS.G_MISS_CONTROL_REC
588: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
589: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
590: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
591: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

Line 606: l_control_rec OE_GLOBALS.Control_Rec_Type;

602: IS
603: l_api_version_number CONSTANT NUMBER := 1.0;
604: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
605: l_return_status VARCHAR2(1);
606: l_control_rec OE_GLOBALS.Control_Rec_Type;
607: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
608: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
609: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

Line 657: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

653:
654: -- Perform PRICE_LIST group requests.
655:
656: IF p_control_rec.process AND
657: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
658: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LHEADER)
659: THEN
660:
661: NULL;

Line 658: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LHEADER)

654: -- Perform PRICE_LIST group requests.
655:
656: IF p_control_rec.process AND
657: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
658: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LHEADER)
659: THEN
660:
661: NULL;
662:

Line 671: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE

667: FOR I IN 1..l_PRICE_LIST_LINE_tbl.COUNT LOOP
668:
669: l_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_tbl(I);
670:
671: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE
672: -- AND (l_PRICE_LIST_LINE_rec.name IS NULL OR
673: -- l_PRICE_LIST_LINE_rec.name = FND_API.G_MISS_CHAR)
674: AND (l_PRICE_LIST_LINE_rec.price_list_id IS NULL OR
675: l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM)

Line 700: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR

696:
697: -- Perform PRICE_LIST_LINE group requests.
698:
699: IF p_control_rec.process AND
700: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
701: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LLINE)
702: THEN
703:
704: NULL;

Line 701: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LLINE)

697: -- Perform PRICE_LIST_LINE group requests.
698:
699: IF p_control_rec.process AND
700: (p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL OR
701: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_PRICE_LLINE)
702: THEN
703:
704: NULL;
705:

Line 711: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL

707:
708: -- Step 6. Perform Object group logic
709:
710: IF p_control_rec.process AND
711: p_control_rec.process_entity = OE_GLOBALS.G_ENTITY_ALL
712: THEN
713:
714: NULL;
715:

Line 868: IF p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN

864: SAVEPOINT Lock_Price_List_PVT;
865:
866: -- Lock PRICE_LIST
867:
868: IF p_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_LOCK THEN
869:
870: OE_Price_List_Util.Lock_Row
871: ( p_PRICE_LIST_rec => p_PRICE_LIST_rec
872: , x_PRICE_LIST_rec => x_PRICE_LIST_rec

Line 889: IF p_PRICE_LIST_LINE_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN

885: -- Lock PRICE_LIST_LINE
886:
887: FOR I IN 1..p_PRICE_LIST_LINE_tbl.COUNT LOOP
888:
889: IF p_PRICE_LIST_LINE_tbl(I).operation = OE_GLOBALS.G_OPR_LOCK THEN
890:
891: OE_Price_List_Line_Util.Lock_Row
892: ( p_PRICE_LIST_LINE_rec => p_PRICE_LIST_LINE_tbl(I)
893: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec