APPS.OKI_UTL_PVT dependencies on OKI_SALES_K_HDRS

Line 58: value oki_sales_k_hdrs.base_contract_amount%TYPE

54: --
55: --------------------------------------------------------------------------------
56: TYPE g_tactk_all_csr_row IS RECORD
57: (
58: value oki_sales_k_hdrs.base_contract_amount%TYPE
59: , contract_count oki_sales_k_hdrs.chr_id%TYPE
60: ) ;
61:
62: CURSOR g_tactk_all_csr

Line 59: , contract_count oki_sales_k_hdrs.chr_id%TYPE

55: --------------------------------------------------------------------------------
56: TYPE g_tactk_all_csr_row IS RECORD
57: (
58: value oki_sales_k_hdrs.base_contract_amount%TYPE
59: , contract_count oki_sales_k_hdrs.chr_id%TYPE
60: ) ;
61:
62: CURSOR g_tactk_all_csr
63: (

Line 70: value oki_sales_k_hdrs.base_contract_amount%TYPE

66:
67:
68: TYPE g_tactk_by_org_csr_row IS RECORD
69: (
70: value oki_sales_k_hdrs.base_contract_amount%TYPE
71: , contract_count oki_sales_k_hdrs.chr_id%TYPE
72: , authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE
73: ) ;
74:

Line 71: , contract_count oki_sales_k_hdrs.chr_id%TYPE

67:
68: TYPE g_tactk_by_org_csr_row IS RECORD
69: (
70: value oki_sales_k_hdrs.base_contract_amount%TYPE
71: , contract_count oki_sales_k_hdrs.chr_id%TYPE
72: , authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE
73: ) ;
74:
75: CURSOR g_tactk_by_org_csr

Line 72: , authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE

68: TYPE g_tactk_by_org_csr_row IS RECORD
69: (
70: value oki_sales_k_hdrs.base_contract_amount%TYPE
71: , contract_count oki_sales_k_hdrs.chr_id%TYPE
72: , authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE
73: ) ;
74:
75: CURSOR g_tactk_by_org_csr
76: (

Line 84: value oki_sales_k_hdrs.base_contract_amount%TYPE

80:
81:
82: TYPE g_rnwl_oppty_all_csr_row IS RECORD
83: (
84: value oki_sales_k_hdrs.base_contract_amount%TYPE
85: , contract_count oki_sales_k_hdrs.chr_id%TYPE
86: ) ;
87:
88: CURSOR g_rnwl_oppty_all_csr

Line 85: , contract_count oki_sales_k_hdrs.chr_id%TYPE

81:
82: TYPE g_rnwl_oppty_all_csr_row IS RECORD
83: (
84: value oki_sales_k_hdrs.base_contract_amount%TYPE
85: , contract_count oki_sales_k_hdrs.chr_id%TYPE
86: ) ;
87:
88: CURSOR g_rnwl_oppty_all_csr
89: (

Line 95: value oki_sales_k_hdrs.base_contract_amount%TYPE

91: ) RETURN g_rnwl_oppty_all_csr_row ;
92:
93: TYPE g_rnwl_oppty_by_org_csr_row IS RECORD
94: (
95: value oki_sales_k_hdrs.base_contract_amount%TYPE
96: , contract_count oki_sales_k_hdrs.chr_id%TYPE
97: ) ;
98:
99: CURSOR g_rnwl_oppty_by_org_csr

Line 96: , contract_count oki_sales_k_hdrs.chr_id%TYPE

92:
93: TYPE g_rnwl_oppty_by_org_csr_row IS RECORD
94: (
95: value oki_sales_k_hdrs.base_contract_amount%TYPE
96: , contract_count oki_sales_k_hdrs.chr_id%TYPE
97: ) ;
98:
99: CURSOR g_rnwl_oppty_by_org_csr
100: (

Line 108: value oki_sales_k_hdrs.base_contract_amount%TYPE

104:
105:
106: TYPE g_k_exp_in_qtr_all_csr_row IS RECORD
107: (
108: value oki_sales_k_hdrs.base_contract_amount%TYPE
109: , contract_count oki_sales_k_hdrs.chr_id%TYPE
110: ) ;
111:
112: CURSOR g_k_exp_in_qtr_all_csr

Line 109: , contract_count oki_sales_k_hdrs.chr_id%TYPE

105:
106: TYPE g_k_exp_in_qtr_all_csr_row IS RECORD
107: (
108: value oki_sales_k_hdrs.base_contract_amount%TYPE
109: , contract_count oki_sales_k_hdrs.chr_id%TYPE
110: ) ;
111:
112: CURSOR g_k_exp_in_qtr_all_csr
113: (

Line 121: value oki_sales_k_hdrs.base_contract_amount%TYPE

117:
118:
119: TYPE g_k_exp_in_qtr_by_org_csr_row IS RECORD
120: (
121: value oki_sales_k_hdrs.base_contract_amount%TYPE
122: , contract_count oki_sales_k_hdrs.chr_id%TYPE
123: ) ;
124:
125: CURSOR g_k_exp_in_qtr_by_org_csr

Line 122: , contract_count oki_sales_k_hdrs.chr_id%TYPE

118:
119: TYPE g_k_exp_in_qtr_by_org_csr_row IS RECORD
120: (
121: value oki_sales_k_hdrs.base_contract_amount%TYPE
122: , contract_count oki_sales_k_hdrs.chr_id%TYPE
123: ) ;
124:
125: CURSOR g_k_exp_in_qtr_by_org_csr
126: (

Line 135: -- organization_name from the oki_sales_k_hdrs table

131:
132:
133: --
134: -- Cursor to return the distinct authoring_org_id and
135: -- organization_name from the oki_sales_k_hdrs table
136: --
137: TYPE g_org_csr_row IS RECORD
138: (
139: authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE

Line 139: authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE

135: -- organization_name from the oki_sales_k_hdrs table
136: --
137: TYPE g_org_csr_row IS RECORD
138: (
139: authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE
140: , organization_name oki_sales_k_hdrs.organization_name%TYPE
141: ) ;
142:
143: CURSOR g_org_csr RETURN g_org_csr_row ;

Line 140: , organization_name oki_sales_k_hdrs.organization_name%TYPE

136: --
137: TYPE g_org_csr_row IS RECORD
138: (
139: authoring_org_id oki_sales_k_hdrs.authoring_org_id%TYPE
140: , organization_name oki_sales_k_hdrs.organization_name%TYPE
141: ) ;
142:
143: CURSOR g_org_csr RETURN g_org_csr_row ;
144: