APPS.FII_AR_OPEN_REC_PDUE dependencies on FII_AR_OPEN_REC_PDUE

Line 1: PACKAGE BODY FII_AR_OPEN_REC_PDUE AS

1: PACKAGE BODY FII_AR_OPEN_REC_PDUE AS
2: /* $Header: FIIARDBIPDB.pls 120.15 2007/05/15 20:51:17 vkazhipu ship $ */
3:
4:
5:

Line 64: ''pFunctionName=FII_AR_PDUE_REC_DTL&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID'', ''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID

60: l_self := ' t.is_self_flag,';
61:
62: l_past_due_rec_drill:=
63: ' DECODE(FII_AR_PDUE_REC,0,'''',DECODE(inline_view.is_self_flag, ''Y'',''pFunctionName=FII_AR_PDUE_REC_DTL&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID'',DECODE(inline_view.is_leaf_flag, ''Y'' ,
64: ''pFunctionName=FII_AR_PDUE_REC_DTL&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID'', ''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID
65: &VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y''))) ';
66:
67: l_open_rec_drill :=
68: ' DECODE(FII_AR_OPEN_REC,0,'''',DECODE(inline_view.is_self_flag, ''Y'',''pFunctionName=FII_AR_OPEN_REC_DTL&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID'',DECODE(inline_view.is_leaf_flag, ''Y'' ,

Line 73: l_cust_self_drill :=' DECODE(inline_view.is_self_flag,''Y'','''', DECODE(inline_view.is_leaf_flag, ''Y'','''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y'')) ';

69: ''pFunctionName=FII_AR_OPEN_REC_DTL&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID'', ''pFunctionName=FII_AR_OPEN_REC_SUMMARY&VIEW_BY_NAME=VIEW_BY_ID
70: &VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y''))) ';
71:
72: /* Drills to children on Customer dimension */
73: l_cust_self_drill :=' DECODE(inline_view.is_self_flag,''Y'','''', DECODE(inline_view.is_leaf_flag, ''Y'','''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=VIEW_BY&pParamIds=Y'')) ';
74:
75: l_group_by := ' inline_view.is_self_flag,inline_view.viewby,inline_view.is_leaf_flag,inline_view.viewby_id ';
76:
77: ELSIF (fii_ar_util_pkg.g_view_by= 'FII_COLLECTOR+FII_COLLECTOR'

Line 81: l_past_due_rec_drill := ' DECODE(FII_AR_PDUE_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y'') ';

77: ELSIF (fii_ar_util_pkg.g_view_by= 'FII_COLLECTOR+FII_COLLECTOR'
78: OR fii_ar_util_pkg.g_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' ) THEN
79: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
80: /* Calls Open Receivables: Percent Past Due - View by Customer Account*/
81: l_past_due_rec_drill := ' DECODE(FII_AR_PDUE_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y'') ';
82:
83: /* Calls Open Receivables Summary - View by Customer Account*/
84: l_open_rec_drill := ' DECODE(FII_AR_OPEN_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_SUMMARY&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y'') ';
85: ELSE

Line 87: l_past_due_rec_drill := ' DECODE(FII_AR_PDUE_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'') ';

83: /* Calls Open Receivables Summary - View by Customer Account*/
84: l_open_rec_drill := ' DECODE(FII_AR_OPEN_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_SUMMARY&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y'') ';
85: ELSE
86: /* Calls Open Receivables: Percent Past Due - View by Customer*/
87: l_past_due_rec_drill := ' DECODE(FII_AR_PDUE_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_PDUE&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'') ';
88:
89: /* Calls Open Receivables Summary - View by Customer*/
90: l_open_rec_drill := ' DECODE(FII_AR_OPEN_REC,0,'''',''pFunctionName=FII_AR_OPEN_REC_SUMMARY&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y'') ';
91:

Line 188: END FII_AR_OPEN_REC_PDUE;

184: fii_ar_util_pkg.bind_variable(l_select, p_page_parameter_tbl, open_rec_sql, open_rec_output);
185:
186: END get_rec_pdue;
187:
188: END FII_AR_OPEN_REC_PDUE;
189: