APPS.BIL_TX_OPTY_AGE_RPT_PKG dependencies on FND_PROFILE

Line 104: l_convsersion_type := FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE');

100: l_parameter_valid := FALSE;
101: l_rpt_str := 'BIL_TX_OPTY_AGE_RPT_R';
102: l_proc := 'OPTY_AGE_RPT.';
103: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_AGE_RPT_PKG.';
104: l_convsersion_type := FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE');
105: l_period_set_name := FND_PROFILE.VALUE('CRMBIS:PERIOD_SET_NAME');
106: l_credit_type_id := FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID');
107: --Fix for bug 5469370,added replace function
108: l_cur_conv_missing := replace(FND_MESSAGE.GET_STRING('BIL','BIL_TX_CUR_CONV_MIS'),'''','''''');

Line 105: l_period_set_name := FND_PROFILE.VALUE('CRMBIS:PERIOD_SET_NAME');

101: l_rpt_str := 'BIL_TX_OPTY_AGE_RPT_R';
102: l_proc := 'OPTY_AGE_RPT.';
103: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_AGE_RPT_PKG.';
104: l_convsersion_type := FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE');
105: l_period_set_name := FND_PROFILE.VALUE('CRMBIS:PERIOD_SET_NAME');
106: l_credit_type_id := FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID');
107: --Fix for bug 5469370,added replace function
108: l_cur_conv_missing := replace(FND_MESSAGE.GET_STRING('BIL','BIL_TX_CUR_CONV_MIS'),'''','''''');
109: l_select_1 := NULL;

Line 106: l_credit_type_id := FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID');

102: l_proc := 'OPTY_AGE_RPT.';
103: g_pkg := 'asn.patch.115.sql.BIL_TX_OPTY_AGE_RPT_PKG.';
104: l_convsersion_type := FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE');
105: l_period_set_name := FND_PROFILE.VALUE('CRMBIS:PERIOD_SET_NAME');
106: l_credit_type_id := FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID');
107: --Fix for bug 5469370,added replace function
108: l_cur_conv_missing := replace(FND_MESSAGE.GET_STRING('BIL','BIL_TX_CUR_CONV_MIS'),'''','''''');
109: l_select_1 := NULL;
110: l_from := NULL;