DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_REQCHANGEREQUESTNOTIF_PVT

Line 1: PACKAGE BODY PO_ReqChangeRequestNotif_PVT AS

1: PACKAGE BODY PO_ReqChangeRequestNotif_PVT AS
2: /* $Header: POXVRCNB.pls 120.15 2006/10/03 13:40:28 kikhlaq noship $ */
3:
4: /*************************************************************************
5: * +=======================================================================+

Line 11: * | PACKAGE NAME: PO_ReqChangeRequestNotif_PVT |

7: * | All rights reserved. |
8: * +=======================================================================+
9: * | FILE NAME: POXVRCNB.pls |
10: * | |
11: * | PACKAGE NAME: PO_ReqChangeRequestNotif_PVT |
12: * | |
13: * | DESCRIPTION: |
14: * | PO_ReqChangeRequestNotif_PVT is a private level package. |
15: * | It contains 3 public procedure which are used to generate |

Line 14: * | PO_ReqChangeRequestNotif_PVT is a private level package. |

10: * | |
11: * | PACKAGE NAME: PO_ReqChangeRequestNotif_PVT |
12: * | |
13: * | DESCRIPTION: |
14: * | PO_ReqChangeRequestNotif_PVT is a private level package. |
15: * | It contains 3 public procedure which are used to generate |
16: * | notifications used in requester change order workflows. |
17: * | |
18: * | PROCEDURES: |

Line 34: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_REQCHANGEREQUESTNOTIF_PVT';

30: * +=======================================================================+
31: */
32:
33: NL VARCHAR2(1) := fnd_global.newline;
34: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_REQCHANGEREQUESTNOTIF_PVT';
35: G_FILE_NAME CONSTANT VARCHAR2(30) := 'POXVRCNB.pls';
36:
37: -- Read the profile option that enables/disables the debug log
38: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

Line 3183: PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount(grp_id,

3179: *pll.price_override))) old_amount,
3180: nvl(pcr.new_amount,
3181: decode(pcr.document_line_location_id,
3182: null, null, /* the calcuated amount will show at shipment level */
3183: PO_ReqChangeRequestNotif_PVT.get_goods_shipment_new_amount(grp_id,
3184: pol.po_line_id, pcr.document_line_location_id,
3185: nvl(pcr.old_price, nvl(pll.price_override, pol.unit_price)),
3186: (nvl(pll.quantity,0)-nvl(pll.quantity_cancelled,0)))))
3187: from po_change_requests pcr,

Line 4495: END PO_ReqChangeRequestNotif_PVT;

4491: raise;
4492:
4493: END Get_Currency_Info;
4494:
4495: END PO_ReqChangeRequestNotif_PVT;