2888: BEGIN
2889:
2890: write_debug_and_log('arp_bf_bill.Report2 (+)');
2891:
2892: mo_global.init('AR');
2893:
2894: l_report.print_option := P_print_option;
2895: l_report.print_output := NULL;
2896: l_report.billing_cycle_id := NULL;
2916: l_report.print_status := NULL;
2917:
2918: IF P_org_id is not null THEN
2919: write_debug_and_log('ORG ID : '||p_org_id);
2920: mo_global.set_policy_context('S',p_org_id);
2921: arp_standard.init_standard(p_org_id);
2922: Report(l_report);
2923:
2924: ELSE
2925:
2926: FOR k in org_rec LOOP
2927: write_debug_and_log('ORG ID : '||k.org_id);
2928:
2929: mo_global.set_policy_context('S',k.org_id);
2930: arp_standard.init_standard(p_org_id);
2931: Report(l_report);
2932:
2933: END LOOP;
2997: from ar_system_parameters
2998: where org_id = nvl(p_org_id,org_id);
2999: BEGIN
3000:
3001: mo_global.init('AR');
3002: write_debug_and_log('arp_bf_bill.Report1 (+)');
3003:
3004: IF P_org_id is not null THEN
3005:
3003:
3004: IF P_org_id is not null THEN
3005:
3006: write_debug_and_log('ORG ID : '||p_org_id);
3007: mo_global.set_policy_context('S',p_org_id);
3008: arp_standard.init_standard(p_org_id);
3009:
3010: if P_Print_option in ( 'PRINT', 'DRAFT') THEN
3011: l_report.print_option := 'DRAFT';
3053: ELSE
3054:
3055: FOR k in org_rec LOOP
3056:
3057: mo_global.set_policy_context('S',k.org_id);
3058: arp_standard.init_standard(p_org_id);
3059:
3060: if P_Print_option in ( 'PRINT', 'DRAFT') THEN
3061: l_report.print_option := 'DRAFT';