APPS.GLR03300_PKG dependencies on GL_JE_HEADERS

Line 102: CURSOR c_header (lv_header_id gl_je_headers.je_header_id%type ) IS

98: X_budget_name OUT NOCOPY VARCHAR2,
99: X_show_batch_status OUT NOCOPY VARCHAR2 ,
100: X_show_bc_status OUT NOCOPY VARCHAR2 ) IS
101:
102: CURSOR c_header (lv_header_id gl_je_headers.je_header_id%type ) IS
103: SELECT je_header_id,je_source,je_category,encumbrance_type_id,
104: budget_version_id,currency_conversion_type , je_batch_id
105: FROM gl_je_headers
106: WHERE je_header_id=lv_header_id ;

Line 105: FROM gl_je_headers

101:
102: CURSOR c_header (lv_header_id gl_je_headers.je_header_id%type ) IS
103: SELECT je_header_id,je_source,je_category,encumbrance_type_id,
104: budget_version_id,currency_conversion_type , je_batch_id
105: FROM gl_je_headers
106: WHERE je_header_id=lv_header_id ;
107:
108: CURSOR c_user_source_name (lv_gl_je_source gl_je_headers.je_source%type ) IS
109: SELECT user_je_source_name

Line 108: CURSOR c_user_source_name (lv_gl_je_source gl_je_headers.je_source%type ) IS

104: budget_version_id,currency_conversion_type , je_batch_id
105: FROM gl_je_headers
106: WHERE je_header_id=lv_header_id ;
107:
108: CURSOR c_user_source_name (lv_gl_je_source gl_je_headers.je_source%type ) IS
109: SELECT user_je_source_name
110: FROM gl_je_sources
111: WHERE je_source_name= lv_gl_je_source ;
112:

Line 113: CURSOR c_user_category_name (lv_gl_je_category gl_je_headers.je_category%type ) IS

109: SELECT user_je_source_name
110: FROM gl_je_sources
111: WHERE je_source_name= lv_gl_je_source ;
112:
113: CURSOR c_user_category_name (lv_gl_je_category gl_je_headers.je_category%type ) IS
114: SELECT user_je_category_name
115: FROM gl_je_categories
116: WHERE je_category_name= lv_gl_je_category ;
117:

Line 118: CURSOR c_encumb_type (lv_encumb_type_id gl_je_headers.encumbrance_type_id%type ) IS

114: SELECT user_je_category_name
115: FROM gl_je_categories
116: WHERE je_category_name= lv_gl_je_category ;
117:
118: CURSOR c_encumb_type (lv_encumb_type_id gl_je_headers.encumbrance_type_id%type ) IS
119: SELECT encumbrance_type
120: FROM gl_encumbrance_types
121: WHERE encumbrance_type_id= lv_encumb_type_id ;
122:

Line 123: CURSOR c_bud_ver (lv_bud_ver_id gl_je_headers.budget_version_id%type ) IS

119: SELECT encumbrance_type
120: FROM gl_encumbrance_types
121: WHERE encumbrance_type_id= lv_encumb_type_id ;
122:
123: CURSOR c_bud_ver (lv_bud_ver_id gl_je_headers.budget_version_id%type ) IS
124: SELECT budget_name
125: FROM gl_budget_versions
126: WHERE budget_version_id= lv_bud_ver_id ;
127:

Line 128: CURSOR c_curr_conv (lv_curr_conv_type gl_je_headers.currency_conversion_type%type ) IS

124: SELECT budget_name
125: FROM gl_budget_versions
126: WHERE budget_version_id= lv_bud_ver_id ;
127:
128: CURSOR c_curr_conv (lv_curr_conv_type gl_je_headers.currency_conversion_type%type ) IS
129: SELECT user_conversion_type
130: FROM gl_daily_conversion_types
131: WHERE conversion_type = lv_curr_conv_type ;
132:

Line 133: CURSOR c_show_batch_stat (lv_je_header_id gl_je_headers.je_header_id%type ,

129: SELECT user_conversion_type
130: FROM gl_daily_conversion_types
131: WHERE conversion_type = lv_curr_conv_type ;
132:
133: CURSOR c_show_batch_stat (lv_je_header_id gl_je_headers.je_header_id%type ,
134: lv_status gl_je_batches.status%type ) IS
135: SELECT description
136: FROM gl_lookups
137: WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'MJE_BATCH_STATUS')

Line 141: CURSOR c_show_bc_stat (lv_je_header_id gl_je_headers.je_header_id%type ,

137: WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'MJE_BATCH_STATUS')
138: AND lookup_code=substr( lv_status , 1 , 1);
139:
140:
141: CURSOR c_show_bc_stat (lv_je_header_id gl_je_headers.je_header_id%type ,
142: lv_status gl_je_batches.budgetary_control_status%type ) IS
143: SELECT meaning
144: FROM gl_lookups
145: WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'JE_BATCH_BC_STATUS')

Line 148: CURSOR c1 (lv_je_batch_id gl_je_headers.je_batch_id%type ) IS

144: FROM gl_lookups
145: WHERE lookup_type=decode ( lv_je_header_id,NULL,NULL,'JE_BATCH_BC_STATUS')
146: AND lookup_code= lv_status ;
147:
148: CURSOR c1 (lv_je_batch_id gl_je_headers.je_batch_id%type ) IS
149: select status,budgetary_control_status from gl_je_batches where
150: je_batch_id=lv_je_batch_id ;
151:
152: