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_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
31: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
32: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
33: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
34: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_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_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
31: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
32: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
33: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
34: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
35: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_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_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
31: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
32: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
33: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
34: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
35: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
36: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
31: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
32: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
33: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
34: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
35: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
36: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
37: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
30: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
31: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
32: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
33: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
34: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
35: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
36: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
37: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
38: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
31: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
32: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
33: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
34: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
35: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
36: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
37: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
38: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
39: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
32: , p_old_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
33: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
34: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
35: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
36: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
37: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
38: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
39: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
40: );
33: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
34: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
35: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
36: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
37: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
38: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
39: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
40: );
41:
34: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
35: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
36: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
37: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
38: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
39: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
40: );
41:
42: -- Start of Comments
35: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
36: , p_old_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
37: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
38: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
39: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
40: );
41:
42: -- Start of Comments
43: -- API name Lock_Qualifier_Rules
60: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
61: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
63: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
65: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
66: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
68: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
61: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
63: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
65: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
66: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
68: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
69: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
62: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
63: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
65: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
66: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
68: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
69: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
70: );
63: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
65: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
66: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
68: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
69: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
70: );
71:
64: , p_QUALIFIER_RULES_rec IN QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type :=
65: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
66: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
68: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
69: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
70: );
71:
72: -- Start of Comments
65: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIER_RULES_REC
66: , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
68: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
69: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
70: );
71:
72: -- Start of Comments
73: -- API name Get_Qualifier_Rules
91: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94: , p_qualifier_rule_id IN NUMBER
95: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
96: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
97: );
98: -- Start of Comments
99: -- API name Copy_Qualifier_Rule
92: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94: , p_qualifier_rule_id IN NUMBER
95: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type
96: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
97: );
98: -- Start of Comments
99: -- API name Copy_Qualifier_Rule
100: -- Type Private