DBA Data[Home] [Help]

APPS.PA_INVOICE_DETAIL_PROCESS dependencies on PA_MC_INVOICE_DETAIL_PKG

Line 139: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID

135: ,p_program_application_id =>PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID
136: ,p_program_id => PA_IC_INV_UTILS.G_PROGRAM_ID
137: ,p_user_id => PA_IC_INV_UTILS.G_LAST_UPDATED_BY
138: ,p_login_id => PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN
139: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID
140: ,p_primary_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB);
141:
142: END init;
143:

Line 140: ,p_primary_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB);

136: ,p_program_id => PA_IC_INV_UTILS.G_PROGRAM_ID
137: ,p_user_id => PA_IC_INV_UTILS.G_LAST_UPDATED_BY
138: ,p_login_id => PA_IC_INV_UTILS.G_LAST_UPDATE_LOGIN
139: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID
140: ,p_primary_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB);
141:
142: END init;
143:
144: -- Function to get invoice detail id from sequence

Line 289: l_pa_date := pa_utils2.get_pa_date(P_EI_DATE,SYSDATE, PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID);

285: := P_CC_REC.markup_calc_base_code;
286:
287: /* Bug 2276729 - Begin populating the gl_date also. ** Commented for bug 3857986
288: ***CBGA - Added new parameter org_id to get_pa_date***
289: l_pa_date := pa_utils2.get_pa_date(P_EI_DATE,SYSDATE, PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID);
290: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_date
291: := l_pa_date;
292: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).gl_date
293: := pa_utils2.get_prvdr_gl_date(l_pa_date,PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID, PA_MC_INVOICE_DETAIL_PKG.G_SOB);

Line 293: := pa_utils2.get_prvdr_gl_date(l_pa_date,PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID, PA_MC_INVOICE_DETAIL_PKG.G_SOB);

289: l_pa_date := pa_utils2.get_pa_date(P_EI_DATE,SYSDATE, PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID);
290: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_date
291: := l_pa_date;
292: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).gl_date
293: := pa_utils2.get_prvdr_gl_date(l_pa_date,PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID, PA_MC_INVOICE_DETAIL_PKG.G_SOB);
294:
295: ** Bug 2276729 - End ** Commented for 3857986 - End */
296:
297: /* Added for 3857986 */

Line 308: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID

304: ,p_prvdr_raw_pa_date => NULL
305: ,p_recvr_raw_pa_date => NULL
306: ,p_prvdr_raw_gl_date => NULL
307: ,p_recvr_raw_gl_date => NULL
308: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID
309: ,p_recvr_org_id => NULL
310: ,p_prvdr_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB
311: ,p_recvr_sob_id => NULL
312: ,p_calling_module => 'CCDL'

Line 310: ,p_prvdr_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB

306: ,p_prvdr_raw_gl_date => NULL
307: ,p_recvr_raw_gl_date => NULL
308: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID
309: ,p_recvr_org_id => NULL
310: ,p_prvdr_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB
311: ,p_recvr_sob_id => NULL
312: ,p_calling_module => 'CCDL'
313: ,x_prvdr_pa_date => PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_date
314: ,x_prvdr_pa_period_name => PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_period_name

Line 453: l_pa_date:= pa_utils2.get_pa_date(P_Cdl_rec.EXPENDITURE_ITEM_DATE,SYSDATE, PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID);

449: := NULL;
450:
451: /* Bug 2276729 - Begin populating the gl_date also. ** Commented for 3857986
452: ***CBGA - Added new parameter org_id to get_pa_date***
453: l_pa_date:= pa_utils2.get_pa_date(P_Cdl_rec.EXPENDITURE_ITEM_DATE,SYSDATE, PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID);
454:
455: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_date
456: := l_pa_date;
457: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).gl_date

Line 458: := pa_utils2.get_prvdr_gl_date(l_pa_date,PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID, PA_MC_INVOICE_DETAIL_PKG.G_SOB);

454:
455: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_date
456: := l_pa_date;
457: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).gl_date
458: := pa_utils2.get_prvdr_gl_date(l_pa_date,PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID, PA_MC_INVOICE_DETAIL_PKG.G_SOB);
459:
460: ** Bug 2276729 - End ** Commented for 3857986 End*/
461:
462: /* Added for 3857986 */

Line 473: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID

469: ,p_prvdr_raw_pa_date => NULL
470: ,p_recvr_raw_pa_date => NULL
471: ,p_prvdr_raw_gl_date => NULL
472: ,p_recvr_raw_gl_date => NULL
473: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID
474: ,p_recvr_org_id => NULL
475: ,p_prvdr_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB
476: ,p_recvr_sob_id => NULL
477: ,p_calling_module => 'CCDL'

Line 475: ,p_prvdr_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB

471: ,p_prvdr_raw_gl_date => NULL
472: ,p_recvr_raw_gl_date => NULL
473: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID
474: ,p_recvr_org_id => NULL
475: ,p_prvdr_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB
476: ,p_recvr_sob_id => NULL
477: ,p_calling_module => 'CCDL'
478: ,x_prvdr_pa_date => PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_date
479: ,x_prvdr_pa_period_name => PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_period_name

Line 617: l_pa_date:= pa_utils2.get_pa_date(P_Cdl_rec.EXPENDITURE_ITEM_DATE,SYSDATE, PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID);

613: PA_CC_BL_PROCESS.g_upd_rec(PA_CC_BL_PROCESS.g_ucnt).line_type := 'PC' ;/* Added for Bug 5704206 */
614:
615: /* Bug 2276729 - Begin populating the gl_date also. ** Commented for 3857986
616: ***CBGA - Added new parameter org_id to get_pa_date***
617: l_pa_date:= pa_utils2.get_pa_date(P_Cdl_rec.EXPENDITURE_ITEM_DATE,SYSDATE, PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID);
618: PA_CC_BL_PROCESS.g_upd_rec(PA_CC_BL_PROCESS.g_ucnt).pa_date
619: := l_pa_date;
620: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).gl_date
621: := pa_utils2.get_prvdr_gl_date(l_pa_date,PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID, PA_MC_INVOICE_DETAIL_PKG.G_SOB);

Line 621: := pa_utils2.get_prvdr_gl_date(l_pa_date,PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID, PA_MC_INVOICE_DETAIL_PKG.G_SOB);

617: l_pa_date:= pa_utils2.get_pa_date(P_Cdl_rec.EXPENDITURE_ITEM_DATE,SYSDATE, PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID);
618: PA_CC_BL_PROCESS.g_upd_rec(PA_CC_BL_PROCESS.g_ucnt).pa_date
619: := l_pa_date;
620: PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).gl_date
621: := pa_utils2.get_prvdr_gl_date(l_pa_date,PA_IC_INV_UTILS.G_PROGRAM_APPLICATION_ID, PA_MC_INVOICE_DETAIL_PKG.G_SOB);
622: ** Bug 2276729 - End ** Commented for 3857986 */
623:
624: /* Added for 3857986 */
625: BEGIN

Line 635: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID

631: ,p_prvdr_raw_pa_date => NULL
632: ,p_recvr_raw_pa_date => NULL
633: ,p_prvdr_raw_gl_date => NULL
634: ,p_recvr_raw_gl_date => NULL
635: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID
636: ,p_recvr_org_id => NULL
637: ,p_prvdr_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB
638: ,p_recvr_sob_id => NULL
639: ,p_calling_module => 'CCDL'

Line 637: ,p_prvdr_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB

633: ,p_prvdr_raw_gl_date => NULL
634: ,p_recvr_raw_gl_date => NULL
635: ,p_prvdr_org_id => PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID
636: ,p_recvr_org_id => NULL
637: ,p_prvdr_sob_id => PA_MC_INVOICE_DETAIL_PKG.G_SOB
638: ,p_recvr_sob_id => NULL
639: ,p_calling_module => 'CCDL'
640: ,x_prvdr_pa_date => PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_date
641: ,x_prvdr_pa_period_name => PA_CC_BL_PROCESS.g_ins_rec(PA_CC_BL_PROCESS.g_icnt).pa_period_name

Line 1014: l_inv_rec.org_id := PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID;

1010: l_inv_rec.prov_proj_bill_job_id := I_prov_proj_bill_job_id(P_Arr_position);
1011:
1012:
1013: /* Bug #1374381 Assigned the org_id for inert into pa_draft_invoice_details table*/
1014: l_inv_rec.org_id := PA_MC_INVOICE_DETAIL_PKG.G_ORG_ID;
1015:
1016: /*Added for cross proj */
1017: l_inv_rec.tp_amt_type_code := I_tp_amt_type_code(P_Arr_position);
1018: l_inv_rec.project_tp_rate_type := I_project_tp_rate_type(P_Arr_position);