DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_TIME_PUB

Line 5: SUBTYPE tavv_rec_type IS OKC_TIME_PUB.tavv_rec_type;

1: Package body OKC_COPY_CONTRACT_PVT AS
2: /*$Header: OKCRCPYB.pls 120.20.12010000.2 2008/10/24 08:02:16 ssreekum ship $*/
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: SUBTYPE tavv_rec_type IS OKC_TIME_PUB.tavv_rec_type;
6: SUBTYPE talv_evt_rec_type IS OKC_TIME_PUB.talv_evt_rec_type;
7: SUBTYPE tgdv_ext_rec_type IS OKC_TIME_PUB.tgdv_ext_rec_type;
8: SUBTYPE tgnv_rec_type IS OKC_TIME_PUB.tgnv_rec_type;
9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;

Line 6: SUBTYPE talv_evt_rec_type IS OKC_TIME_PUB.talv_evt_rec_type;

2: /*$Header: OKCRCPYB.pls 120.20.12010000.2 2008/10/24 08:02:16 ssreekum ship $*/
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: SUBTYPE tavv_rec_type IS OKC_TIME_PUB.tavv_rec_type;
6: SUBTYPE talv_evt_rec_type IS OKC_TIME_PUB.talv_evt_rec_type;
7: SUBTYPE tgdv_ext_rec_type IS OKC_TIME_PUB.tgdv_ext_rec_type;
8: SUBTYPE tgnv_rec_type IS OKC_TIME_PUB.tgnv_rec_type;
9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;
10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;

Line 7: SUBTYPE tgdv_ext_rec_type IS OKC_TIME_PUB.tgdv_ext_rec_type;

3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: SUBTYPE tavv_rec_type IS OKC_TIME_PUB.tavv_rec_type;
6: SUBTYPE talv_evt_rec_type IS OKC_TIME_PUB.talv_evt_rec_type;
7: SUBTYPE tgdv_ext_rec_type IS OKC_TIME_PUB.tgdv_ext_rec_type;
8: SUBTYPE tgnv_rec_type IS OKC_TIME_PUB.tgnv_rec_type;
9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;
10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;
11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;

Line 8: SUBTYPE tgnv_rec_type IS OKC_TIME_PUB.tgnv_rec_type;

4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: SUBTYPE tavv_rec_type IS OKC_TIME_PUB.tavv_rec_type;
6: SUBTYPE talv_evt_rec_type IS OKC_TIME_PUB.talv_evt_rec_type;
7: SUBTYPE tgdv_ext_rec_type IS OKC_TIME_PUB.tgdv_ext_rec_type;
8: SUBTYPE tgnv_rec_type IS OKC_TIME_PUB.tgnv_rec_type;
9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;
10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;
11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;
12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;

Line 9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;

5: SUBTYPE tavv_rec_type IS OKC_TIME_PUB.tavv_rec_type;
6: SUBTYPE talv_evt_rec_type IS OKC_TIME_PUB.talv_evt_rec_type;
7: SUBTYPE tgdv_ext_rec_type IS OKC_TIME_PUB.tgdv_ext_rec_type;
8: SUBTYPE tgnv_rec_type IS OKC_TIME_PUB.tgnv_rec_type;
9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;
10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;
11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;
12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;
13: SUBTYPE cylv_ext_rec_type IS OKC_TIME_PUB.cylv_ext_rec_type;

Line 10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;

6: SUBTYPE talv_evt_rec_type IS OKC_TIME_PUB.talv_evt_rec_type;
7: SUBTYPE tgdv_ext_rec_type IS OKC_TIME_PUB.tgdv_ext_rec_type;
8: SUBTYPE tgnv_rec_type IS OKC_TIME_PUB.tgnv_rec_type;
9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;
10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;
11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;
12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;
13: SUBTYPE cylv_ext_rec_type IS OKC_TIME_PUB.cylv_ext_rec_type;
14: SUBTYPE spnv_rec_type IS OKC_TIME_PUB.spnv_rec_type;

Line 11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;

7: SUBTYPE tgdv_ext_rec_type IS OKC_TIME_PUB.tgdv_ext_rec_type;
8: SUBTYPE tgnv_rec_type IS OKC_TIME_PUB.tgnv_rec_type;
9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;
10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;
11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;
12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;
13: SUBTYPE cylv_ext_rec_type IS OKC_TIME_PUB.cylv_ext_rec_type;
14: SUBTYPE spnv_rec_type IS OKC_TIME_PUB.spnv_rec_type;
15: SUBTYPE tcuv_rec_type IS OKC_TIME_PUB.tcuv_rec_type;

Line 12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;

8: SUBTYPE tgnv_rec_type IS OKC_TIME_PUB.tgnv_rec_type;
9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;
10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;
11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;
12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;
13: SUBTYPE cylv_ext_rec_type IS OKC_TIME_PUB.cylv_ext_rec_type;
14: SUBTYPE spnv_rec_type IS OKC_TIME_PUB.spnv_rec_type;
15: SUBTYPE tcuv_rec_type IS OKC_TIME_PUB.tcuv_rec_type;
16: SUBTYPE rtvv_rec_type IS OKC_TIME_PUB.rtvv_rec_type;

Line 13: SUBTYPE cylv_ext_rec_type IS OKC_TIME_PUB.cylv_ext_rec_type;

9: SUBTYPE isev_rec_type IS OKC_TIME_PUB.isev_rec_type;
10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;
11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;
12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;
13: SUBTYPE cylv_ext_rec_type IS OKC_TIME_PUB.cylv_ext_rec_type;
14: SUBTYPE spnv_rec_type IS OKC_TIME_PUB.spnv_rec_type;
15: SUBTYPE tcuv_rec_type IS OKC_TIME_PUB.tcuv_rec_type;
16: SUBTYPE rtvv_rec_type IS OKC_TIME_PUB.rtvv_rec_type;
17: sUBTYPE ocev_rec_type IS OKC_OUTCOME_PUB.ocev_rec_type;

Line 14: SUBTYPE spnv_rec_type IS OKC_TIME_PUB.spnv_rec_type;

10: SUBTYPE isev_ext_rec_type IS OKC_TIME_PUB.isev_ext_rec_type;
11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;
12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;
13: SUBTYPE cylv_ext_rec_type IS OKC_TIME_PUB.cylv_ext_rec_type;
14: SUBTYPE spnv_rec_type IS OKC_TIME_PUB.spnv_rec_type;
15: SUBTYPE tcuv_rec_type IS OKC_TIME_PUB.tcuv_rec_type;
16: SUBTYPE rtvv_rec_type IS OKC_TIME_PUB.rtvv_rec_type;
17: sUBTYPE ocev_rec_type IS OKC_OUTCOME_PUB.ocev_rec_type;
18: SUBTYPE oatv_rec_type IS OKC_OUTCOME_PUB.oatv_rec_type;

Line 15: SUBTYPE tcuv_rec_type IS OKC_TIME_PUB.tcuv_rec_type;

11: SUBTYPE isev_rel_rec_type IS OKC_TIME_PUB.isev_rel_rec_type;
12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;
13: SUBTYPE cylv_ext_rec_type IS OKC_TIME_PUB.cylv_ext_rec_type;
14: SUBTYPE spnv_rec_type IS OKC_TIME_PUB.spnv_rec_type;
15: SUBTYPE tcuv_rec_type IS OKC_TIME_PUB.tcuv_rec_type;
16: SUBTYPE rtvv_rec_type IS OKC_TIME_PUB.rtvv_rec_type;
17: sUBTYPE ocev_rec_type IS OKC_OUTCOME_PUB.ocev_rec_type;
18: SUBTYPE oatv_rec_type IS OKC_OUTCOME_PUB.oatv_rec_type;
19: SUBTYPE pavv_rec_type IS OKC_PRICE_ADJUSTMENT_PUB.pavv_rec_type;

Line 16: SUBTYPE rtvv_rec_type IS OKC_TIME_PUB.rtvv_rec_type;

12: SUBTYPE igsv_ext_rec_type IS OKC_TIME_PUB.igsv_ext_rec_type;
13: SUBTYPE cylv_ext_rec_type IS OKC_TIME_PUB.cylv_ext_rec_type;
14: SUBTYPE spnv_rec_type IS OKC_TIME_PUB.spnv_rec_type;
15: SUBTYPE tcuv_rec_type IS OKC_TIME_PUB.tcuv_rec_type;
16: SUBTYPE rtvv_rec_type IS OKC_TIME_PUB.rtvv_rec_type;
17: sUBTYPE ocev_rec_type IS OKC_OUTCOME_PUB.ocev_rec_type;
18: SUBTYPE oatv_rec_type IS OKC_OUTCOME_PUB.oatv_rec_type;
19: SUBTYPE pavv_rec_type IS OKC_PRICE_ADJUSTMENT_PUB.pavv_rec_type;
20: SUBTYPE scnv_rec_type IS OKC_SECTIONS_PUB.scnv_rec_type;

Line 10074: OKC_TIME_PUB.create_tpa_value(

10070: x_tvev_rec => l_tvev_rec);
10071: IF l_tvev_rec.tve_type = 'TAV' THEN
10072: migrate(l_tvev_rec,l_tavv_rec);
10073: l_tavv_rec.dnz_chr_id := p_to_chr_id;
10074: OKC_TIME_PUB.create_tpa_value(
10075: p_api_version => p_api_version,
10076: p_init_msg_list => p_init_msg_list,
10077: x_return_status => l_return_status,
10078: x_msg_count => x_msg_count,

Line 10123: OKC_TIME_PUB.create_tpa_reltv(

10119: ELSE
10120: l_talv_evt_rec.cnh_id := l_cnh_id_temp;
10121: END IF;
10122:
10123: OKC_TIME_PUB.create_tpa_reltv(
10124: p_api_version => p_api_version,
10125: p_init_msg_list => p_init_msg_list,
10126: x_return_status => l_return_status,
10127: x_msg_count => x_msg_count,

Line 10144: OKC_TIME_PUB.create_tpg_delimited(

10140: CLOSE c_tpa_rel;
10141: ELSIF l_tvev_rec.tve_type = 'TGD' THEN
10142: migrate(l_tvev_rec,l_tgdv_ext_rec);
10143: l_tgdv_ext_rec.dnz_chr_id := p_to_chr_id;
10144: OKC_TIME_PUB.create_tpg_delimited(
10145: p_api_version => p_api_version,
10146: p_init_msg_list => p_init_msg_list,
10147: x_return_status => l_return_status,
10148: x_msg_count => x_msg_count,

Line 10187: OKC_TIME_PUB.create_tpg_named(

10183: ELSE
10184: l_talv_evt_rec.cnh_id := l_tvev_rec.cnh_id;
10185: END IF;
10186:
10187: OKC_TIME_PUB.create_tpg_named(
10188: p_api_version => p_api_version,
10189: p_init_msg_list => p_init_msg_list,
10190: x_return_status => l_return_status,
10191: x_msg_count => x_msg_count,

Line 10244: OKC_TIME_PUB.create_ia_startend(

10240: l_isev_ext_rec.dnz_chr_id := p_to_chr_id;
10241:
10242: IF NOT c_isev_ext%NOTFOUND THEN
10243:
10244: OKC_TIME_PUB.create_ia_startend(
10245: p_api_version => p_api_version,
10246: p_init_msg_list => p_init_msg_list,
10247: x_return_status => l_return_status,
10248: x_msg_count => x_msg_count,

Line 10302: OKC_TIME_PUB.create_ia_startend(

10298: l_isev_rel_rec.ATTRIBUTE15;
10299:
10300: l_isev_rel_rec.dnz_chr_id := p_to_chr_id;
10301:
10302: OKC_TIME_PUB.create_ia_startend(
10303: p_api_version => p_api_version,
10304: p_init_msg_list => p_init_msg_list,
10305: x_return_status => l_return_status,
10306: x_msg_count => x_msg_count,

Line 10323: OKC_TIME_PUB.create_ig_startend(

10319: CLOSE c_isev_ext;
10320: ELSIF l_tvev_rec.tve_type = 'IGS' THEN
10321: migrate(l_tvev_rec,l_igsv_ext_rec);
10322: l_igsv_ext_rec.dnz_chr_id := p_to_chr_id;
10323: OKC_TIME_PUB.create_ig_startend(
10324: p_api_version => p_api_version,
10325: p_init_msg_list => p_init_msg_list,
10326: x_return_status => l_return_status,
10327: x_msg_count => x_msg_count,

Line 10341: OKC_TIME_PUB.create_cycle(

10337:
10338: ELSIF l_tvev_rec.tve_type = 'CYL' THEN
10339: migrate(l_tvev_rec,l_cylv_ext_rec);
10340: l_cylv_ext_rec.dnz_chr_id := p_to_chr_id;
10341: OKC_TIME_PUB.create_cycle(
10342: p_api_version => p_api_version,
10343: p_init_msg_list => p_init_msg_list,
10344: x_return_status => l_return_status,
10345: x_msg_count => x_msg_count,

Line 12152: l_p_tavv_tbl OKC_TIME_PUB.TAVV_TBL_TYPE;

12148: l_start_date IN DATE,
12149: l_chr_id IN NUMBER
12150: ) RETURN NUMBER Is
12151:
12152: l_p_tavv_tbl OKC_TIME_PUB.TAVV_TBL_TYPE;
12153: l_x_tavv_tbl OKC_TIME_PUB.TAVV_TBL_TYPE;
12154: l_api_version NUMBER := 1.0;
12155: l_init_msg_list VARCHAR2(1) := 'T';
12156: l_return_status VARCHAR2(200);

Line 12153: l_x_tavv_tbl OKC_TIME_PUB.TAVV_TBL_TYPE;

12149: l_chr_id IN NUMBER
12150: ) RETURN NUMBER Is
12151:
12152: l_p_tavv_tbl OKC_TIME_PUB.TAVV_TBL_TYPE;
12153: l_x_tavv_tbl OKC_TIME_PUB.TAVV_TBL_TYPE;
12154: l_api_version NUMBER := 1.0;
12155: l_init_msg_list VARCHAR2(1) := 'T';
12156: l_return_status VARCHAR2(200);
12157: l_msg_count NUMBER;

Line 12201: okc_time_pub.create_tpa_value

12197: l_p_tavv_tbl(1).last_update_login := NULL;
12198: l_p_tavv_tbl(1).datetime := l_start_date;
12199: l_p_tavv_tbl(1).dnz_chr_id := l_chr_id;
12200:
12201: okc_time_pub.create_tpa_value
12202: (p_api_version => l_api_version,
12203: p_init_msg_list => l_init_msg_list,
12204: x_return_status => l_return_status,
12205: x_msg_count => l_msg_count,