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_ATTRIBUTES_PVT dependencies on QP_GLOBALS

Line 12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

8: -- Con
9:
10: PROCEDURE Con
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
14: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
15: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
16: , x_old_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

Line 20: l_control_rec QP_GLOBALS.Control_Rec_Type;

16: , x_old_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
22: l_p_CON_rec QP_Attributes_PUB.Con_Rec_Type;
23: l_old_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_old_CON_rec;
24: BEGIN

Line 28: l_control_rec := QP_GLOBALS.Init_Control_Rec

24: BEGIN
25:
26: -- Load API control record
27:
28: l_control_rec := QP_GLOBALS.Init_Control_Rec
29: ( p_operation => l_CON_rec.operation
30: , p_control_rec => p_control_rec
31: );
32:

Line 39: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

35: l_CON_rec.return_status := FND_API.G_RET_STS_SUCCESS;
36:
37: -- Prepare record.
38:
39: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
40:
41: l_CON_rec.db_flag := FND_API.G_FALSE;
42:
43: -- Set missing old record elements to NULL.

Line 48: ELSIF l_CON_rec.operation = QP_GLOBALS.G_OPR_UPDATE

44:
45: l_old_CON_rec :=
46: QP_Con_Util.Convert_Miss_To_Null (l_old_CON_rec);
47:
48: ELSIF l_CON_rec.operation = QP_GLOBALS.G_OPR_UPDATE
49: OR l_CON_rec.operation = QP_GLOBALS.G_OPR_DELETE
50: THEN
51:
52: l_CON_rec.db_flag := FND_API.G_TRUE;

Line 49: OR l_CON_rec.operation = QP_GLOBALS.G_OPR_DELETE

45: l_old_CON_rec :=
46: QP_Con_Util.Convert_Miss_To_Null (l_old_CON_rec);
47:
48: ELSIF l_CON_rec.operation = QP_GLOBALS.G_OPR_UPDATE
49: OR l_CON_rec.operation = QP_GLOBALS.G_OPR_DELETE
50: THEN
51:
52: l_CON_rec.db_flag := FND_API.G_TRUE;
53:

Line 150: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

146: -- Entity level validation.
147:
148: IF l_control_rec.validate_entity THEN
149:
150: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
151:
152: QP_Validate_Con.Entity_Delete
153: ( x_return_status => l_return_status
154: , p_CON_rec => l_CON_rec

Line 179: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

175: -- Step 4. Write to DB
176:
177: IF l_control_rec.write_to_db THEN
178:
179: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
180:
181: QP_Con_Util.Delete_Row
182: ( p_prc_context_id => l_CON_rec.prc_context_id
183: );

Line 193: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

189: l_CON_rec.last_update_date := SYSDATE;
190: l_CON_rec.last_updated_by := FND_GLOBAL.USER_ID;
191: l_CON_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
192:
193: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
194:
195: QP_Con_Util.Update_Row (l_CON_rec);
196:
197: ELSIF l_CON_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 197: ELSIF l_CON_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

193: IF l_CON_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
194:
195: QP_Con_Util.Update_Row (l_CON_rec);
196:
197: ELSIF l_CON_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
198:
199: l_CON_rec.creation_date := SYSDATE;
200: l_CON_rec.created_by := FND_GLOBAL.USER_ID;
201:

Line 254: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

250: -- Segs
251:
252: PROCEDURE Segs
253: ( p_validation_level IN NUMBER
254: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
255: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type
256: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type
257: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
258: , x_old_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type

Line 262: l_control_rec QP_GLOBALS.Control_Rec_Type;

258: , x_old_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
259: )
260: IS
261: l_return_status VARCHAR2(1);
262: l_control_rec QP_GLOBALS.Control_Rec_Type;
263: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
264: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
265: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
266: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

Line 290: l_control_rec := QP_GLOBALS.Init_Control_Rec

286: END IF;
287:
288: -- Load API control record
289:
290: l_control_rec := QP_GLOBALS.Init_Control_Rec
291: ( p_operation => l_SEG_rec.operation
292: , p_control_rec => p_control_rec
293: );
294:

Line 301: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

297: l_SEG_rec.return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: -- Prepare record.
300:
301: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
302:
303: l_SEG_rec.db_flag := FND_API.G_FALSE;
304:
305: -- Set missing old record elements to NULL.

Line 310: ELSIF l_SEG_rec.operation = QP_GLOBALS.G_OPR_UPDATE

306:
307: l_old_SEG_rec :=
308: QP_Seg_Util.Convert_Miss_To_Null (l_old_SEG_rec);
309:
310: ELSIF l_SEG_rec.operation = QP_GLOBALS.G_OPR_UPDATE
311: OR l_SEG_rec.operation = QP_GLOBALS.G_OPR_DELETE
312: THEN
313:
314: l_SEG_rec.db_flag := FND_API.G_TRUE;

Line 311: OR l_SEG_rec.operation = QP_GLOBALS.G_OPR_DELETE

307: l_old_SEG_rec :=
308: QP_Seg_Util.Convert_Miss_To_Null (l_old_SEG_rec);
309:
310: ELSIF l_SEG_rec.operation = QP_GLOBALS.G_OPR_UPDATE
311: OR l_SEG_rec.operation = QP_GLOBALS.G_OPR_DELETE
312: THEN
313:
314: l_SEG_rec.db_flag := FND_API.G_TRUE;
315:

Line 410: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

406: -- Entity level validation.
407:
408: IF l_control_rec.validate_entity THEN
409:
410: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
411:
412: QP_Validate_Seg.Entity_Delete
413: ( x_return_status => l_return_status
414: , p_SEG_rec => l_SEG_rec

Line 439: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

435: -- Step 4. Write to DB
436:
437: IF l_control_rec.write_to_db THEN
438:
439: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
440:
441: QP_Seg_Util.Delete_Row
442: ( p_segment_id => l_SEG_rec.segment_id
443: );

Line 453: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

449: l_SEG_rec.last_update_date := SYSDATE;
450: l_SEG_rec.last_updated_by := FND_GLOBAL.USER_ID;
451: l_SEG_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
452:
453: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
454:
455: QP_Seg_Util.Update_Row (l_SEG_rec);
456:
457: ELSIF l_SEG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 457: ELSIF l_SEG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

453: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
454:
455: QP_Seg_Util.Update_Row (l_SEG_rec);
456:
457: ELSIF l_SEG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
458:
459: l_SEG_rec.creation_date := SYSDATE;
460: l_SEG_rec.created_by := FND_GLOBAL.USER_ID;
461:

Line 564: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=

560: ( p_api_version_number IN NUMBER
561: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
562: , p_commit IN VARCHAR2 := FND_API.G_FALSE
563: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
564: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
565: QP_GLOBALS.G_MISS_CONTROL_REC
566: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
567: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
568: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 565: QP_GLOBALS.G_MISS_CONTROL_REC

561: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
562: , p_commit IN VARCHAR2 := FND_API.G_FALSE
563: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
564: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
565: QP_GLOBALS.G_MISS_CONTROL_REC
566: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
567: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
568: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
569: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=

Line 584: l_control_rec QP_GLOBALS.Control_Rec_Type;

580: IS
581: l_api_version_number CONSTANT NUMBER := 1.0;
582: l_api_name CONSTANT VARCHAR2(30):= 'Process_Attributes';
583: l_return_status VARCHAR2(1);
584: l_control_rec QP_GLOBALS.Control_Rec_Type;
585: l_p_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
586: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
587: l_p_old_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_old_CON_rec;
588: l_old_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_old_CON_rec;

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

631:
632: -- Perform CON group requests.
633:
634: IF p_control_rec.process AND
635: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
636: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CON)
637: THEN
638:
639: NULL;

Line 636: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CON)

632: -- Perform CON group requests.
633:
634: IF p_control_rec.process AND
635: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
636: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CON)
637: THEN
638:
639: NULL;
640:

Line 649: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_CREATE

645: FOR I IN 1..l_SEG_tbl.COUNT LOOP
646:
647: l_SEG_rec := l_SEG_tbl(I);
648:
649: IF l_SEG_rec.operation = QP_GLOBALS.G_OPR_CREATE
650: AND (l_SEG_rec.prc_context_id IS NULL OR
651: l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM)
652: THEN
653:

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

673:
674: -- Perform SEG group requests.
675:
676: IF p_control_rec.process AND
677: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
678: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_SEG)
679: THEN
680:
681: NULL;

Line 678: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_SEG)

674: -- Perform SEG group requests.
675:
676: IF p_control_rec.process AND
677: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
678: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_SEG)
679: THEN
680:
681: NULL;
682:

Line 688: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

684:
685: -- Step 6. Perform Object group logic
686:
687: IF p_control_rec.process AND
688: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
689: THEN
690:
691: NULL;
692:

Line 845: IF p_CON_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN

841: SAVEPOINT Lock_Attributes_PVT;
842:
843: -- Lock CON
844:
845: IF p_CON_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
846:
847: QP_Con_Util.Lock_Row
848: ( p_CON_rec => p_CON_rec
849: , x_CON_rec => x_CON_rec

Line 866: IF p_SEG_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

862: -- Lock SEG
863:
864: FOR I IN 1..p_SEG_tbl.COUNT LOOP
865:
866: IF p_SEG_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
867:
868: QP_Seg_Util.Lock_Row
869: ( p_SEG_rec => p_SEG_tbl(I)
870: , x_SEG_rec => l_SEG_rec