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_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
31: QP_Attr_Map_PUB.G_MISS_PTE_REC
32: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
33: QP_Attr_Map_PUB.G_MISS_PTE_REC
34: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_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_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
31: QP_Attr_Map_PUB.G_MISS_PTE_REC
32: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
33: QP_Attr_Map_PUB.G_MISS_PTE_REC
34: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
35: QP_Attr_Map_PUB.G_MISS_RQT_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_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
31: QP_Attr_Map_PUB.G_MISS_PTE_REC
32: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
33: QP_Attr_Map_PUB.G_MISS_PTE_REC
34: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
35: QP_Attr_Map_PUB.G_MISS_RQT_TBL
36: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
31: QP_Attr_Map_PUB.G_MISS_PTE_REC
32: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
33: QP_Attr_Map_PUB.G_MISS_PTE_REC
34: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
35: QP_Attr_Map_PUB.G_MISS_RQT_TBL
36: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
37: QP_Attr_Map_PUB.G_MISS_RQT_TBL
30: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
31: QP_Attr_Map_PUB.G_MISS_PTE_REC
32: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
33: QP_Attr_Map_PUB.G_MISS_PTE_REC
34: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
35: QP_Attr_Map_PUB.G_MISS_RQT_TBL
36: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
37: QP_Attr_Map_PUB.G_MISS_RQT_TBL
38: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
31: QP_Attr_Map_PUB.G_MISS_PTE_REC
32: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
33: QP_Attr_Map_PUB.G_MISS_PTE_REC
34: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
35: QP_Attr_Map_PUB.G_MISS_RQT_TBL
36: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
37: QP_Attr_Map_PUB.G_MISS_RQT_TBL
38: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
39: QP_Attr_Map_PUB.G_MISS_SSC_TBL
32: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
33: QP_Attr_Map_PUB.G_MISS_PTE_REC
34: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
35: QP_Attr_Map_PUB.G_MISS_RQT_TBL
36: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
37: QP_Attr_Map_PUB.G_MISS_RQT_TBL
38: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
39: QP_Attr_Map_PUB.G_MISS_SSC_TBL
40: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
33: QP_Attr_Map_PUB.G_MISS_PTE_REC
34: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
35: QP_Attr_Map_PUB.G_MISS_RQT_TBL
36: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
37: QP_Attr_Map_PUB.G_MISS_RQT_TBL
38: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
39: QP_Attr_Map_PUB.G_MISS_SSC_TBL
40: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
41: QP_Attr_Map_PUB.G_MISS_SSC_TBL
34: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
35: QP_Attr_Map_PUB.G_MISS_RQT_TBL
36: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
37: QP_Attr_Map_PUB.G_MISS_RQT_TBL
38: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
39: QP_Attr_Map_PUB.G_MISS_SSC_TBL
40: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
41: QP_Attr_Map_PUB.G_MISS_SSC_TBL
42: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
35: QP_Attr_Map_PUB.G_MISS_RQT_TBL
36: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
37: QP_Attr_Map_PUB.G_MISS_RQT_TBL
38: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
39: QP_Attr_Map_PUB.G_MISS_SSC_TBL
40: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
41: QP_Attr_Map_PUB.G_MISS_SSC_TBL
42: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
43: QP_Attr_Map_PUB.G_MISS_PSG_TBL
36: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
37: QP_Attr_Map_PUB.G_MISS_RQT_TBL
38: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
39: QP_Attr_Map_PUB.G_MISS_SSC_TBL
40: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
41: QP_Attr_Map_PUB.G_MISS_SSC_TBL
42: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
43: QP_Attr_Map_PUB.G_MISS_PSG_TBL
44: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
37: QP_Attr_Map_PUB.G_MISS_RQT_TBL
38: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
39: QP_Attr_Map_PUB.G_MISS_SSC_TBL
40: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
41: QP_Attr_Map_PUB.G_MISS_SSC_TBL
42: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
43: QP_Attr_Map_PUB.G_MISS_PSG_TBL
44: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
45: QP_Attr_Map_PUB.G_MISS_PSG_TBL
38: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
39: QP_Attr_Map_PUB.G_MISS_SSC_TBL
40: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
41: QP_Attr_Map_PUB.G_MISS_SSC_TBL
42: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
43: QP_Attr_Map_PUB.G_MISS_PSG_TBL
44: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
45: QP_Attr_Map_PUB.G_MISS_PSG_TBL
46: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
39: QP_Attr_Map_PUB.G_MISS_SSC_TBL
40: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
41: QP_Attr_Map_PUB.G_MISS_SSC_TBL
42: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
43: QP_Attr_Map_PUB.G_MISS_PSG_TBL
44: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
45: QP_Attr_Map_PUB.G_MISS_PSG_TBL
46: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
47: QP_Attr_Map_PUB.G_MISS_SOU_TBL
40: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
41: QP_Attr_Map_PUB.G_MISS_SSC_TBL
42: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
43: QP_Attr_Map_PUB.G_MISS_PSG_TBL
44: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
45: QP_Attr_Map_PUB.G_MISS_PSG_TBL
46: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
47: QP_Attr_Map_PUB.G_MISS_SOU_TBL
48: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
41: QP_Attr_Map_PUB.G_MISS_SSC_TBL
42: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
43: QP_Attr_Map_PUB.G_MISS_PSG_TBL
44: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
45: QP_Attr_Map_PUB.G_MISS_PSG_TBL
46: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
47: QP_Attr_Map_PUB.G_MISS_SOU_TBL
48: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_TBL
42: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
43: QP_Attr_Map_PUB.G_MISS_PSG_TBL
44: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
45: QP_Attr_Map_PUB.G_MISS_PSG_TBL
46: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
47: QP_Attr_Map_PUB.G_MISS_SOU_TBL
48: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_TBL
50: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
43: QP_Attr_Map_PUB.G_MISS_PSG_TBL
44: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
45: QP_Attr_Map_PUB.G_MISS_PSG_TBL
46: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
47: QP_Attr_Map_PUB.G_MISS_SOU_TBL
48: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_TBL
50: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
51: QP_Attr_Map_PUB.G_MISS_FNA_TBL
44: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
45: QP_Attr_Map_PUB.G_MISS_PSG_TBL
46: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
47: QP_Attr_Map_PUB.G_MISS_SOU_TBL
48: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_TBL
50: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
51: QP_Attr_Map_PUB.G_MISS_FNA_TBL
52: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
45: QP_Attr_Map_PUB.G_MISS_PSG_TBL
46: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
47: QP_Attr_Map_PUB.G_MISS_SOU_TBL
48: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_TBL
50: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
51: QP_Attr_Map_PUB.G_MISS_FNA_TBL
52: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_TBL
46: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
47: QP_Attr_Map_PUB.G_MISS_SOU_TBL
48: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_TBL
50: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
51: QP_Attr_Map_PUB.G_MISS_FNA_TBL
52: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_TBL
54: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
47: QP_Attr_Map_PUB.G_MISS_SOU_TBL
48: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_TBL
50: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
51: QP_Attr_Map_PUB.G_MISS_FNA_TBL
52: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_TBL
54: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
55: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
48: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
49: QP_Attr_Map_PUB.G_MISS_SOU_TBL
50: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
51: QP_Attr_Map_PUB.G_MISS_FNA_TBL
52: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_TBL
54: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
55: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
56: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
49: QP_Attr_Map_PUB.G_MISS_SOU_TBL
50: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
51: QP_Attr_Map_PUB.G_MISS_FNA_TBL
52: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_TBL
54: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
55: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
56: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
57: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
50: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
51: QP_Attr_Map_PUB.G_MISS_FNA_TBL
52: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_TBL
54: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
55: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
56: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
57: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
58: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
51: QP_Attr_Map_PUB.G_MISS_FNA_TBL
52: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_TBL
54: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
55: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
56: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
57: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
58: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
59: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
52: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
53: QP_Attr_Map_PUB.G_MISS_FNA_TBL
54: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
55: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
56: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
57: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
58: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
59: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
60: );
53: QP_Attr_Map_PUB.G_MISS_FNA_TBL
54: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
55: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
56: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
57: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
58: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
59: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
60: );
61:
54: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
55: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
56: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
57: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
58: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
59: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
60: );
61:
62: -- Start of Comments
55: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
56: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
57: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
58: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
59: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
60: );
61:
62: -- Start of Comments
63: -- API name Lock_Attr_Mapping
80: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
81: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
83: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
85: QP_Attr_Map_PUB.G_MISS_PTE_REC
86: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
87: QP_Attr_Map_PUB.G_MISS_RQT_TBL
88: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
81: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
83: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
85: QP_Attr_Map_PUB.G_MISS_PTE_REC
86: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
87: QP_Attr_Map_PUB.G_MISS_RQT_TBL
88: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
89: QP_Attr_Map_PUB.G_MISS_SSC_TBL
82: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
83: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
85: QP_Attr_Map_PUB.G_MISS_PTE_REC
86: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
87: QP_Attr_Map_PUB.G_MISS_RQT_TBL
88: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
89: QP_Attr_Map_PUB.G_MISS_SSC_TBL
90: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
83: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
85: QP_Attr_Map_PUB.G_MISS_PTE_REC
86: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
87: QP_Attr_Map_PUB.G_MISS_RQT_TBL
88: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
89: QP_Attr_Map_PUB.G_MISS_SSC_TBL
90: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
91: QP_Attr_Map_PUB.G_MISS_PSG_TBL
84: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=
85: QP_Attr_Map_PUB.G_MISS_PTE_REC
86: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
87: QP_Attr_Map_PUB.G_MISS_RQT_TBL
88: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
89: QP_Attr_Map_PUB.G_MISS_SSC_TBL
90: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
91: QP_Attr_Map_PUB.G_MISS_PSG_TBL
92: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
85: QP_Attr_Map_PUB.G_MISS_PTE_REC
86: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
87: QP_Attr_Map_PUB.G_MISS_RQT_TBL
88: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
89: QP_Attr_Map_PUB.G_MISS_SSC_TBL
90: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
91: QP_Attr_Map_PUB.G_MISS_PSG_TBL
92: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
93: QP_Attr_Map_PUB.G_MISS_SOU_TBL
86: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type :=
87: QP_Attr_Map_PUB.G_MISS_RQT_TBL
88: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
89: QP_Attr_Map_PUB.G_MISS_SSC_TBL
90: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
91: QP_Attr_Map_PUB.G_MISS_PSG_TBL
92: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
93: QP_Attr_Map_PUB.G_MISS_SOU_TBL
94: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
87: QP_Attr_Map_PUB.G_MISS_RQT_TBL
88: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
89: QP_Attr_Map_PUB.G_MISS_SSC_TBL
90: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
91: QP_Attr_Map_PUB.G_MISS_PSG_TBL
92: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
93: QP_Attr_Map_PUB.G_MISS_SOU_TBL
94: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
95: QP_Attr_Map_PUB.G_MISS_FNA_TBL
88: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type :=
89: QP_Attr_Map_PUB.G_MISS_SSC_TBL
90: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
91: QP_Attr_Map_PUB.G_MISS_PSG_TBL
92: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
93: QP_Attr_Map_PUB.G_MISS_SOU_TBL
94: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
95: QP_Attr_Map_PUB.G_MISS_FNA_TBL
96: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
89: QP_Attr_Map_PUB.G_MISS_SSC_TBL
90: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
91: QP_Attr_Map_PUB.G_MISS_PSG_TBL
92: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
93: QP_Attr_Map_PUB.G_MISS_SOU_TBL
94: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
95: QP_Attr_Map_PUB.G_MISS_FNA_TBL
96: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
97: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
90: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type :=
91: QP_Attr_Map_PUB.G_MISS_PSG_TBL
92: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
93: QP_Attr_Map_PUB.G_MISS_SOU_TBL
94: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
95: QP_Attr_Map_PUB.G_MISS_FNA_TBL
96: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
97: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
98: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
91: QP_Attr_Map_PUB.G_MISS_PSG_TBL
92: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
93: QP_Attr_Map_PUB.G_MISS_SOU_TBL
94: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
95: QP_Attr_Map_PUB.G_MISS_FNA_TBL
96: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
97: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
98: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
99: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
92: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type :=
93: QP_Attr_Map_PUB.G_MISS_SOU_TBL
94: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
95: QP_Attr_Map_PUB.G_MISS_FNA_TBL
96: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
97: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
98: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
99: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
100: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
93: QP_Attr_Map_PUB.G_MISS_SOU_TBL
94: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
95: QP_Attr_Map_PUB.G_MISS_FNA_TBL
96: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
97: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
98: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
99: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
100: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
101: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
94: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type :=
95: QP_Attr_Map_PUB.G_MISS_FNA_TBL
96: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
97: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
98: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
99: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
100: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
101: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
102: );
95: QP_Attr_Map_PUB.G_MISS_FNA_TBL
96: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
97: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
98: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
99: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
100: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
101: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
102: );
103:
96: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
97: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
98: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
99: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
100: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
101: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
102: );
103:
104: -- Start of Comments
97: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
98: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
99: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
100: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
101: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
102: );
103:
104: -- Start of Comments
105: -- API name Get_Attr_Mapping
123: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126: , p_lookup_code IN VARCHAR2
127: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
128: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
129: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
130: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
131: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
124: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126: , p_lookup_code IN VARCHAR2
127: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
128: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
129: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
130: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
131: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
132: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
125: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126: , p_lookup_code IN VARCHAR2
127: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
128: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
129: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
130: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
131: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
132: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
133: );
126: , p_lookup_code IN VARCHAR2
127: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
128: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
129: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
130: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
131: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
132: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
133: );
134:
127: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
128: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
129: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
130: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
131: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
132: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
133: );
134:
135: -- Start of Comments
128: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
129: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
130: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
131: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
132: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
133: );
134:
135: -- Start of Comments
136: -- API name Check_Enabled_Fnas