APPS.CN_POST_COLLECTION_TAE_PUB dependencies on CN_PERIODS

Line 46: x_start_period_id IN cn_periods.period_id%TYPE,

42: ( p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: x_start_period_id IN cn_periods.period_id%TYPE,
47: x_end_period_id IN cn_periods.period_id%TYPE,
48: x_conc_program_id IN NUMBER,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,

Line 47: x_end_period_id IN cn_periods.period_id%TYPE,

43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: x_start_period_id IN cn_periods.period_id%TYPE,
47: x_end_period_id IN cn_periods.period_id%TYPE,
48: x_conc_program_id IN NUMBER,
49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,

Line 159: cn_periods_api.set_dates(x_start_period_id, x_end_period_id,l_org_id,l_start_date, l_end_date);

155:
156: l_source_id := -1001;
157: l_trans_object_type_id := -1002;
158: l_org_id:=x_org_id;
159: cn_periods_api.set_dates(x_start_period_id, x_end_period_id,l_org_id,l_start_date, l_end_date);
160: l_where_clause :=' WHERE org_id=to_number('''||l_org_id||''') and txn_date between to_date('''||l_start_date|| ''',''dd-mon-yy'')' || ' and to_date('''|| l_end_date || ''',''dd-mon-yy'') ';
161:
162: BEGIN
163: select version_name