DBA Data[Home] [Help]

APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_SETTLEMENT_DOC_PVT

Line 1: PACKAGE BODY OZF_SETTLEMENT_DOC_PVT AS

1: PACKAGE BODY OZF_SETTLEMENT_DOC_PVT AS
2: /* $Header: ozfvcsdb.pls 120.24.12010000.5 2008/10/16 08:47:04 psomyaju ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_Settlement_Doc_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvcsdb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_Settlement_Doc_PVT';

1: PACKAGE BODY OZF_SETTLEMENT_DOC_PVT AS
2: /* $Header: ozfvcsdb.pls 120.24.12010000.5 2008/10/16 08:47:04 psomyaju ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_Settlement_Doc_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvcsdb.pls';
6:
7: OZF_DEBUG_HIGH_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
8: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

Line 137: l_settlement_doc_tbl OZF_SETTLEMENT_DOC_PVT.settlement_doc_tbl_type;

133: l_api_name CONSTANT VARCHAR2(30) := 'Update_Payment_Detail';
134: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
135: l_return_status VARCHAR2(1);
136:
137: l_settlement_doc_tbl OZF_SETTLEMENT_DOC_PVT.settlement_doc_tbl_type;
138: l_counter NUMBER := 1;
139: l_settlement_doc_id NUMBER;
140: l_claim_obj_ver_num NUMBER;
141: l_upd_claim_status BOOLEAN := FALSE;

Line 613: OZF_SETTLEMENT_DOC_PVT.Create_Settlement_Doc(

609: FOR j IN l_settlement_doc_tbl.FIRST..l_settlement_doc_tbl.LAST LOOP
610: IF ((l_settlement_doc_tbl(j).settlement_id IS NOT NULL AND
611: l_settlement_doc_tbl(j).settlement_id <> FND_API.G_miss_num)
612: OR (l_settlement_doc_tbl(1).payment_method = 'ACCOUNTING_ONLY')) THEN
613: OZF_SETTLEMENT_DOC_PVT.Create_Settlement_Doc(
614: p_api_version_number => l_api_version,
615: p_init_msg_list => p_init_msg_list,
616: p_commit => p_commit,
617: p_validation_level => p_validation_level,

Line 643: OZF_SETTLEMENT_DOC_PVT.Update_Settlement_Doc(

639: OPEN csr_settle_doc_obj_ver(l_settlement_doc_tbl(j).settlement_doc_id);
640: FETCH csr_settle_doc_obj_ver INTO l_settlement_doc_tbl(j).object_version_number;
641: CLOSE csr_settle_doc_obj_ver;
642: l_settlement_doc_tbl(j).payment_status := 'PAID';
643: OZF_SETTLEMENT_DOC_PVT.Update_Settlement_Doc(
644: p_api_version_number => l_api_version,
645: p_init_msg_list => p_init_msg_list,
646: p_commit => p_commit,
647: p_validation_level => p_validation_level,

Line 6372: l_settlement_doc_rec OZF_Settlement_Doc_PVT.settlement_doc_rec_type;

6368: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
6369: l_return_status VARCHAR2(1);
6370:
6371: l_object_version_number NUMBER;
6372: l_settlement_doc_rec OZF_Settlement_Doc_PVT.settlement_doc_rec_type;
6373:
6374: BEGIN
6375: ----------------------- initialize --------------------
6376: IF OZF_DEBUG_HIGH_ON THEN

Line 6544: OZF_SETTLEMENT_DOC_PVT.Create_Settlement_Doc(

6540: For i in 1..p_settlement_doc_tbl.count LOOP
6541:
6542: l_settlement_doc := p_settlement_doc_tbl(i);
6543:
6544: OZF_SETTLEMENT_DOC_PVT.Create_Settlement_Doc(
6545: p_api_version_number => 1.0,
6546: p_init_msg_list => FND_API.G_FALSE,
6547: p_commit => FND_API.G_FALSE,
6548: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 6664: OZF_SETTLEMENT_DOC_PVT.Update_Settlement_Doc(

6660: For i in 1..p_settlement_doc_tbl.count LOOP
6661:
6662: l_settlement_doc := p_settlement_doc_tbl(i);
6663:
6664: OZF_SETTLEMENT_DOC_PVT.Update_Settlement_Doc(
6665: p_api_version_number => l_api_version,
6666: p_init_msg_list => FND_API.G_FALSE,
6667: p_commit => FND_API.G_FALSE,
6668: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 6727: END OZF_SETTLEMENT_DOC_PVT;

6723: );
6724: END Update_Settlement_Doc_Tbl;
6725:
6726:
6727: END OZF_SETTLEMENT_DOC_PVT;