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_ATTR_MAP_PVT dependencies on QP_ATTR_MAP_PUB

Line 13: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

9:
10: PROCEDURE Pte
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
14: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
16: , x_old_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
17: )

Line 14: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type

10: PROCEDURE Pte
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
14: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
16: , x_old_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
17: )
18: IS

Line 15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
14: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
16: , x_old_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);

Line 16: , x_old_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
14: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
16: , x_old_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 21: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;

17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
22: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
23: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
24: BEGIN
25:

Line 22: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
22: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
23: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
24: BEGIN
25:
26: -- Load API control record

Line 23: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;

19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
22: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
23: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
24: BEGIN
25:
26: -- Load API control record
27:

Line 253: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type

249:
250: PROCEDURE Rqts
251: ( p_validation_level IN NUMBER
252: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
253: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
254: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
255: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
256: , x_old_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
257: )

Line 254: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type

250: PROCEDURE Rqts
251: ( p_validation_level IN NUMBER
252: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
253: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
254: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
255: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
256: , x_old_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
257: )
258: IS

Line 255: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type

251: ( p_validation_level IN NUMBER
252: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
253: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
254: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
255: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
256: , x_old_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
257: )
258: IS
259: l_return_status VARCHAR2(1);

Line 256: , x_old_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type

252: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
253: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
254: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
255: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
256: , x_old_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
257: )
258: IS
259: l_return_status VARCHAR2(1);
260: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 261: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

257: )
258: IS
259: l_return_status VARCHAR2(1);
260: l_control_rec QP_GLOBALS.Control_Rec_Type;
261: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
262: l_p_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
263: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
264: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
265: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 262: l_p_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

258: IS
259: l_return_status VARCHAR2(1);
260: l_control_rec QP_GLOBALS.Control_Rec_Type;
261: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
262: l_p_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
263: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
264: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
265: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
266: BEGIN

Line 263: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

259: l_return_status VARCHAR2(1);
260: l_control_rec QP_GLOBALS.Control_Rec_Type;
261: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
262: l_p_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
263: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
264: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
265: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
266: BEGIN
267:

Line 264: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

260: l_control_rec QP_GLOBALS.Control_Rec_Type;
261: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
262: l_p_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
263: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
264: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
265: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
266: BEGIN
267:
268: -- Init local table variables.

Line 265: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

261: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
262: l_p_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
263: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
264: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
265: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
266: BEGIN
267:
268: -- Init local table variables.
269:

Line 283: l_old_RQT_rec := QP_Attr_Map_PUB.G_MISS_RQT_REC;

279:
280: IF l_old_RQT_tbl.EXISTS(I) THEN
281: l_old_RQT_rec := l_old_RQT_tbl(I);
282: ELSE
283: l_old_RQT_rec := QP_Attr_Map_PUB.G_MISS_RQT_REC;
284: END IF;
285:
286: -- Load API control record
287:

Line 547: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type

543:
544: PROCEDURE Sscs
545: ( p_validation_level IN NUMBER
546: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
547: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
548: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
549: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
550: , x_old_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
551: )

Line 548: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type

544: PROCEDURE Sscs
545: ( p_validation_level IN NUMBER
546: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
547: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
548: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
549: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
550: , x_old_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
551: )
552: IS

Line 549: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type

545: ( p_validation_level IN NUMBER
546: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
547: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
548: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
549: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
550: , x_old_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
551: )
552: IS
553: l_return_status VARCHAR2(1);

Line 550: , x_old_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type

546: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
547: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
548: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
549: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
550: , x_old_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
551: )
552: IS
553: l_return_status VARCHAR2(1);
554: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 555: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

551: )
552: IS
553: l_return_status VARCHAR2(1);
554: l_control_rec QP_GLOBALS.Control_Rec_Type;
555: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
556: l_p_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
557: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
558: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
559: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 556: l_p_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

552: IS
553: l_return_status VARCHAR2(1);
554: l_control_rec QP_GLOBALS.Control_Rec_Type;
555: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
556: l_p_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
557: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
558: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
559: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
560: BEGIN

