APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on JG_ZZ_SUMMARY_AR_PKG

Line 1: PACKAGE BODY JG_ZZ_SUMMARY_AR_PKG

1: PACKAGE BODY JG_ZZ_SUMMARY_AR_PKG
2: -- $Header: jgzzsummaryarb.pls 120.14 2008/01/23 10:45:07 anusaxen ship $
3: AS
4:
5: gv_debug constant boolean := true;

Line 24: IF p_applied = JG_ZZ_SUMMARY_AR_PKG.g_unapplied THEN

20:
21: DECLARE
22: l_taxrate NUMBER;
23: BEGIN
24: IF p_applied = JG_ZZ_SUMMARY_AR_PKG.g_unapplied THEN
25: RETURN(0);
26: END IF;
27:
28: SELECT NVL(ZRB.percentage_rate,ZRB.quantity_rate)

Line 191: IF p_applied = JG_ZZ_SUMMARY_AR_PKG.g_applied THEN

187:
188: DECLARE
189: l_taxrate number;
190: BEGIN
191: IF p_applied = JG_ZZ_SUMMARY_AR_PKG.g_applied THEN
192: RETURN(0);
193: END IF;
194:
195: SELECT NVL(ZRB.percentage_rate,ZRB.quantity_rate)

Line 227: AND p_Applied = JG_ZZ_SUMMARY_AR_PKG.g_applied THEN

223: BEGIN
224:
225: BEGIN
226: IF p_a_date BETWEEN NVL(p_period_start_date,TO_DATE('01-01-1700','DD-MM-YYYY')) AND NVL(p_period_end_date,TO_DATE('31-12-4000','DD-MM-YYYY'))
227: AND p_Applied = JG_ZZ_SUMMARY_AR_PKG.g_applied THEN
228: RETURN (p_amount_applied);
229: ELSE
230: RETURN(0);
231: END IF;

Line 252: AND p_applied = JG_ZZ_SUMMARY_AR_PKG.g_unapplied THEN

248: BEGIN
249:
250: BEGIN
251: IF p_a_date BETWEEN NVL(p_period_start_date,TO_DATE('01-01-1700','DD-MM-YYYY')) AND NVL(p_period_end_date,TO_DATE('31-12-4000','DD-MM-YYYY'))
252: AND p_applied = JG_ZZ_SUMMARY_AR_PKG.g_unapplied THEN
253: RETURN (p_amount_applied);
254: ELSE
255: RETURN(0);
256: END IF;

Line 287: IF p_applied = JG_ZZ_SUMMARY_AR_PKG.g_applied THEN

283: IS
284: BEGIN
285:
286: BEGIN
287: IF p_applied = JG_ZZ_SUMMARY_AR_PKG.g_applied THEN
288: RETURN (p_disp_app_vat);
289: END IF;
290: RETURN (p_disp_unapp_vat);
291: END;

Line 810: OR ( P_REPORTING_LEVEL = 'BSV' AND JG_ZZ_SUMMARY_AR_PKG.get_bsv(aa.code_combination_id,P_CHART_OF_ACC_ID,P_LEDGER_ID)= P_COMPANY )

806: AND ac.org_id = aa.org_id
807: AND at.tax_rate_id = ac.vat_tax_id
808: AND ( ( P_REPORTING_LEVEL = 'LE' AND ac.legal_entity_id = P_LEGAL_ENTITY_ID)
809: OR ( P_REPORTING_LEVEL = 'LEDGER' AND ac.set_of_books_id = P_LEDGER_ID)
810: OR ( P_REPORTING_LEVEL = 'BSV' AND JG_ZZ_SUMMARY_AR_PKG.get_bsv(aa.code_combination_id,P_CHART_OF_ACC_ID,P_LEDGER_ID)= P_COMPANY )
811: )
812: AND (ac.vat_tax_id = P_TAX_RATE_ID OR P_TAX_RATE_ID IS NULL)
813: AND ( (aa.status = 'ACC')
814: OR (aa.applied_customer_trx_id IN(

Line 1549: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error in JG_ZZ_SUMMARY_AR_PKG.beforeReport. Error-' ||SUBSTR(SQLERRM,1,200));

1545: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1546: raise;
1547: RETURN (FALSE);
1548: WHEN OTHERS THEN
1549: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error in JG_ZZ_SUMMARY_AR_PKG.beforeReport. Error-' ||SUBSTR(SQLERRM,1,200));
1550: raise;
1551: RETURN (FALSE);
1552: END beforeReport;
1553:

Line 1554: END JG_ZZ_SUMMARY_AR_PKG;

1550: raise;
1551: RETURN (FALSE);
1552: END beforeReport;
1553:
1554: END JG_ZZ_SUMMARY_AR_PKG;