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: )
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
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);
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;
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:
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
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
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: )
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
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);
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;
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:
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]
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
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:
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:
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:
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: )
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
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);
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;
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:
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]
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
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:
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:
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:
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 :=
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
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 :=
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
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 :=
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
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 :=
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
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
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
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
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: )
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
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;
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';
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;
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;
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;
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;
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;
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;
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:
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]
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]
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]
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]
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]
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:
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
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:
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
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 :=
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
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
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
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
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: )
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
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;
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';
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
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:
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
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;
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';
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:
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
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: