APPS.PA_DEDUCTIONS_PUB dependencies on PA_DEDUCTIONS

Line 1: PACKAGE BODY PA_DEDUCTIONS_PUB AS

1: PACKAGE BODY PA_DEDUCTIONS_PUB AS
2: -- /* $Header: PADCTNPB.pls 120.2.12010000.3 2010/04/15 07:25:23 vchilla noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_DEDUCTIONS_PUB';
5:

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

1: PACKAGE BODY PA_DEDUCTIONS_PUB AS
2: -- /* $Header: PADCTNPB.pls 120.2.12010000.3 2010/04/15 07:25:23 vchilla noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_DEDUCTIONS_PUB';
5:
6: Procedure Create_Deduction_Hdr( p_api_version_number IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
7: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
8: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 119: SELECT PA_DEDUCTIONS_S.nextval

115: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
116: FND_MSG_PUB.initialize;
117: END IF;
118:
119: SELECT PA_DEDUCTIONS_S.nextval
120: INTO l_ded_req_id
121: FROM DUAL;
122:
123: l_dctn_hdrtbl(1).deduction_req_id := l_ded_req_id ;

Line 239: PA_DEDUCTIONS.Create_Deduction_Hdr( l_dctn_hdrtbl

235: l_dctn_hdrtbl(1).status := 'WORKING' ;
236:
237: l_dctn_hdrtbl(1).org_id := p_org_id ;
238:
239: PA_DEDUCTIONS.Create_Deduction_Hdr( l_dctn_hdrtbl
240: ,l_msg_count
241: ,l_msg_data
242: ,l_return_status
243: ,'PUB');

Line 313: CURSOR C1(c_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS

309: ) IS
310:
311: l_dctn_txntbl g_pub_dctn_txn_tbl%TYPE;
312:
313: CURSOR C1(c_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
314: SELECT *
315: FROM PA_DEDUCTIONS_ALL
316: WHERE deduction_req_num = c_deduction_req_num
317: AND status = 'WORKING';

Line 315: FROM PA_DEDUCTIONS_ALL

311: l_dctn_txntbl g_pub_dctn_txn_tbl%TYPE;
312:
313: CURSOR C1(c_deduction_req_num PA_DEDUCTIONS_ALL.deduction_req_num%TYPE) IS
314: SELECT *
315: FROM PA_DEDUCTIONS_ALL
316: WHERE deduction_req_num = c_deduction_req_num
317: AND status = 'WORKING';
318:
319:

Line 484: PA_DEDUCTIONS.Create_Deduction_Txn( l_dctn_txntbl

480: l_dctn_txntbl(1).amount := v_converted_amount; --bug9052223
481: l_dctn_txntbl(1).description := p_description ;
482:
483:
484: PA_DEDUCTIONS.Create_Deduction_Txn( l_dctn_txntbl
485: ,l_msg_count
486: ,l_msg_data
487: ,l_return_status
488: ,'PUB');

Line 531: END PA_DEDUCTIONS_PUB;

527: p_data => p_msg_data );
528:
529: End;
530:
531: END PA_DEDUCTIONS_PUB;