DBA Data[Home] [Help]

APPS.PA_MC_INVOICE_DETAIL_PKG dependencies on PA_INVOICE_DETAIL_PKG

Line 35: PROCEDURE download ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,

31: THEN
32: RAISE;
33: END get_orig_exchg_rate;
34:
35: PROCEDURE download ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
36: P_record_cnt IN number,
37: P_Draft_inv_det_id OUT NOCOPY PA_PLSQL_DATATYPES.numtabtyp)
38: IS
39: BEGIN

Line 46: PROCEDURE compute_mrc (P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,

42: P_Draft_inv_det_id(I) := P_inv_rec_tab(I).DRAFT_INVOICE_DETAIL_ID;
43: END LOOP;
44: END download;
45:
46: PROCEDURE compute_mrc (P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
47: P_trx_date IN PA_PLSQL_DATATYPES.DateTabTyp,
48: P_rec_counter IN NUMBER,
49: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp,
50: P_tot_record OUT NOCOPY NUMBER ) --File.Sql.39 bug 4440895

Line 258: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab)

254: /* This procedure is called from Intercompany invoice process. This will
255: create MRC records for Invoice details */
256:
257: PROCEDURE Insert_rows
258: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab)
259: IS
260: l_tot_count NUMBER;
261: l_mrc_reqd_flag PA_PLSQL_DATATYPES.Char1TabTyp;
262: c number;

Line 271: If ( PA_INVOICE_DETAIL_PKG.G_Ins_count > 0 )

267: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert...');
268: END IF;
269:
270: /* Compute the MRC amount and populate the global array */
271: If ( PA_INVOICE_DETAIL_PKG.G_Ins_count > 0 )
272: Then
273: compute_mrc(P_inv_rec_tab,l_trx_date,PA_INVOICE_DETAIL_PKG.G_Ins_count,
274: l_mrc_reqd_flag,l_tot_count);
275: c := 10;

Line 273: compute_mrc(P_inv_rec_tab,l_trx_date,PA_INVOICE_DETAIL_PKG.G_Ins_count,

269:
270: /* Compute the MRC amount and populate the global array */
271: If ( PA_INVOICE_DETAIL_PKG.G_Ins_count > 0 )
272: Then
273: compute_mrc(P_inv_rec_tab,l_trx_date,PA_INVOICE_DETAIL_PKG.G_Ins_count,
274: l_mrc_reqd_flag,l_tot_count);
275: c := 10;
276: IF g1_debug_mode = 'Y' THEN
277: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert..'||to_char(l_tot_count));

Line 360: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,

356:
357: /* This procedure is called from MRC upgrade. In this case, transaction
358: date is suuplied as parameter */
359: PROCEDURE Insert_rows
360: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
361: P_trx_date IN PA_PLSQL_DATATYPES.DateTabTyp)
362: IS
363: l_tot_count NUMBER;
364: l_mrc_reqd_flag PA_PLSQL_DATATYPES.Char1TabTyp;

Line 372: If ( PA_INVOICE_DETAIL_PKG.G_Ins_count > 0 )

368: IF g1_debug_mode = 'Y' THEN
369: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert...');
370: END IF;
371: /* Compute the MRC amount and populate the global array */
372: If ( PA_INVOICE_DETAIL_PKG.G_Ins_count > 0 )
373: Then
374: compute_mrc(P_inv_rec_tab,P_trx_date,PA_INVOICE_DETAIL_PKG.G_Ins_count,
375: l_mrc_reqd_flag,l_tot_count);
376: c := 10;

Line 374: compute_mrc(P_inv_rec_tab,P_trx_date,PA_INVOICE_DETAIL_PKG.G_Ins_count,

370: END IF;
371: /* Compute the MRC amount and populate the global array */
372: If ( PA_INVOICE_DETAIL_PKG.G_Ins_count > 0 )
373: Then
374: compute_mrc(P_inv_rec_tab,P_trx_date,PA_INVOICE_DETAIL_PKG.G_Ins_count,
375: l_mrc_reqd_flag,l_tot_count);
376: c := 10;
377: IF g1_debug_mode = 'Y' THEN
378: PA_IC_INV_UTILS.log_message('Insert_rows: ' || 'In MRC Insert..'||to_char(l_tot_count));

Line 447: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,

443:
444: END Insert_rows;
445:
446: PROCEDURE Update_rows
447: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab,
448: P_mrc_reqd_flag IN PA_PLSQL_DATATYPES.Char1TabTyp)
449: IS
450: l_tot_count NUMBER;
451: l_trx_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 457: If ( PA_INVOICE_DETAIL_PKG.G_Upd_count > 0)

453:
454: IF g1_debug_mode = 'Y' THEN
455: PA_IC_INV_UTILS.log_message('Update_rows: ' || 'In MRC Update...');
456: END IF;
457: If ( PA_INVOICE_DETAIL_PKG.G_Upd_count > 0)
458: Then
459: compute_mrc(P_inv_rec_tab,l_trx_date,PA_INVOICE_DETAIL_PKG.G_Upd_count,
460: P_mrc_reqd_flag,l_tot_count);
461:

Line 459: compute_mrc(P_inv_rec_tab,l_trx_date,PA_INVOICE_DETAIL_PKG.G_Upd_count,

455: PA_IC_INV_UTILS.log_message('Update_rows: ' || 'In MRC Update...');
456: END IF;
457: If ( PA_INVOICE_DETAIL_PKG.G_Upd_count > 0)
458: Then
459: compute_mrc(P_inv_rec_tab,l_trx_date,PA_INVOICE_DETAIL_PKG.G_Upd_count,
460: P_mrc_reqd_flag,l_tot_count);
461:
462:
463: End if;

Line 473: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab)

469:
470: END Update_rows;
471:
472: PROCEDURE Delete_rows
473: ( P_inv_rec_tab IN PA_INVOICE_DETAIL_PKG.inv_rec_tab)
474: IS
475: l_draft_line_id PA_PLSQL_DATATYPES.numtabtyp;
476: BEGIN
477:

Line 481: If ( PA_INVOICE_DETAIL_PKG.G_Del_count > 0)

477:
478: IF g1_debug_mode = 'Y' THEN
479: PA_IC_INV_UTILS.log_message('Delete_rows: ' || 'In MRC Delete...');
480: END IF;
481: If ( PA_INVOICE_DETAIL_PKG.G_Del_count > 0)
482: Then
483: download(P_inv_rec_tab,PA_INVOICE_DETAIL_PKG.G_Del_count,l_draft_line_id);
484:
485:

Line 483: download(P_inv_rec_tab,PA_INVOICE_DETAIL_PKG.G_Del_count,l_draft_line_id);

479: PA_IC_INV_UTILS.log_message('Delete_rows: ' || 'In MRC Delete...');
480: END IF;
481: If ( PA_INVOICE_DETAIL_PKG.G_Del_count > 0)
482: Then
483: download(P_inv_rec_tab,PA_INVOICE_DETAIL_PKG.G_Del_count,l_draft_line_id);
484:
485:
486: End if;
487: