[Home] [Help]
1: PACKAGE BODY DPP_SLA_CLAIM_EXTRACT_PUB as
2: /* $Header: dppclexb.pls 120.9 2011/05/21 00:16:28 hekkiral ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
2: /* $Header: dppclexb.pls 120.9 2011/05/21 00:16:28 hekkiral ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- DPP_SLA_CLAIM_EXTRACT_PUB
7: -- Purpose
8: --
9: -- History
10: --
11: -- NOTE
12: --
13: -- End of Comments
14: -- ===============================================================
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'DPP_SLA_CLAIM_EXTRACT_PUB';
16: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppsce.pls';
17:
18: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
19:
42: p_claim_line_tbl IN claim_line_tbl_type,
43: p_userid IN NUMBER
44: )
45: IS
46: L_API_NAME CONSTANT VARCHAR2(30) := 'DPP_SLA_CLAIM_EXTRACT_PUB';
47: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
48: l_pvt_claim_rec OZF_ClAIM_PVT.claim_rec_type;
49: l_x_pvt_claim_rec OZF_ClAIM_PVT.claim_rec_type;
50: l_claim_line_tbl claim_line_tbl_type := p_claim_line_tbl;
56:
57: l_sql_statement VARCHAR2(200);
58: l_sla_line_tbl_type sla_line_tbl_type;
59: l_processed_flag DPP_XLA_HEADERS.PROCESSED_FLAG%TYPE := 'N';
60: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_SLA_CLAIM_EXTRACT_PUB.CREATE_SLA_EXTRACT';
61:
62: BEGIN
63: -- Standard Start of API savepoint
64: SAVEPOINT CREATE_SLA_Extract_PUB;
271: p_count => x_msg_count,
272: p_data => x_msg_data
273: );
274: End Create_SLA_extract;
275: END DPP_SLA_CLAIM_EXTRACT_PUB;