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_LIMITS_PVT dependencies on QP_LIMITS_PUB

Line 13: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

9:
10: PROCEDURE Limits
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
14: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
15: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
16: , x_old_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
17: )

Line 14: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type

10: PROCEDURE Limits
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
14: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
15: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
16: , x_old_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
17: )
18: IS

Line 15: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
14: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
15: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
16: , x_old_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);

Line 16: , x_old_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
14: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type
15: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
16: , x_old_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 21: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;

17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
22: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;
23:
24: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
25:

Line 22: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;

18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
22: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;
23:
24: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
25:
26: BEGIN

Line 24: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]

20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
22: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;
23:
24: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
25:
26: BEGIN
27:
28: -- Load API control record

Line 312: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type

308:
309: PROCEDURE Limit_Attrss
310: ( p_validation_level IN NUMBER
311: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
312: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type
313: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type
314: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
315: , x_old_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
316: )

Line 313: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type

309: PROCEDURE Limit_Attrss
310: ( p_validation_level IN NUMBER
311: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
312: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type
313: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type
314: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
315: , x_old_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
316: )
317: IS

Line 314: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type

310: ( p_validation_level IN NUMBER
311: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
312: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type
313: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type
314: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
315: , x_old_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
316: )
317: IS
318: l_return_status VARCHAR2(1);

Line 315: , x_old_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type

311: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
312: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type
313: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type
314: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
315: , x_old_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
316: )
317: IS
318: l_return_status VARCHAR2(1);
319: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 320: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

316: )
317: IS
318: l_return_status VARCHAR2(1);
319: l_control_rec QP_GLOBALS.Control_Rec_Type;
320: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
321: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
322: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
323: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
324:

Line 321: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

317: IS
318: l_return_status VARCHAR2(1);
319: l_control_rec QP_GLOBALS.Control_Rec_Type;
320: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
321: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
322: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
323: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
324:
325: l_p_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type; --[prarasto]

Line 322: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

318: l_return_status VARCHAR2(1);
319: l_control_rec QP_GLOBALS.Control_Rec_Type;
320: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
321: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
322: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
323: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
324:
325: l_p_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type; --[prarasto]
326: BEGIN

Line 323: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

319: l_control_rec QP_GLOBALS.Control_Rec_Type;
320: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
321: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
322: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
323: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
324:
325: l_p_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type; --[prarasto]
326: BEGIN
327:

Line 325: l_p_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type; --[prarasto]

321: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
322: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
323: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
324:
325: l_p_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type; --[prarasto]
326: BEGIN
327:
328: -- Init local table variables.
329:

Line 343: l_old_LIMIT_ATTRS_rec := QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC;

339:
340: IF l_old_LIMIT_ATTRS_tbl.EXISTS(I) THEN
341: l_old_LIMIT_ATTRS_rec := l_old_LIMIT_ATTRS_tbl(I);
342: ELSE
343: l_old_LIMIT_ATTRS_rec := QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC;
344: END IF;
345:
346: -- Load API control record
347:

Line 667: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type

663:
664: PROCEDURE Limit_Balancess
665: ( p_validation_level IN NUMBER
666: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
667: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type
668: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type
669: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
670: , x_old_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
671: )

Line 668: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type

664: PROCEDURE Limit_Balancess
665: ( p_validation_level IN NUMBER
666: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
667: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type
668: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type
669: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
670: , x_old_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
671: )
672: IS

Line 669: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type

665: ( p_validation_level IN NUMBER
666: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
667: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type
668: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type
669: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
670: , x_old_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
671: )
672: IS
673: l_return_status VARCHAR2(1);

Line 670: , x_old_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type

666: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
667: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type
668: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type
669: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
670: , x_old_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
671: )
672: IS
673: l_return_status VARCHAR2(1);
674: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 675: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

671: )
672: IS
673: l_return_status VARCHAR2(1);
674: l_control_rec QP_GLOBALS.Control_Rec_Type;
675: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
676: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
677: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
678: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
679:

Line 676: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

672: IS
673: l_return_status VARCHAR2(1);
674: l_control_rec QP_GLOBALS.Control_Rec_Type;
675: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
676: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
677: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
678: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
679:
680: l_p_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type; --[prarasto]

Line 677: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

673: l_return_status VARCHAR2(1);
674: l_control_rec QP_GLOBALS.Control_Rec_Type;
675: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
676: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
677: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
678: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
679:
680: l_p_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type; --[prarasto]
681: BEGIN

Line 678: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

674: l_control_rec QP_GLOBALS.Control_Rec_Type;
675: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
676: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
677: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
678: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
679:
680: l_p_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type; --[prarasto]
681: BEGIN
682:

Line 680: l_p_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type; --[prarasto]

