27:
28: SUBTYPE Gx_Itm_Obj1Id1 IS OKC_K_ITEMS.OBJECT1_ID1%TYPE;
29: SUBTYPE Gx_Itm_Obj1Id2 IS OKC_K_ITEMS.OBJECT1_ID2%TYPE;
30:
31: SUBTYPE Inp_Rec_Type IS OKS_ENTITLEMENTS_PUB.Inp_Rec_Type;
32: SUBTYPE Hdr_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Hdr_Tbl_Type;
33:
34: SUBTYPE Line_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Line_Tbl_Type;
35:
28: SUBTYPE Gx_Itm_Obj1Id1 IS OKC_K_ITEMS.OBJECT1_ID1%TYPE;
29: SUBTYPE Gx_Itm_Obj1Id2 IS OKC_K_ITEMS.OBJECT1_ID2%TYPE;
30:
31: SUBTYPE Inp_Rec_Type IS OKS_ENTITLEMENTS_PUB.Inp_Rec_Type;
32: SUBTYPE Hdr_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Hdr_Tbl_Type;
33:
34: SUBTYPE Line_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Line_Tbl_Type;
35:
36: SUBTYPE Clvl_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Clvl_Tbl_Type;
30:
31: SUBTYPE Inp_Rec_Type IS OKS_ENTITLEMENTS_PUB.Inp_Rec_Type;
32: SUBTYPE Hdr_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Hdr_Tbl_Type;
33:
34: SUBTYPE Line_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Line_Tbl_Type;
35:
36: SUBTYPE Clvl_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Clvl_Tbl_Type;
37: SUBTYPE PrfEng_Tbl_Type IS OKS_ENTITLEMENTS_PUB.PrfEng_Tbl_Type;
38: SUBTYPE Ent_Contact_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Contact_Tbl;
32: SUBTYPE Hdr_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Hdr_Tbl_Type;
33:
34: SUBTYPE Line_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Line_Tbl_Type;
35:
36: SUBTYPE Clvl_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Clvl_Tbl_Type;
37: SUBTYPE PrfEng_Tbl_Type IS OKS_ENTITLEMENTS_PUB.PrfEng_Tbl_Type;
38: SUBTYPE Ent_Contact_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Contact_Tbl;
39:
40: -----------------------------------------------------------------------------------------------------------------------*
33:
34: SUBTYPE Line_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Line_Tbl_Type;
35:
36: SUBTYPE Clvl_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Clvl_Tbl_Type;
37: SUBTYPE PrfEng_Tbl_Type IS OKS_ENTITLEMENTS_PUB.PrfEng_Tbl_Type;
38: SUBTYPE Ent_Contact_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Contact_Tbl;
39:
40: -----------------------------------------------------------------------------------------------------------------------*
41:
34: SUBTYPE Line_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Line_Tbl_Type;
35:
36: SUBTYPE Clvl_Tbl_Type IS OKS_ENTITLEMENTS_PUB.Clvl_Tbl_Type;
37: SUBTYPE PrfEng_Tbl_Type IS OKS_ENTITLEMENTS_PUB.PrfEng_Tbl_Type;
38: SUBTYPE Ent_Contact_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Contact_Tbl;
39:
40: -----------------------------------------------------------------------------------------------------------------------*
41:
42: SUBTYPE Inp_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Inp_Cont_Rec;
38: SUBTYPE Ent_Contact_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Contact_Tbl;
39:
40: -----------------------------------------------------------------------------------------------------------------------*
41:
42: SUBTYPE Inp_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Inp_Cont_Rec;
43: SUBTYPE Get_ContIn_Rec IS OKS_ENTITLEMENTS_PUB.Get_ContIn_Rec;
44: SUBTYPE Input_Rec_IB IS OKS_ENTITLEMENTS_PUB.Input_Rec_IB;
45:
46: SUBTYPE Ent_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Rec;
39:
40: -----------------------------------------------------------------------------------------------------------------------*
41:
42: SUBTYPE Inp_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Inp_Cont_Rec;
43: SUBTYPE Get_ContIn_Rec IS OKS_ENTITLEMENTS_PUB.Get_ContIn_Rec;
44: SUBTYPE Input_Rec_IB IS OKS_ENTITLEMENTS_PUB.Input_Rec_IB;
45:
46: SUBTYPE Ent_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Rec;
47: SUBTYPE Ent_Cont_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Tbl;
40: -----------------------------------------------------------------------------------------------------------------------*
41:
42: SUBTYPE Inp_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Inp_Cont_Rec;
43: SUBTYPE Get_ContIn_Rec IS OKS_ENTITLEMENTS_PUB.Get_ContIn_Rec;
44: SUBTYPE Input_Rec_IB IS OKS_ENTITLEMENTS_PUB.Input_Rec_IB;
45:
46: SUBTYPE Ent_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Rec;
47: SUBTYPE Ent_Cont_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Tbl;
48:
42: SUBTYPE Inp_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Inp_Cont_Rec;
43: SUBTYPE Get_ContIn_Rec IS OKS_ENTITLEMENTS_PUB.Get_ContIn_Rec;
44: SUBTYPE Input_Rec_IB IS OKS_ENTITLEMENTS_PUB.Input_Rec_IB;
45:
46: SUBTYPE Ent_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Rec;
47: SUBTYPE Ent_Cont_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Tbl;
48:
49: SUBTYPE Get_ConTop_Rec IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Rec;
50: SUBTYPE Get_ConTop_Tbl IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
43: SUBTYPE Get_ContIn_Rec IS OKS_ENTITLEMENTS_PUB.Get_ContIn_Rec;
44: SUBTYPE Input_Rec_IB IS OKS_ENTITLEMENTS_PUB.Input_Rec_IB;
45:
46: SUBTYPE Ent_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Rec;
47: SUBTYPE Ent_Cont_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Tbl;
48:
49: SUBTYPE Get_ConTop_Rec IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Rec;
50: SUBTYPE Get_ConTop_Tbl IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
51:
45:
46: SUBTYPE Ent_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Rec;
47: SUBTYPE Ent_Cont_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Tbl;
48:
49: SUBTYPE Get_ConTop_Rec IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Rec;
50: SUBTYPE Get_ConTop_Tbl IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
51:
52: SUBTYPE Output_Rec_IB IS OKS_ENTITLEMENTS_PUB.Output_Rec_IB;
53: SUBTYPE Output_Tbl_IB IS OKS_ENTITLEMENTS_PUB.Output_Tbl_IB;
46: SUBTYPE Ent_Cont_Rec IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Rec;
47: SUBTYPE Ent_Cont_Tbl IS OKS_ENTITLEMENTS_PUB.Ent_Cont_Tbl;
48:
49: SUBTYPE Get_ConTop_Rec IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Rec;
50: SUBTYPE Get_ConTop_Tbl IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
51:
52: SUBTYPE Output_Rec_IB IS OKS_ENTITLEMENTS_PUB.Output_Rec_IB;
53: SUBTYPE Output_Tbl_IB IS OKS_ENTITLEMENTS_PUB.Output_Tbl_IB;
54:
48:
49: SUBTYPE Get_ConTop_Rec IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Rec;
50: SUBTYPE Get_ConTop_Tbl IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
51:
52: SUBTYPE Output_Rec_IB IS OKS_ENTITLEMENTS_PUB.Output_Rec_IB;
53: SUBTYPE Output_Tbl_IB IS OKS_ENTITLEMENTS_PUB.Output_Tbl_IB;
54:
55: SUBTYPE grt_inp_rec_type IS OKS_ENTITLEMENTS_PUB.grt_inp_rec_type;
56: SUBTYPE rcn_rsn_rec_type IS OKS_ENTITLEMENTS_PUB.rcn_rsn_rec_type;
49: SUBTYPE Get_ConTop_Rec IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Rec;
50: SUBTYPE Get_ConTop_Tbl IS OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl;
51:
52: SUBTYPE Output_Rec_IB IS OKS_ENTITLEMENTS_PUB.Output_Rec_IB;
53: SUBTYPE Output_Tbl_IB IS OKS_ENTITLEMENTS_PUB.Output_Tbl_IB;
54:
55: SUBTYPE grt_inp_rec_type IS OKS_ENTITLEMENTS_PUB.grt_inp_rec_type;
56: SUBTYPE rcn_rsn_rec_type IS OKS_ENTITLEMENTS_PUB.rcn_rsn_rec_type;
57:
51:
52: SUBTYPE Output_Rec_IB IS OKS_ENTITLEMENTS_PUB.Output_Rec_IB;
53: SUBTYPE Output_Tbl_IB IS OKS_ENTITLEMENTS_PUB.Output_Tbl_IB;
54:
55: SUBTYPE grt_inp_rec_type IS OKS_ENTITLEMENTS_PUB.grt_inp_rec_type;
56: SUBTYPE rcn_rsn_rec_type IS OKS_ENTITLEMENTS_PUB.rcn_rsn_rec_type;
57:
58: SUBTYPE input_rec_entfrm IS OKS_ENTITLEMENTS_PUB.input_rec_entfrm;
59: SUBTYPE output_rec_entfrm IS OKS_ENTITLEMENTS_PUB.output_rec_entfrm;
52: SUBTYPE Output_Rec_IB IS OKS_ENTITLEMENTS_PUB.Output_Rec_IB;
53: SUBTYPE Output_Tbl_IB IS OKS_ENTITLEMENTS_PUB.Output_Tbl_IB;
54:
55: SUBTYPE grt_inp_rec_type IS OKS_ENTITLEMENTS_PUB.grt_inp_rec_type;
56: SUBTYPE rcn_rsn_rec_type IS OKS_ENTITLEMENTS_PUB.rcn_rsn_rec_type;
57:
58: SUBTYPE input_rec_entfrm IS OKS_ENTITLEMENTS_PUB.input_rec_entfrm;
59: SUBTYPE output_rec_entfrm IS OKS_ENTITLEMENTS_PUB.output_rec_entfrm;
60: SUBTYPE output_tbl_entfrm IS OKS_ENTITLEMENTS_PUB.output_tbl_entfrm;
54:
55: SUBTYPE grt_inp_rec_type IS OKS_ENTITLEMENTS_PUB.grt_inp_rec_type;
56: SUBTYPE rcn_rsn_rec_type IS OKS_ENTITLEMENTS_PUB.rcn_rsn_rec_type;
57:
58: SUBTYPE input_rec_entfrm IS OKS_ENTITLEMENTS_PUB.input_rec_entfrm;
59: SUBTYPE output_rec_entfrm IS OKS_ENTITLEMENTS_PUB.output_rec_entfrm;
60: SUBTYPE output_tbl_entfrm IS OKS_ENTITLEMENTS_PUB.output_tbl_entfrm;
61:
62: SUBTYPE CovType_Rec_Type IS OKS_ENTITLEMENTS_PUB.CovType_Rec_Type;
55: SUBTYPE grt_inp_rec_type IS OKS_ENTITLEMENTS_PUB.grt_inp_rec_type;
56: SUBTYPE rcn_rsn_rec_type IS OKS_ENTITLEMENTS_PUB.rcn_rsn_rec_type;
57:
58: SUBTYPE input_rec_entfrm IS OKS_ENTITLEMENTS_PUB.input_rec_entfrm;
59: SUBTYPE output_rec_entfrm IS OKS_ENTITLEMENTS_PUB.output_rec_entfrm;
60: SUBTYPE output_tbl_entfrm IS OKS_ENTITLEMENTS_PUB.output_tbl_entfrm;
61:
62: SUBTYPE CovType_Rec_Type IS OKS_ENTITLEMENTS_PUB.CovType_Rec_Type;
63: SUBTYPE Default_Contline_System_Rec IS OKS_ENTITLEMENTS_PUB.Default_Contline_System_Rec;
56: SUBTYPE rcn_rsn_rec_type IS OKS_ENTITLEMENTS_PUB.rcn_rsn_rec_type;
57:
58: SUBTYPE input_rec_entfrm IS OKS_ENTITLEMENTS_PUB.input_rec_entfrm;
59: SUBTYPE output_rec_entfrm IS OKS_ENTITLEMENTS_PUB.output_rec_entfrm;
60: SUBTYPE output_tbl_entfrm IS OKS_ENTITLEMENTS_PUB.output_tbl_entfrm;
61:
62: SUBTYPE CovType_Rec_Type IS OKS_ENTITLEMENTS_PUB.CovType_Rec_Type;
63: SUBTYPE Default_Contline_System_Rec IS OKS_ENTITLEMENTS_PUB.Default_Contline_System_Rec;
64: SUBTYPE Get_pmcontin_rec IS OKS_PM_ENTITLEMENTS_PUB.Get_pmcontin_rec;
58: SUBTYPE input_rec_entfrm IS OKS_ENTITLEMENTS_PUB.input_rec_entfrm;
59: SUBTYPE output_rec_entfrm IS OKS_ENTITLEMENTS_PUB.output_rec_entfrm;
60: SUBTYPE output_tbl_entfrm IS OKS_ENTITLEMENTS_PUB.output_tbl_entfrm;
61:
62: SUBTYPE CovType_Rec_Type IS OKS_ENTITLEMENTS_PUB.CovType_Rec_Type;
63: SUBTYPE Default_Contline_System_Rec IS OKS_ENTITLEMENTS_PUB.Default_Contline_System_Rec;
64: SUBTYPE Get_pmcontin_rec IS OKS_PM_ENTITLEMENTS_PUB.Get_pmcontin_rec;
65: SUBTYPE pm_sch_tbl_type IS OKS_PM_ENTITLEMENTS_PUB.pm_sch_tbl_type;
66: SUBTYPE inp_sch_rec IS OKS_PM_ENTITLEMENTS_PUB.inp_sch_rec;
59: SUBTYPE output_rec_entfrm IS OKS_ENTITLEMENTS_PUB.output_rec_entfrm;
60: SUBTYPE output_tbl_entfrm IS OKS_ENTITLEMENTS_PUB.output_tbl_entfrm;
61:
62: SUBTYPE CovType_Rec_Type IS OKS_ENTITLEMENTS_PUB.CovType_Rec_Type;
63: SUBTYPE Default_Contline_System_Rec IS OKS_ENTITLEMENTS_PUB.Default_Contline_System_Rec;
64: SUBTYPE Get_pmcontin_rec IS OKS_PM_ENTITLEMENTS_PUB.Get_pmcontin_rec;
65: SUBTYPE pm_sch_tbl_type IS OKS_PM_ENTITLEMENTS_PUB.pm_sch_tbl_type;
66: SUBTYPE inp_sch_rec IS OKS_PM_ENTITLEMENTS_PUB.inp_sch_rec;
67:
122: ,P_Validate_Eff IN VARCHAR2
123: ,P_Validate_Flag IN VARCHAR2
124: ,P_SrvLine_Flag IN VARCHAR2
125: ,P_Sort_Key IN VARCHAR2
126: ,X_Contracts_02 out nocopy OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl
127: ,X_Activities_02 out nocopy OKS_PM_ENTITLEMENTS_PUB.Get_Activityop_Tbl
128: ,X_Result out nocopy Gx_Boolean
129: ,X_Return_Status out nocopy Gx_Ret_Sts);
130:
134: ,P_Inp_Rec IN OKS_ENTITLEMENTS_PVT.Inp_rec_getcont02
135: ,X_Return_Status out nocopy VARCHAR2
136: ,X_Msg_Count out nocopy NUMBER
137: ,X_Msg_Data out nocopy VARCHAR2
138: ,X_Ent_Contracts out nocopy OKS_ENTITLEMENTS_PUB.Get_ConTop_Tbl
139: ,X_PM_Activities out nocopy OKS_PM_ENTITLEMENTS_PUB.get_activityop_tbl); -- New parameter added to return list of activities for contract_line and PM program
140:
141: PROCEDURE Get_PM_Contracts
142: (p_api_version IN Number
144: ,p_inp_rec IN Get_pmcontin_rec
145: ,x_return_status out nocopy Varchar2
146: ,x_msg_count out nocopy Number
147: ,x_msg_data out nocopy Varchar2
148: ,x_ent_contracts out nocopy OKS_ENTITLEMENTS_PUB.get_contop_tbl
149: ,x_pm_activities out nocopy OKS_PM_ENTITLEMENTS_PUB.get_activityop_tbl); -- New parameter added to return list of activities for contract_line and PM program
150:
151:
152: PROCEDURE Get_PM_Schedule