APPS.ISC_DEPOT_COMPLETION_PKG dependencies on ISC_DEPOT_COMPLETION_PKG

Line 1: PACKAGE BODY ISC_DEPOT_COMPLETION_PKG AS

1: PACKAGE BODY ISC_DEPOT_COMPLETION_PKG AS
2: --$Header: iscdepotcomprqb.pls 120.0 2005/05/25 17:25:22 appldev noship $
3:
4: FUNCTION GET_COMPLETION_TBL_SEL_CLAUSE (p_view_by_dim IN VARCHAR2
5: ,p_view_by_col IN VARCHAR2)

Line 833: -- ',' || 'ISC_DEPOT_COMPLETION_PKG.GET_BUCKET_DRILL_ACROSS_URL(''ISC_DEPOT_LAT_COMP_DTL_TBL_REP'', bucket_number)' || ' BIV_DYNAMIC_URL1 ' ||

829: ,change_type => 'NP') || 'BIV_MEASURE22' || fnd_global.newline ||
830: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT_TOTAL'
831: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
832: ,rate_type => 'P') || 'BIV_MEASURE23' || fnd_global.newline ||
833: -- ',' || 'ISC_DEPOT_COMPLETION_PKG.GET_BUCKET_DRILL_ACROSS_URL(''ISC_DEPOT_LAT_COMP_DTL_TBL_REP'', bucket_number)' || ' BIV_DYNAMIC_URL1 ' ||
834: ',' || '''pFunctionName=ISC_DEPOT_LAT_COMP_DTL_TBL_REP&pParamIds=Y&BIV_ATTRIBUTE1=-1&BIV_DR_BACKLOG_BUCKET+BIV_DR_BACKLOG_BUCKET=''|| bucket_number ||''''' || ' BIV_DYNAMIC_URL1 ' ||
835: ' FROM (select sum (decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
836: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
837: ' ,2, days_late_age_b2 ' || fnd_global.newline ||

Line 974: END ISC_DEPOT_COMPLETION_PKG;

970:
971: RETURN l_drill_across_rep_1;
972: END GET_BUCKET_DRILL_ACROSS_URL ;
973:
974: END ISC_DEPOT_COMPLETION_PKG;