26: QP_GLOBALS.G_MISS_CONTROL_REC
27: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
31: QP_Limits_PUB.G_MISS_LIMITS_REC
32: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
33: QP_Limits_PUB.G_MISS_LIMITS_REC
34: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
27: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
31: QP_Limits_PUB.G_MISS_LIMITS_REC
32: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
33: QP_Limits_PUB.G_MISS_LIMITS_REC
34: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
35: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
28: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
31: QP_Limits_PUB.G_MISS_LIMITS_REC
32: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
33: QP_Limits_PUB.G_MISS_LIMITS_REC
34: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
35: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
36: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
31: QP_Limits_PUB.G_MISS_LIMITS_REC
32: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
33: QP_Limits_PUB.G_MISS_LIMITS_REC
34: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
35: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
36: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
37: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
30: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
31: QP_Limits_PUB.G_MISS_LIMITS_REC
32: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
33: QP_Limits_PUB.G_MISS_LIMITS_REC
34: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
35: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
36: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
37: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
38: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
31: QP_Limits_PUB.G_MISS_LIMITS_REC
32: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
33: QP_Limits_PUB.G_MISS_LIMITS_REC
34: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
35: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
36: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
37: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
38: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
39: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
32: , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
33: QP_Limits_PUB.G_MISS_LIMITS_REC
34: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
35: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
36: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
37: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
38: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
39: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
40: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
33: QP_Limits_PUB.G_MISS_LIMITS_REC
34: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
35: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
36: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
37: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
38: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
39: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
40: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
41: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
34: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
35: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
36: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
37: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
38: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
39: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
40: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
41: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
42: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
35: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
36: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
37: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
38: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
39: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
40: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
41: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
42: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
43: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
36: , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
37: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
38: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
39: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
40: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
41: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
42: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
43: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
44: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
37: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
38: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
39: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
40: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
41: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
42: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
43: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
44: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
45: );
38: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
39: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
40: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
41: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
42: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
43: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
44: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
45: );
46:
39: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
40: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
41: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
42: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
43: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
44: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
45: );
46:
47: -- Start of Comments
40: , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
41: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
42: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
43: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
44: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
45: );
46:
47: -- Start of Comments
48: -- API name Lock_Limits
65: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
66: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
68: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
70: QP_Limits_PUB.G_MISS_LIMITS_REC
71: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
72: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
73: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
66: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
68: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
70: QP_Limits_PUB.G_MISS_LIMITS_REC
71: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
72: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
73: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
74: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
67: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
68: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
70: QP_Limits_PUB.G_MISS_LIMITS_REC
71: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
72: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
73: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
74: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
75: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
68: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
70: QP_Limits_PUB.G_MISS_LIMITS_REC
71: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
72: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
73: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
74: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
75: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
76: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
69: , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
70: QP_Limits_PUB.G_MISS_LIMITS_REC
71: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
72: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
73: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
74: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
75: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
76: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
77: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
70: QP_Limits_PUB.G_MISS_LIMITS_REC
71: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
72: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
73: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
74: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
75: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
76: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
77: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
78: );
71: , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
72: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
73: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
74: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
75: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
76: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
77: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
78: );
79:
72: QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
73: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
74: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
75: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
76: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
77: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
78: );
79:
80: -- Start of Comments
73: , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
74: QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
75: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
76: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
77: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
78: );
79:
80: -- Start of Comments
81: -- API name Get_Limits
99: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
101: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102: , p_limit_id IN NUMBER
103: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
104: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
105: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
106: );
107:
100: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
101: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102: , p_limit_id IN NUMBER
103: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
104: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
105: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
106: );
107:
108: END QP_Limits_PVT;
101: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102: , p_limit_id IN NUMBER
103: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
104: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
105: , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
106: );
107:
108: END QP_Limits_PVT;