DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on OKS_BILL_UTIL_PUB

Line 47: level_elements_tab Oks_bill_util_pub.level_element_tab;

43: l_pr_tbl_idx Number := 0; /* Lines table */
44: l_prs_tbl_idx Number := 0; /* Sub Lines table */
45:
46: -- Global table for holding number of periods to process
47: level_elements_tab Oks_bill_util_pub.level_element_tab;
48: level_coverage Oks_bill_util_pub.level_element_tab;
49: -- Variables to control log writing and report generation.
50: /*****
51: l_write_log BOOLEAN;

Line 48: level_coverage Oks_bill_util_pub.level_element_tab;

44: l_prs_tbl_idx Number := 0; /* Sub Lines table */
45:
46: -- Global table for holding number of periods to process
47: level_elements_tab Oks_bill_util_pub.level_element_tab;
48: level_coverage Oks_bill_util_pub.level_element_tab;
49: -- Variables to control log writing and report generation.
50: /*****
51: l_write_log BOOLEAN;
52: l_write_report BOOLEAN;

Line 793: OKS_BILL_UTIL_PUB.get_next_level_element(

789:
790: l_processed_lines_tbl(l_pr_tbl_idx).record_type := 'Usage' ;
791: level_elements_tab.delete;
792:
793: OKS_BILL_UTIL_PUB.get_next_level_element(
794: P_API_VERSION => l_api_version,
795: P_ID => p_top_line_id,
796: P_COVD_FLAG => 'N', ---- flag to indicate Top line
797: P_DATE => p_date,

Line 952: OKS_BILL_UTIL_PUB.get_next_level_element(

948:
949: l_ptr := l_ptr + 1;
950: level_coverage.delete;
951:
952: OKS_BILL_UTIL_PUB.get_next_level_element(
953: P_API_VERSION => l_api_version,
954: P_ID => l_covlvl_rec.id,
955: P_COVD_FLAG => 'Y', -- flag to indicate Covered level
956: P_DATE => l_inv_date , --l_bill_end_date,

Line 3814: OKS_BILL_UTIL_PUB.get_next_level_element(

3810:
3811: l_processed_lines_tbl(l_pr_tbl_idx).record_type := 'Usage' ;
3812: level_elements_tab.delete;
3813:
3814: OKS_BILL_UTIL_PUB.get_next_level_element(
3815: P_API_VERSION => l_api_version,
3816: P_ID => p_top_line_id,
3817: P_COVD_FLAG => 'N', ---- flag to indicate Top line
3818: P_DATE => p_date,

Line 3973: OKS_BILL_UTIL_PUB.get_next_level_element(

3969:
3970: l_ptr := l_ptr + 1;
3971: level_coverage.delete;
3972:
3973: OKS_BILL_UTIL_PUB.get_next_level_element(
3974: P_API_VERSION => l_api_version,
3975: P_ID => l_covlvl_rec.id,
3976: P_COVD_FLAG => 'Y', -- flag to indicate Covered level
3977: P_DATE => l_inv_date , --l_bill_end_date,

Line 4718: OKS_BILL_UTIL_PUB.get_next_level_element(

4714: END IF;
4715:
4716: level_elements_tab.delete;
4717:
4718: OKS_BILL_UTIL_PUB.get_next_level_element(
4719: P_API_VERSION => l_api_version,
4720: P_ID => l_covlvl_rec.id,
4721: P_COVD_FLAG => 'Y', ---- flag to indicate covered level
4722: P_DATE => p_date,

Line 4730: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_UTIL_PUB.get_next_level_element l_return_status '||l_return_status);

4726: X_MSG_DATA => l_msg_data,
4727: X_NEXT_LEVEL_ELEMENT => level_elements_tab );
4728:
4729: IF (l_write_log) THEN
4730: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bill_Service_Item => After calling OKS_BILL_UTIL_PUB.get_next_level_element l_return_status '||l_return_status);
4731: END IF;
4732:
4733: IF (l_return_status <> 'S') THEN
4734: oks_bill_rec_pub.get_message

Line 5143: oks_bill_util_pub.get_next_level_element(

5139: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Start Date: ' || p_top_line_start_date);
5140: FND_FILE.PUT_LINE(FND_FILE.LOG,' Top Line Termination Date/End date: ' || nvl(p_top_line_term_date,p_top_line_end_date));
5141: END IF;
5142:
5143: oks_bill_util_pub.get_next_level_element(
5144: p_api_version => l_api_version,
5145: p_id => p_top_line_id,
5146: p_covd_flag => 'N', ---- flag to indicate Top line
5147: p_date => p_date,

Line 6030: OKS_BILL_UTIL_PUB.CREATE_REPORT

6026:
6027: /* *** Create the output file for Billing program. *** */
6028:
6029: If l_write_report then
6030: OKS_BILL_UTIL_PUB.CREATE_REPORT
6031: ( p_billrep_table => l_billrep_tbl
6032: ,p_billrep_err_tbl => l_billrep_err_tbl
6033: ,p_line_from => P_process_from
6034: ,p_line_to => P_process_to