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.20.12020000.2 2012/07/18 07:50:04 rahulkum noship $
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-RRRR')) AND NVL(p_period_end_date,TO_DATE('31-12-4000','DD-MM-RRRR'))
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-RRRR')) AND NVL(p_period_end_date,TO_DATE('31-12-4000','DD-MM-RRRR'))
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 1628: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error in JG_ZZ_SUMMARY_AR_PKG.beforeReport. Error-' ||SUBSTR(SQLERRM,1,200));

1624: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1625: raise;
1626: RETURN (FALSE);
1627: WHEN OTHERS THEN
1628: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error in JG_ZZ_SUMMARY_AR_PKG.beforeReport. Error-' ||SUBSTR(SQLERRM,1,200));
1629: raise;
1630: RETURN (FALSE);
1631: END beforeReport;
1632:

Line 1633: END JG_ZZ_SUMMARY_AR_PKG;

1629: raise;
1630: RETURN (FALSE);
1631: END beforeReport;
1632:
1633: END JG_ZZ_SUMMARY_AR_PKG;