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_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
31: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
32: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
33: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
34: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_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_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
31: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
32: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
33: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
34: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
35: QP_Currency_PUB.G_MISS_CURR_DETAILS_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_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
31: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
32: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
33: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
34: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
35: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
36: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
31: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
32: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
33: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
34: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
35: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
36: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
37: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
30: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
31: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
32: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
33: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
34: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
35: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
36: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
37: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
38: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
31: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
32: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
33: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
34: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
35: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
36: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
37: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
38: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
39: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
32: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
33: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
34: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
35: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
36: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
37: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
38: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
39: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
40: );
33: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
34: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
35: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
36: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
37: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
38: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
39: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
40: );
41:
34: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
35: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
36: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
37: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
38: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
39: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
40: );
41:
42: -- Start of Comments
35: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
36: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
37: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
38: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
39: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
40: );
41:
42: -- Start of Comments
43: -- API name Lock_Currency
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_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
65: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
66: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
67: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
68: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_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_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
65: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
66: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
67: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
68: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
69: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_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_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
65: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
66: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
67: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
68: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
69: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
70: );
63: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
65: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
66: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
67: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
68: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
69: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
70: );
71:
64: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
65: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
66: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
67: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
68: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
69: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
70: );
71:
72: -- Start of Comments
65: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
66: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
67: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
68: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
69: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
70: );
71:
72: -- Start of Comments
73: -- API name Get_Currency
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_currency_header_id IN NUMBER
95: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
96: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
97: );
98:
99: END QP_Currency_PVT;
92: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94: , p_currency_header_id IN NUMBER
95: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
96: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
97: );
98:
99: END QP_Currency_PVT;