Line 557: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

553: l_return_status VARCHAR2(1);
554: l_control_rec QP_GLOBALS.Control_Rec_Type;
555: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
556: l_p_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
557: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
558: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
559: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
560: BEGIN
561:

Line 558: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

554: l_control_rec QP_GLOBALS.Control_Rec_Type;
555: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
556: l_p_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
557: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
558: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
559: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
560: BEGIN
561:
562: -- Init local table variables.

Line 559: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

555: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
556: l_p_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
557: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
558: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
559: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
560: BEGIN
561:
562: -- Init local table variables.
563:

Line 577: l_old_SSC_rec := QP_Attr_Map_PUB.G_MISS_SSC_REC;

573:
574: IF l_old_SSC_tbl.EXISTS(I) THEN
575: l_old_SSC_rec := l_old_SSC_tbl(I);
576: ELSE
577: l_old_SSC_rec := QP_Attr_Map_PUB.G_MISS_SSC_REC;
578: END IF;
579:
580: -- Load API control record
581:

Line 840: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type

836:
837: PROCEDURE Psgs
838: ( p_validation_level IN NUMBER
839: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
840: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
841: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
842: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
843: , x_old_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
844: )

Line 841: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type

837: PROCEDURE Psgs
838: ( p_validation_level IN NUMBER
839: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
840: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
841: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
842: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
843: , x_old_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
844: )
845: IS

Line 842: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type

838: ( p_validation_level IN NUMBER
839: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
840: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
841: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
842: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
843: , x_old_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
844: )
845: IS
846: l_return_status VARCHAR2(1);

Line 843: , x_old_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type

839: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
840: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
841: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
842: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
843: , x_old_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
844: )
845: IS
846: l_return_status VARCHAR2(1);
847: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 848: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

844: )
845: IS
846: l_return_status VARCHAR2(1);
847: l_control_rec QP_GLOBALS.Control_Rec_Type;
848: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
849: l_p_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
850: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
851: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
852: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 849: l_p_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

845: IS
846: l_return_status VARCHAR2(1);
847: l_control_rec QP_GLOBALS.Control_Rec_Type;
848: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
849: l_p_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
850: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
851: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
852: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
853: BEGIN

Line 850: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

846: l_return_status VARCHAR2(1);
847: l_control_rec QP_GLOBALS.Control_Rec_Type;
848: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
849: l_p_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
850: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
851: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
852: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
853: BEGIN
854:

Line 851: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

847: l_control_rec QP_GLOBALS.Control_Rec_Type;
848: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
849: l_p_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
850: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
851: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
852: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
853: BEGIN
854:
855: -- Init local table variables.

Line 852: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

848: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
849: l_p_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
850: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
851: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
852: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
853: BEGIN
854:
855: -- Init local table variables.
856:

Line 870: l_old_PSG_rec := QP_Attr_Map_PUB.G_MISS_PSG_REC;

866:
867: IF l_old_PSG_tbl.EXISTS(I) THEN
868: l_old_PSG_rec := l_old_PSG_tbl(I);
869: ELSE
870: l_old_PSG_rec := QP_Attr_Map_PUB.G_MISS_PSG_REC;
871: END IF;
872:
873: -- Load API control record
874:

Line 1133: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type

1129:
1130: PROCEDURE Sous
1131: ( p_validation_level IN NUMBER
1132: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1133: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1134: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1135: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1136: , x_old_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1137: )

Line 1134: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type

1130: PROCEDURE Sous
1131: ( p_validation_level IN NUMBER
1132: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1133: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1134: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1135: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1136: , x_old_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1137: )
1138: IS

Line 1135: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type

1131: ( p_validation_level IN NUMBER
1132: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1133: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1134: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1135: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1136: , x_old_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1137: )
1138: IS
1139: l_return_status VARCHAR2(1);

Line 1136: , x_old_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type

