DBA Data[Home] [Help]

APPS.OKC_EXTEND_PVT dependencies on OKC_TIME_PUB

Line 932: l_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;

928: p_new_end_date IN DATE ) is
929:
930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
931:
932: l_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;
933: i_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;
934:
935: l_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
936: i_isev_rec OKC_TIME_PUB.isev_ext_rec_type;

Line 933: i_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;

929:
930: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
931:
932: l_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;
933: i_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;
934:
935: l_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
936: i_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
937:

Line 935: l_isev_rec OKC_TIME_PUB.isev_ext_rec_type;

931:
932: l_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;
933: i_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;
934:
935: l_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
936: i_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
937:
938: CURSOR CUR_TIME_VALUES (p_tve_id in okc_timevalues.id%type)is
939: SELECT id,object_version_number

Line 936: i_isev_rec OKC_TIME_PUB.isev_ext_rec_type;

932: l_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;
933: i_tavv_ext_rec OKC_TIME_PUB.tavv_rec_type;
934:
935: l_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
936: i_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
937:
938: CURSOR CUR_TIME_VALUES (p_tve_id in okc_timevalues.id%type)is
939: SELECT id,object_version_number
940: FROM okc_timevalues

Line 987: OKC_TIME_PUB.lock_ia_startend(p_api_version => 1,

983: l_isev_rec.id := l_id;
984: l_isev_rec.object_version_number := l_object_version_number;
985: l_isev_rec.end_date := p_new_end_date;
986:
987: OKC_TIME_PUB.lock_ia_startend(p_api_version => 1,
988: p_init_msg_list => OKC_API.G_FALSE,
989: x_return_status => l_return_status,
990: x_msg_count => x_msg_count,
991: x_msg_data => x_msg_data,

Line 1001: OKC_TIME_PUB.update_ia_startend(p_api_version => 1,

997: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
998: RAISE OKC_API.G_EXCEPTION_ERROR;
999: END IF;
1000:
1001: OKC_TIME_PUB.update_ia_startend(p_api_version => 1,
1002: p_init_msg_list => OKC_API.G_FALSE,
1003: x_return_status => l_return_status,
1004: x_msg_count => x_msg_count,
1005: x_msg_data => x_msg_data,

Line 1035: OKC_TIME_PUB.lock_tpa_value( p_api_version => 1,

1031: l_tavv_ext_rec.object_version_number := l_object_version_number;
1032: l_tavv_ext_rec.datetime := p_new_end_date;
1033:
1034:
1035: OKC_TIME_PUB.lock_tpa_value( p_api_version => 1,
1036: p_init_msg_list => okc_api.g_false,
1037: x_return_status => l_return_status,
1038: x_msg_count => x_msg_count,
1039: x_msg_data => x_msg_data,

Line 1050: OKC_TIME_PUB.update_tpa_value(p_api_version => 1,

1046: RAISE OKC_API.G_EXCEPTION_ERROR;
1047: END IF;
1048:
1049:
1050: OKC_TIME_PUB.update_tpa_value(p_api_version => 1,
1051: p_init_msg_list => okc_api.g_false,
1052: x_return_status => l_return_status,
1053: x_msg_count => x_msg_count,
1054: x_msg_data => x_msg_data,

Line 1080: OKC_TIME_PUB.lock_ia_startend(p_api_version => 1,

1076: l_isev_rec.id := l_id;
1077: l_isev_rec.object_version_number := l_object_version_number;
1078: l_isev_rec.end_date := p_new_end_date;
1079:
1080: OKC_TIME_PUB.lock_ia_startend(p_api_version => 1,
1081: p_init_msg_list => OKC_API.G_FALSE,
1082: x_return_status => l_return_status,
1083: x_msg_count => x_msg_count,
1084: x_msg_data => x_msg_data,

Line 1095: OKC_TIME_PUB.update_ia_startend(p_api_version => 1,

1091: RAISE OKC_API.G_EXCEPTION_ERROR;
1092: END IF;
1093:
1094:
1095: OKC_TIME_PUB.update_ia_startend(p_api_version => 1,
1096: p_init_msg_list => OKC_API.G_FALSE,
1097: x_return_status => l_return_status,
1098: x_msg_count => x_msg_count,
1099: x_msg_data => x_msg_data,