676: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
677: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
678: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
679:
680: l_p_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type; --[prarasto]
681: BEGIN
682:
683: -- Init local table variables.
684:

Line 700: l_old_LIMIT_BALANCES_rec := QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC;

696:
697: IF l_old_LIMIT_BALANCES_tbl.EXISTS(I) THEN
698: l_old_LIMIT_BALANCES_rec := l_old_LIMIT_BALANCES_tbl(I);
699: ELSE
700: l_old_LIMIT_BALANCES_rec := QP_Limits_PUB.G_MISS_LIMIT_BALANCES_REC;
701: END IF;
702:
703: -- Load API control record
704:

Line 1018: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

1014: QP_GLOBALS.G_MISS_CONTROL_REC
1015: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1016: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1017: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1018: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1019: QP_Limits_PUB.G_MISS_LIMITS_REC
1020: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1021: QP_Limits_PUB.G_MISS_LIMITS_REC
1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=

Line 1019: QP_Limits_PUB.G_MISS_LIMITS_REC

1015: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1016: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1017: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1018: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1019: QP_Limits_PUB.G_MISS_LIMITS_REC
1020: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1021: QP_Limits_PUB.G_MISS_LIMITS_REC
1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL

Line 1020: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

1016: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1017: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1018: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1019: QP_Limits_PUB.G_MISS_LIMITS_REC
1020: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1021: QP_Limits_PUB.G_MISS_LIMITS_REC
1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=

Line 1021: QP_Limits_PUB.G_MISS_LIMITS_REC

1017: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1018: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1019: QP_Limits_PUB.G_MISS_LIMITS_REC
1020: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1021: QP_Limits_PUB.G_MISS_LIMITS_REC
1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL

Line 1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=

1018: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1019: QP_Limits_PUB.G_MISS_LIMITS_REC
1020: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1021: QP_Limits_PUB.G_MISS_LIMITS_REC
1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=

Line 1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL

1019: QP_Limits_PUB.G_MISS_LIMITS_REC
1020: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1021: QP_Limits_PUB.G_MISS_LIMITS_REC
1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL

Line 1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=

1020: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1021: QP_Limits_PUB.G_MISS_LIMITS_REC
1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=

Line 1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL

1021: QP_Limits_PUB.G_MISS_LIMITS_REC
1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1029: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL

Line 1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=

1022: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1029: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1030: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

Line 1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL

1023: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1029: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1030: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1031: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type

Line 1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=

1024: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1029: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1030: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1031: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1032: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type

Line 1029: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL

1025: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1029: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1030: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1031: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1032: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1033: )

Line 1030: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

1026: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1029: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1030: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1031: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1032: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1033: )
1034: IS

Line 1031: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type

1027: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1029: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1030: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1031: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1032: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1033: )
1034: IS
1035: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1032: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type

1028: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1029: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1030: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1031: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1032: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1033: )
1034: IS
1035: l_api_version_number CONSTANT NUMBER := 1.0;
1036: l_api_name CONSTANT VARCHAR2(30):= 'Process_Limits';

Line 1039: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;

1035: l_api_version_number CONSTANT NUMBER := 1.0;
1036: l_api_name CONSTANT VARCHAR2(30):= 'Process_Limits';
1037: l_return_status VARCHAR2(1);
1038: l_control_rec QP_GLOBALS.Control_Rec_Type;
1039: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
1040: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;
1041: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1042: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

Line 1040: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;

1036: l_api_name CONSTANT VARCHAR2(30):= 'Process_Limits';
1037: l_return_status VARCHAR2(1);
1038: l_control_rec QP_GLOBALS.Control_Rec_Type;
1039: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
1040: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;
1041: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1042: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 1041: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1037: l_return_status VARCHAR2(1);
1038: l_control_rec QP_GLOBALS.Control_Rec_Type;
1039: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
1040: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;
1041: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1042: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1045: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

Line 1042: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

1038: l_control_rec QP_GLOBALS.Control_Rec_Type;
1039: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
1040: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;
1041: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1042: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1045: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1046: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1039: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_LIMITS_rec;
1040: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;
1041: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1042: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1045: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1046: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1047: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

Line 1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

1040: l_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type := p_old_LIMITS_rec;
1041: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1042: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1045: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1046: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1047: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1048: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 1045: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

1041: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1042: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1045: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1046: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1047: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1048: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1049:

Line 1046: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

1042: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1045: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1046: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1047: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1048: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1049:
1050: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]

Line 1047: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

1043: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1045: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1046: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1047: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1048: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1049:
1050: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1051: l_p_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]

Line 1048: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

1044: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1045: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1046: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1047: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1048: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1049:
1050: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1051: l_p_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1052: l_p_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]

Line 1050: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]

1046: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1047: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1048: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1049:
1050: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1051: l_p_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1052: l_p_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1053: l_p_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1054: l_p_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]

Line 1051: l_p_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]

1047: l_old_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1048: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1049:
1050: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1051: l_p_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1052: l_p_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1053: l_p_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1054: l_p_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]
1055: l_p_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]

Line 1052: l_p_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]

1048: l_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1049:
1050: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1051: l_p_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1052: l_p_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1053: l_p_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1054: l_p_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]
1055: l_p_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]
1056:

Line 1053: l_p_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]

1049:
1050: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1051: l_p_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1052: l_p_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1053: l_p_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1054: l_p_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]
1055: l_p_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]
1056:
1057: BEGIN

Line 1054: l_p_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]

1050: l_p_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1051: l_p_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1052: l_p_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1053: l_p_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1054: l_p_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]
1055: l_p_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]
1056:
1057: BEGIN
1058:

Line 1055: l_p_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]

1051: l_p_old_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type; --[prarasto]
1052: l_p_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1053: l_p_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type; --[prarasto]
1054: l_p_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]
1055: l_p_old_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type; --[prarasto]
1056:
1057: BEGIN
1058:
1059: -- Standard call to check for call compatibility

Line 1371: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=

1367: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1368: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1369: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1370: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1371: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1372: QP_Limits_PUB.G_MISS_LIMITS_REC
1373: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1374: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=

Line 1372: QP_Limits_PUB.G_MISS_LIMITS_REC

1368: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1369: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1370: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1371: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1372: QP_Limits_PUB.G_MISS_LIMITS_REC
1373: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1374: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1376: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL

Line 1373: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=

1369: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1370: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1371: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1372: QP_Limits_PUB.G_MISS_LIMITS_REC
1373: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1374: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1376: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1377: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

Line 1374: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL

1370: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1371: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1372: QP_Limits_PUB.G_MISS_LIMITS_REC
1373: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1374: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1376: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1377: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1378: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type

Line 1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=

1371: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
1372: QP_Limits_PUB.G_MISS_LIMITS_REC
1373: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1374: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1376: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1377: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1378: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1379: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type

Line 1376: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL

1372: QP_Limits_PUB.G_MISS_LIMITS_REC
1373: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1374: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1376: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1377: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1378: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1379: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1380: )

Line 1377: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

1373: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
1374: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1376: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1377: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1378: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1379: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1380: )
1381: IS

Line 1378: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type

1374: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1376: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1377: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1378: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1379: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1380: )
1381: IS
1382: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1379: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type

1375: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
1376: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
1377: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1378: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1379: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1380: )
1381: IS
1382: l_api_version_number CONSTANT NUMBER := 1.0;
1383: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Limits';

Line 1385: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1381: IS
1382: l_api_version_number CONSTANT NUMBER := 1.0;
1383: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Limits';
1384: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1385: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1386: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1387: BEGIN
1388:
1389: -- Standard call to check for call compatibility

Line 1386: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

1382: l_api_version_number CONSTANT NUMBER := 1.0;
1383: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Limits';
1384: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1385: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1386: l_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1387: BEGIN
1388:
1389: -- Standard call to check for call compatibility
1390:

Line 1570: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type

1566: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1567: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1568: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1569: , p_limit_id IN NUMBER
1570: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1571: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1572: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1573: )
1574: IS

Line 1571: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type

1567: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1568: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1569: , p_limit_id IN NUMBER
1570: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1571: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1572: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1573: )
1574: IS
1575: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1572: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type

1568: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1569: , p_limit_id IN NUMBER
1570: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
1571: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
1572: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
1573: )
1574: IS
1575: l_api_version_number CONSTANT NUMBER := 1.0;
1576: l_api_name CONSTANT VARCHAR2(30):= 'Get_Limits';

Line 1577: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

1573: )
1574: IS
1575: l_api_version_number CONSTANT NUMBER := 1.0;
1576: l_api_name CONSTANT VARCHAR2(30):= 'Get_Limits';
1577: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1578: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1579: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1580: BEGIN
1581:

Line 1578: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

1574: IS
1575: l_api_version_number CONSTANT NUMBER := 1.0;
1576: l_api_name CONSTANT VARCHAR2(30):= 'Get_Limits';
1577: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1578: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1579: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1580: BEGIN
1581:
1582: -- Standard call to check for call compatibility

Line 1579: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

1575: l_api_version_number CONSTANT NUMBER := 1.0;
1576: l_api_name CONSTANT VARCHAR2(30):= 'Get_Limits';
1577: l_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1578: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1579: l_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1580: BEGIN
1581:
1582: -- Standard call to check for call compatibility
1583: