2633: BEGIN
2634:
2635: write_debug_and_log('arp_bf_bill.Report2 (+)');
2636:
2637: mo_global.init('AR');
2638:
2639: l_report.print_option := P_print_option;
2640: l_report.print_output := NULL;
2641: l_report.billing_cycle_id := NULL;
2661: l_report.print_status := NULL;
2662:
2663: IF P_org_id is not null THEN
2664: write_debug_and_log('ORG ID : '||p_org_id);
2665: mo_global.set_policy_context('S',p_org_id);
2666: arp_standard.init_standard(p_org_id);
2667: Report(l_report);
2668:
2669: ELSE
2670:
2671: FOR k in org_rec LOOP
2672: write_debug_and_log('ORG ID : '||k.org_id);
2673:
2674: mo_global.set_policy_context('S',k.org_id);
2675: arp_standard.init_standard(p_org_id);
2676: Report(l_report);
2677:
2678: END LOOP;
2740: from ar_system_parameters
2741: where org_id = nvl(p_org_id,org_id);
2742: BEGIN
2743:
2744: mo_global.init('AR');
2745: write_debug_and_log('arp_bf_bill.Report1 (+)');
2746:
2747: IF P_org_id is not null THEN
2748:
2746:
2747: IF P_org_id is not null THEN
2748:
2749: write_debug_and_log('ORG ID : '||p_org_id);
2750: mo_global.set_policy_context('S',p_org_id);
2751: arp_standard.init_standard(p_org_id);
2752:
2753: if P_Print_option in ( 'PRINT', 'DRAFT') THEN
2754: l_report.print_option := 'DRAFT';
2795: ELSE
2796:
2797: FOR k in org_rec LOOP
2798:
2799: mo_global.set_policy_context('S',k.org_id);
2800: arp_standard.init_standard(p_org_id);
2801:
2802: if P_Print_option in ( 'PRINT', 'DRAFT') THEN
2803: l_report.print_option := 'DRAFT';