APPS.CN_COLLECTION_AIA_PUB dependencies on CN_PERIODS

Line 1865: FROM cn_periods

1861:
1862: CURSOR get_start_period_id(l_org_id NUMBER)
1863: IS
1864: SELECT period_id
1865: FROM cn_periods
1866: WHERE period_name = x_start_period_name
1867: AND org_id = l_org_id ;
1868:
1869: CURSOR get_end_period_id(l_org_id NUMBER)

Line 1872: FROM cn_periods

1868:
1869: CURSOR get_end_period_id(l_org_id NUMBER)
1870: IS
1871: SELECT period_id
1872: FROM cn_periods
1873: WHERE period_name = x_end_period_name
1874: AND org_id = l_org_id ;
1875:
1876:

Line 1962: cn_periods_api.set_dates(l_start_period_id, l_end_period_id, x_org_id, x_start_date, x_end_date);

1958: OPEN get_end_period_id(x_org_id); -- open the cursor
1959: FETCH get_end_period_id INTO l_end_period_id; -- fetch data into local variables
1960: CLOSE get_end_period_id;
1961:
1962: cn_periods_api.set_dates(l_start_period_id, l_end_period_id, x_org_id, x_start_date, x_end_date);
1963:
1964: debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: x_start_date: ' || x_start_date);
1965: debugmsg('CN_COLLECTION_AIA_PUB.updaterow_comm_api: x_end_date: ' || x_end_date);
1966: --DBMS_OUTPUT.put_line('x_start_date ' || x_start_date);