1132: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1133: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1134: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1135: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1136: , x_old_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1137: )
1138: IS
1139: l_return_status VARCHAR2(1);
1140: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 1141: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1137: )
1138: IS
1139: l_return_status VARCHAR2(1);
1140: l_control_rec QP_GLOBALS.Control_Rec_Type;
1141: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1142: l_p_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1143: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1144: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1145: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1142: l_p_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1138: IS
1139: l_return_status VARCHAR2(1);
1140: l_control_rec QP_GLOBALS.Control_Rec_Type;
1141: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1142: l_p_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1143: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1144: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1145: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1146: BEGIN

Line 1143: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1139: l_return_status VARCHAR2(1);
1140: l_control_rec QP_GLOBALS.Control_Rec_Type;
1141: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1142: l_p_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1143: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1144: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1145: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1146: BEGIN
1147:

Line 1144: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1140: l_control_rec QP_GLOBALS.Control_Rec_Type;
1141: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1142: l_p_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1143: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1144: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1145: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1146: BEGIN
1147:
1148: -- Init local table variables.

Line 1145: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1141: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1142: l_p_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1143: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1144: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1145: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1146: BEGIN
1147:
1148: -- Init local table variables.
1149:

Line 1163: l_old_SOU_rec := QP_Attr_Map_PUB.G_MISS_SOU_REC;

1159:
1160: IF l_old_SOU_tbl.EXISTS(I) THEN
1161: l_old_SOU_rec := l_old_SOU_tbl(I);
1162: ELSE
1163: l_old_SOU_rec := QP_Attr_Map_PUB.G_MISS_SOU_REC;
1164: END IF;
1165:
1166: -- Load API control record
1167:

Line 1427: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type

1423:
1424: PROCEDURE Fnas
1425: ( p_validation_level IN NUMBER
1426: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1427: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1428: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1429: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1430: , x_old_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1431: )

Line 1428: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type

1424: PROCEDURE Fnas
1425: ( p_validation_level IN NUMBER
1426: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1427: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1428: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1429: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1430: , x_old_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1431: )
1432: IS

Line 1429: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type

1425: ( p_validation_level IN NUMBER
1426: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1427: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1428: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1429: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1430: , x_old_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1431: )
1432: IS
1433: l_return_status VARCHAR2(1);

Line 1430: , x_old_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type

1426: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1427: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1428: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1429: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1430: , x_old_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1431: )
1432: IS
1433: l_return_status VARCHAR2(1);
1434: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 1435: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1431: )
1432: IS
1433: l_return_status VARCHAR2(1);
1434: l_control_rec QP_GLOBALS.Control_Rec_Type;
1435: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1436: l_p_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1437: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1438: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1439: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1436: l_p_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1432: IS
1433: l_return_status VARCHAR2(1);
1434: l_control_rec QP_GLOBALS.Control_Rec_Type;
1435: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1436: l_p_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1437: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1438: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1439: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1440: l_dummy_ret_status VARCHAR2(1);

Line 1437: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1433: l_return_status VARCHAR2(1);
1434: l_control_rec QP_GLOBALS.Control_Rec_Type;
1435: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1436: l_p_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1437: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1438: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1439: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1440: l_dummy_ret_status VARCHAR2(1);
1441: BEGIN

Line 1438: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1434: l_control_rec QP_GLOBALS.Control_Rec_Type;
1435: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1436: l_p_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1437: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1438: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1439: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1440: l_dummy_ret_status VARCHAR2(1);
1441: BEGIN
1442:

Line 1439: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1435: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1436: l_p_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1437: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1438: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1439: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1440: l_dummy_ret_status VARCHAR2(1);
1441: BEGIN
1442:
1443: -- Init local table variables.

Line 1457: l_old_FNA_rec := QP_Attr_Map_PUB.G_MISS_FNA_REC;

1453:
1454: IF l_old_FNA_tbl.EXISTS(I) THEN
1455: l_old_FNA_rec := l_old_FNA_tbl(I);
1456: ELSE
1457: l_old_FNA_rec := QP_Attr_Map_PUB.G_MISS_FNA_REC;
1458: END IF;
1459:
1460: -- Load API control record
1461:

Line 1777: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=

1773: QP_GLOBALS.G_MISS_CONTROL_REC
1774: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1775: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1776: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1777: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1778: QP_Attr_Map_PUB.G_MISS_PTE_REC
1779: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1780: QP_Attr_Map_PUB.G_MISS_PTE_REC
1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=

Line 1778: QP_Attr_Map_PUB.G_MISS_PTE_REC

1774: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1775: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1776: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1777: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1778: QP_Attr_Map_PUB.G_MISS_PTE_REC
1779: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1780: QP_Attr_Map_PUB.G_MISS_PTE_REC
1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL

Line 1779: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=

1775: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1776: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1777: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1778: QP_Attr_Map_PUB.G_MISS_PTE_REC
1779: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1780: QP_Attr_Map_PUB.G_MISS_PTE_REC
1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=

Line 1780: QP_Attr_Map_PUB.G_MISS_PTE_REC

1776: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1777: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1778: QP_Attr_Map_PUB.G_MISS_PTE_REC
1779: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1780: QP_Attr_Map_PUB.G_MISS_PTE_REC
1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL

Line 1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=

1777: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1778: QP_Attr_Map_PUB.G_MISS_PTE_REC
1779: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1780: QP_Attr_Map_PUB.G_MISS_PTE_REC
1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=

Line 1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL

1778: QP_Attr_Map_PUB.G_MISS_PTE_REC
1779: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1780: QP_Attr_Map_PUB.G_MISS_PTE_REC
1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL

Line 1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=

1779: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
1780: QP_Attr_Map_PUB.G_MISS_PTE_REC
1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=

Line 1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL

1780: QP_Attr_Map_PUB.G_MISS_PTE_REC
1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL

Line 1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=

1781: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=

Line 1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL

1782: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL

Line 1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=

1783: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=

Line 1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL

1784: QP_Attr_Map_PUB.G_MISS_RQT_TBL
1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL

Line 1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=

1785: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=

Line 1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL

1786: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL

Line 1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=

1787: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=

Line 1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL

1788: QP_Attr_Map_PUB.G_MISS_SSC_TBL
1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL

Line 1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=

1789: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=

Line 1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL

1790: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL

Line 1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=

1791: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=

Line 1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL

1792: QP_Attr_Map_PUB.G_MISS_PSG_TBL
1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL

Line 1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=

1793: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

Line 1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL

1794: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type

Line 1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=

1795: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
1803: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type

Line 1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL

1796: QP_Attr_Map_PUB.G_MISS_SOU_TBL
1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
1803: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
1804: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type

Line 1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

1797: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
1803: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
1804: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
1805: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type

Line 1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type

1798: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
1803: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
1804: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
1805: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1806: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type

Line 1803: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type

1799: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
1803: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
1804: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
1805: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1806: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1807: )

Line 1804: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type

1800: QP_Attr_Map_PUB.G_MISS_FNA_TBL
1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
1803: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
1804: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
1805: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1806: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1807: )
1808: IS

Line 1805: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type

1801: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
1803: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
1804: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
1805: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1806: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1807: )
1808: IS
1809: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1806: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type

1802: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
1803: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
1804: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
1805: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1806: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1807: )
1808: IS
1809: l_api_version_number CONSTANT NUMBER := 1.0;
1810: l_api_name CONSTANT VARCHAR2(30):= 'Process_Attr_Mapping';

Line 1813: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;

1809: l_api_version_number CONSTANT NUMBER := 1.0;
1810: l_api_name CONSTANT VARCHAR2(30):= 'Process_Attr_Mapping';
1811: l_return_status VARCHAR2(1);
1812: l_control_rec QP_GLOBALS.Control_Rec_Type;
1813: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1814: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1815: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 1814: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;

1810: l_api_name CONSTANT VARCHAR2(30):= 'Process_Attr_Mapping';
1811: l_return_status VARCHAR2(1);
1812: l_control_rec QP_GLOBALS.Control_Rec_Type;
1813: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1814: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1815: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1815: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;

1811: l_return_status VARCHAR2(1);
1812: l_control_rec QP_GLOBALS.Control_Rec_Type;
1813: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1814: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1815: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;

1812: l_control_rec QP_GLOBALS.Control_Rec_Type;
1813: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1814: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1815: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1813: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1814: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1815: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1814: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1815: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1815: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1817: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1818: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1819: l_p_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1820: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1821: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1822: l_p_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1823: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1824: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1825: l_p_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1826: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1827: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1828: l_p_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1829: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1830: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1831: l_p_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1832: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1833: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1834: l_p_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1835: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1843: l_p_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1836: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1843: l_p_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1844: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1837: l_p_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1843: l_p_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1844: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1845: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1838: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1843: l_p_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1844: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1845: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1846: l_p_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1843: l_p_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1839: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1843: l_p_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1844: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1845: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1846: l_p_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1847: BEGIN

Line 1844: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1840: l_p_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1843: l_p_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1844: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1845: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1846: l_p_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1847: BEGIN
1848: oe_debug_pub.add('Entered process_attr_mapping.........................');

Line 1845: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1841: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1843: l_p_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1844: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1845: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1846: l_p_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1847: BEGIN
1848: oe_debug_pub.add('Entered process_attr_mapping.........................');
1849:

Line 1846: l_p_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1842: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1843: l_p_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1844: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1845: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1846: l_p_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1847: BEGIN
1848: oe_debug_pub.add('Entered process_attr_mapping.........................');
1849:
1850: -- Standard call to check for call compatibility

Line 2335: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=

2331: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2332: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2333: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2334: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2335: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
2336: QP_Attr_Map_PUB.G_MISS_PTE_REC
2337: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
2338: QP_Attr_Map_PUB.G_MISS_RQT_TBL
2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=

Line 2336: QP_Attr_Map_PUB.G_MISS_PTE_REC

2332: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2333: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2334: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2335: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
2336: QP_Attr_Map_PUB.G_MISS_PTE_REC
2337: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
2338: QP_Attr_Map_PUB.G_MISS_RQT_TBL
2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL

Line 2337: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=

2333: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2334: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2335: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
2336: QP_Attr_Map_PUB.G_MISS_PTE_REC
2337: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
2338: QP_Attr_Map_PUB.G_MISS_RQT_TBL
2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL
2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=

Line 2338: QP_Attr_Map_PUB.G_MISS_RQT_TBL

2334: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2335: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
2336: QP_Attr_Map_PUB.G_MISS_PTE_REC
2337: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
2338: QP_Attr_Map_PUB.G_MISS_RQT_TBL
2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL
2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL

Line 2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=

2335: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
2336: QP_Attr_Map_PUB.G_MISS_PTE_REC
2337: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
2338: QP_Attr_Map_PUB.G_MISS_RQT_TBL
2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL
2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL
2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=

Line 2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL

2336: QP_Attr_Map_PUB.G_MISS_PTE_REC
2337: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
2338: QP_Attr_Map_PUB.G_MISS_RQT_TBL
2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL
2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL
2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL

Line 2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=

2337: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
2338: QP_Attr_Map_PUB.G_MISS_RQT_TBL
2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL
2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL
2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL
2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=

Line 2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL

2338: QP_Attr_Map_PUB.G_MISS_RQT_TBL
2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL
2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL
2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL
2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL

Line 2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=

2339: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL
2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL
2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL
2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL
2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

Line 2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL

2340: QP_Attr_Map_PUB.G_MISS_SSC_TBL
2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL
2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL
2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL
2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type

Line 2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=

2341: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL
2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL
2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL
2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2349: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type

Line 2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL

2342: QP_Attr_Map_PUB.G_MISS_PSG_TBL
2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL
2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL
2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2349: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2350: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type

Line 2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

2343: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL
2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL
2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2349: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2350: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2351: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type

Line 2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type

2344: QP_Attr_Map_PUB.G_MISS_SOU_TBL
2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL
2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2349: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2350: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2351: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2352: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type

Line 2349: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type

2345: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL
2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2349: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2350: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2351: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2352: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
2353: )

Line 2350: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type

2346: QP_Attr_Map_PUB.G_MISS_FNA_TBL
2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2349: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2350: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2351: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2352: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
2353: )
2354: IS

Line 2351: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type

2347: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2349: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2350: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2351: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2352: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
2353: )
2354: IS
2355: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2352: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type

2348: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2349: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2350: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2351: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2352: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
2353: )
2354: IS
2355: l_api_version_number CONSTANT NUMBER := 1.0;
2356: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Attr_Mapping';

Line 2358: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

2354: IS
2355: l_api_version_number CONSTANT NUMBER := 1.0;
2356: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Attr_Mapping';
2357: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2358: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
2359: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
2360: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
2361: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
2362: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 2359: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

2355: l_api_version_number CONSTANT NUMBER := 1.0;
2356: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Attr_Mapping';
2357: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2358: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
2359: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
2360: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
2361: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
2362: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
2363: BEGIN

Line 2360: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

2356: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Attr_Mapping';
2357: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2358: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
2359: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
2360: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
2361: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
2362: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
2363: BEGIN
2364:

Line 2361: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

2357: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2358: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
2359: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
2360: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
2361: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
2362: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
2363: BEGIN
2364:
2365: -- Standard call to check for call compatibility

Line 2362: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

2358: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
2359: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
2360: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
2361: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
2362: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
2363: BEGIN
2364:
2365: -- Standard call to check for call compatibility
2366:

Line 2618: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

2614: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2615: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2616: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2617: , p_lookup_code IN VARCHAR2
2618: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2619: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2620: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2621: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2622: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type

Line 2619: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type

2615: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2616: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2617: , p_lookup_code IN VARCHAR2
2618: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2619: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2620: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2621: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2622: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2623: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type

Line 2620: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type

2616: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2617: , p_lookup_code IN VARCHAR2
2618: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2619: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2620: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2621: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2622: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2623: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
2624: )

Line 2621: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type

2617: , p_lookup_code IN VARCHAR2
2618: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2619: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2620: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2621: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2622: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2623: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
2624: )
2625: IS

Line 2622: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type

2618: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
2619: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2620: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2621: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2622: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2623: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
2624: )
2625: IS
2626: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2623: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type

2619: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
2620: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
2621: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
2622: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
2623: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
2624: )
2625: IS
2626: l_api_version_number CONSTANT NUMBER := 1.0;
2627: l_api_name CONSTANT VARCHAR2(30):= 'Get_Attr_Mapping';

Line 2628: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

2624: )
2625: IS
2626: l_api_version_number CONSTANT NUMBER := 1.0;
2627: l_api_name CONSTANT VARCHAR2(30):= 'Get_Attr_Mapping';
2628: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
2629: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
2630: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
2631: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
2632: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 2629: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

2625: IS
2626: l_api_version_number CONSTANT NUMBER := 1.0;
2627: l_api_name CONSTANT VARCHAR2(30):= 'Get_Attr_Mapping';
2628: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
2629: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
2630: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
2631: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
2632: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2633: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 2630: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

2626: l_api_version_number CONSTANT NUMBER := 1.0;
2627: l_api_name CONSTANT VARCHAR2(30):= 'Get_Attr_Mapping';
2628: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
2629: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
2630: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
2631: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
2632: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2633: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2634: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 2631: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

2627: l_api_name CONSTANT VARCHAR2(30):= 'Get_Attr_Mapping';
2628: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
2629: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
2630: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
2631: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
2632: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2633: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2634: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
2635: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 2632: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

2628: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
2629: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
2630: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
2631: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
2632: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2633: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2634: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
2635: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
2636: BEGIN

Line 2633: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

2629: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
2630: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
2631: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
2632: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2633: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2634: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
2635: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
2636: BEGIN
2637:

Line 2634: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

2630: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
2631: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
2632: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2633: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2634: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
2635: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
2636: BEGIN
2637:
2638: -- Standard call to check for call compatibility

Line 2635: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

2631: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
2632: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2633: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
2634: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
2635: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
2636: BEGIN
2637:
2638: -- Standard call to check for call compatibility
2639: