DBA Data[Home] [Help]

APPS.BIL_TX_OPTY_SMRY_RPT_PKG dependencies on BIL_TX_UTIL_RPT_PKG

Line 129: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)

125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
126: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
127:
128: -- FND logging --
129: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)
130: THEN
131: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
132: p_module => g_pkg || l_proc || 'begin',
133: p_msg => 'Start of Procedure '|| l_proc );

Line 131: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

127:
128: -- FND logging --
129: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)
130: THEN
131: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
132: p_module => g_pkg || l_proc || 'begin',
133: p_msg => 'Start of Procedure '|| l_proc );
134: END IF;
135:

Line 140: l_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');

136:
137:
138: -- Getting the Status Codes based on the Status Flags --
139:
140: l_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
141: l_wt_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
142: l_open_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NYY');
143: l_Won_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('WNY' );
144: l_lost_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('LNN');

Line 141: l_wt_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');

137:
138: -- Getting the Status Codes based on the Status Flags --
139:
140: l_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
141: l_wt_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
142: l_open_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NYY');
143: l_Won_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('WNY' );
144: l_lost_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('LNN');
145: l_No_Opp_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NNN');

Line 142: l_open_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NYY');

138: -- Getting the Status Codes based on the Status Flags --
139:
140: l_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
141: l_wt_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
142: l_open_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NYY');
143: l_Won_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('WNY' );
144: l_lost_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('LNN');
145: l_No_Opp_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NNN');
146:

Line 143: l_Won_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('WNY' );

139:
140: l_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
141: l_wt_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
142: l_open_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NYY');
143: l_Won_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('WNY' );
144: l_lost_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('LNN');
145: l_No_Opp_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NNN');
146:
147:

Line 144: l_lost_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('LNN');

140: l_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
141: l_wt_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
142: l_open_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NYY');
143: l_Won_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('WNY' );
144: l_lost_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('LNN');
145: l_No_Opp_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NNN');
146:
147:
148: -- Page Parameters --

Line 145: l_No_Opp_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NNN');

141: l_wt_pip_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('__Y');
142: l_open_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NYY');
143: l_Won_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('WNY' );
144: l_lost_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('LNN');
145: l_No_Opp_st := BIL_TX_UTIL_RPT_PKG.GET_STATS_CODS_OPTY_FLGS('NNN');
146:
147:
148: -- Page Parameters --
149:

Line 150: BIL_TX_UTIL_RPT_PKG.GET_PAGE_PARAMS

146:
147:
148: -- Page Parameters --
149:
150: BIL_TX_UTIL_RPT_PKG.GET_PAGE_PARAMS
151: (p_page_parameter_tbl => p_page_parameter_tbl
152: ,p_region_id => l_region_id
153: ,x_period_type => l_period_type
154: ,x_to_currency => l_to_currency

Line 185: l_from_date := BIL_TX_UTIL_RPT_PKG.GET_FROM_DATE(l_to_period_name);

181: ,x_to_date => l_to_date);
182:
183:
184:
185: l_from_date := BIL_TX_UTIL_RPT_PKG.GET_FROM_DATE(l_to_period_name);
186: l_to_date := BIL_TX_UTIL_RPT_PKG.GET_TO_DATE(l_to_period_name);
187:
188:
189:

Line 186: l_to_date := BIL_TX_UTIL_RPT_PKG.GET_TO_DATE(l_to_period_name);

182:
183:
184:
185: l_from_date := BIL_TX_UTIL_RPT_PKG.GET_FROM_DATE(l_to_period_name);
186: l_to_date := BIL_TX_UTIL_RPT_PKG.GET_TO_DATE(l_to_period_name);
187:
188:
189:
190: -- Getting the Product category parameter --

Line 259: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)

255: ' l_orderBy =>'||l_orderBy|| ' , '||
256: ' l_sortBy =>'||l_sortBy|| ' , '||
257: 'l_frcst_owner =>' ||l_frcst_owner;
258:
259: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)
260: THEN
261: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
262: p_module => g_pkg || l_proc,
263: p_msg => ' Params are =>'||l_log_param );

Line 261: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,

257: 'l_frcst_owner =>' ||l_frcst_owner;
258:
259: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_PROCEDURE)
260: THEN
261: BIL_TX_UTIL_RPT_PKG.writeLog(p_log_level => fnd_log.LEVEL_PROCEDURE,
262: p_module => g_pkg || l_proc,
263: p_msg => ' Params are =>'||l_log_param );
264: END IF;
265:

Line 296: BIL_TX_UTIL_RPT_PKG.PARSE_PRODCAT_ITEM_ID(l_prodcat_id,l_item_id) ;

292: END IF;
293:
294: l_prodcat_id := l_product_category1;
295:
296: BIL_TX_UTIL_RPT_PKG.PARSE_PRODCAT_ITEM_ID(l_prodcat_id,l_item_id) ;
297:
298: IF l_item_id is null THEN
299: INSERT INTO BIL_TX_PROD_TMP(attr1,attr2,attr3) VALUES(l_prodcat_id,l_item_id,'C');
300: ELSE