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_ATTRIBUTES_PUB

Line 13: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

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
17: )

Line 14: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type

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
17: )
18: IS

Line 15: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

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
17: )
18: IS
19: l_return_status VARCHAR2(1);

Line 16: , x_old_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

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
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 21: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;

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
25:

Line 22: l_p_CON_rec QP_Attributes_PUB.Con_Rec_Type;

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
25:
26: -- Load API control record

Line 23: l_old_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_old_CON_rec;

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
25:
26: -- Load API control record
27:

Line 255: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type

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
259: )

Line 256: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type

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
259: )
260: IS

Line 257: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type

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
259: )
260: IS
261: l_return_status VARCHAR2(1);

Line 258: , x_old_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type

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
259: )
260: IS
261: l_return_status VARCHAR2(1);
262: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 263: l_SEG_rec QP_Attributes_PUB.Seg_Rec_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;
267: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

Line 264: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

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;
267: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
268: BEGIN

Line 265: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

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;
267: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
268: BEGIN
269:

Line 266: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

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;
267: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
268: BEGIN
269:
270: -- Init local table variables.

Line 267: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_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;
267: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
268: BEGIN
269:
270: -- Init local table variables.
271:

Line 285: l_old_SEG_rec := QP_Attributes_PUB.G_MISS_SEG_REC;

281:
282: IF l_old_SEG_tbl.EXISTS(I) THEN
283: l_old_SEG_rec := l_old_SEG_tbl(I);
284: ELSE
285: l_old_SEG_rec := QP_Attributes_PUB.G_MISS_SEG_REC;
286: END IF;
287:
288: -- Load API control record
289:

Line 569: , p_CON_rec IN QP_Attributes_PUB.Con_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 :=
570: QP_Attributes_PUB.G_MISS_CON_REC
571: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
572: QP_Attributes_PUB.G_MISS_CON_REC
573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=

Line 570: QP_Attributes_PUB.G_MISS_CON_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 :=
570: QP_Attributes_PUB.G_MISS_CON_REC
571: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
572: QP_Attributes_PUB.G_MISS_CON_REC
573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
574: QP_Attributes_PUB.G_MISS_SEG_TBL

Line 571: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=

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 :=
570: QP_Attributes_PUB.G_MISS_CON_REC
571: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
572: QP_Attributes_PUB.G_MISS_CON_REC
573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
574: QP_Attributes_PUB.G_MISS_SEG_TBL
575: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=

Line 572: QP_Attributes_PUB.G_MISS_CON_REC

568: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
569: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
570: QP_Attributes_PUB.G_MISS_CON_REC
571: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
572: QP_Attributes_PUB.G_MISS_CON_REC
573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
574: QP_Attributes_PUB.G_MISS_SEG_TBL
575: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
576: QP_Attributes_PUB.G_MISS_SEG_TBL

Line 573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=

569: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
570: QP_Attributes_PUB.G_MISS_CON_REC
571: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
572: QP_Attributes_PUB.G_MISS_CON_REC
573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
574: QP_Attributes_PUB.G_MISS_SEG_TBL
575: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
576: QP_Attributes_PUB.G_MISS_SEG_TBL
577: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

Line 574: QP_Attributes_PUB.G_MISS_SEG_TBL

570: QP_Attributes_PUB.G_MISS_CON_REC
571: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
572: QP_Attributes_PUB.G_MISS_CON_REC
573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
574: QP_Attributes_PUB.G_MISS_SEG_TBL
575: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
576: QP_Attributes_PUB.G_MISS_SEG_TBL
577: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
578: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type

Line 575: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=

571: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
572: QP_Attributes_PUB.G_MISS_CON_REC
573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
574: QP_Attributes_PUB.G_MISS_SEG_TBL
575: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
576: QP_Attributes_PUB.G_MISS_SEG_TBL
577: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
578: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
579: )

Line 576: QP_Attributes_PUB.G_MISS_SEG_TBL

572: QP_Attributes_PUB.G_MISS_CON_REC
573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
574: QP_Attributes_PUB.G_MISS_SEG_TBL
575: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
576: QP_Attributes_PUB.G_MISS_SEG_TBL
577: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
578: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
579: )
580: IS

Line 577: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

573: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
574: QP_Attributes_PUB.G_MISS_SEG_TBL
575: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
576: QP_Attributes_PUB.G_MISS_SEG_TBL
577: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
578: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
579: )
580: IS
581: l_api_version_number CONSTANT NUMBER := 1.0;

Line 578: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type

574: QP_Attributes_PUB.G_MISS_SEG_TBL
575: , p_old_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
576: QP_Attributes_PUB.G_MISS_SEG_TBL
577: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
578: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
579: )
580: IS
581: l_api_version_number CONSTANT NUMBER := 1.0;
582: l_api_name CONSTANT VARCHAR2(30):= 'Process_Attributes';

Line 585: l_p_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;

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;
589: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

Line 586: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;

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;
589: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

Line 587: l_p_old_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_old_CON_rec;

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;
589: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

Line 588: l_old_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_old_CON_rec;

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;
589: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
592: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

Line 589: l_p_SEG_rec QP_Attributes_PUB.Seg_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;
589: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
592: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
593: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

Line 590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

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;
589: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
592: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
593: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
594: l_p_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

Line 591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

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;
589: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
592: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
593: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
594: l_p_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
595: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

Line 592: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

588: l_old_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_old_CON_rec;
589: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
592: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
593: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
594: l_p_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
595: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
596: BEGIN

Line 593: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

589: l_p_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
592: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
593: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
594: l_p_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
595: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
596: BEGIN
597:

Line 594: l_p_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

590: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
592: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
593: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
594: l_p_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
595: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
596: BEGIN
597:
598: -- Standard call to check for call compatibility

Line 595: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

591: l_p_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
592: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
593: l_old_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
594: l_p_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
595: l_old_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
596: BEGIN
597:
598: -- Standard call to check for call compatibility
599:

Line 807: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=

803: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
804: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
805: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
806: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
807: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
808: QP_Attributes_PUB.G_MISS_CON_REC
809: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
810: QP_Attributes_PUB.G_MISS_SEG_TBL
811: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

Line 808: QP_Attributes_PUB.G_MISS_CON_REC

804: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
805: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
806: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
807: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
808: QP_Attributes_PUB.G_MISS_CON_REC
809: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
810: QP_Attributes_PUB.G_MISS_SEG_TBL
811: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
812: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type

Line 809: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=

805: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
806: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
807: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
808: QP_Attributes_PUB.G_MISS_CON_REC
809: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
810: QP_Attributes_PUB.G_MISS_SEG_TBL
811: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
812: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
813: )

Line 810: QP_Attributes_PUB.G_MISS_SEG_TBL

806: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
807: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
808: QP_Attributes_PUB.G_MISS_CON_REC
809: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
810: QP_Attributes_PUB.G_MISS_SEG_TBL
811: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
812: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
813: )
814: IS

Line 811: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

807: , p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
808: QP_Attributes_PUB.G_MISS_CON_REC
809: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
810: QP_Attributes_PUB.G_MISS_SEG_TBL
811: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
812: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
813: )
814: IS
815: l_api_version_number CONSTANT NUMBER := 1.0;

Line 812: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type

808: QP_Attributes_PUB.G_MISS_CON_REC
809: , p_SEG_tbl IN QP_Attributes_PUB.Seg_Tbl_Type :=
810: QP_Attributes_PUB.G_MISS_SEG_TBL
811: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
812: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
813: )
814: IS
815: l_api_version_number CONSTANT NUMBER := 1.0;
816: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Attributes';

Line 818: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;

814: IS
815: l_api_version_number CONSTANT NUMBER := 1.0;
816: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Attributes';
817: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
818: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
819: BEGIN
820:
821: -- Standard call to check for call compatibility
822:

Line 978: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

974: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
975: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
976: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
977: , p_prc_context_id IN NUMBER
978: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
979: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
980: )
981: IS
982: l_api_version_number CONSTANT NUMBER := 1.0;

Line 979: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type

975: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
976: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
977: , p_prc_context_id IN NUMBER
978: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type
979: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Tbl_Type
980: )
981: IS
982: l_api_version_number CONSTANT NUMBER := 1.0;
983: l_api_name CONSTANT VARCHAR2(30):= 'Get_Attributes';

Line 984: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;

980: )
981: IS
982: l_api_version_number CONSTANT NUMBER := 1.0;
983: l_api_name CONSTANT VARCHAR2(30):= 'Get_Attributes';
984: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;
985: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
986: BEGIN
987:
988: -- Standard call to check for call compatibility

Line 985: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

981: IS
982: l_api_version_number CONSTANT NUMBER := 1.0;
983: l_api_name CONSTANT VARCHAR2(30):= 'Get_Attributes';
984: l_CON_rec QP_Attributes_PUB.Con_Rec_Type;
985: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;
986: BEGIN
987:
988: -- Standard call to check for call compatibility
989: