APPS.PO_CHARGES_GRP dependencies on PO_CHARGES_GRP

Line 1: PACKAGE BODY PO_CHARGES_GRP AS

1: PACKAGE BODY PO_CHARGES_GRP AS
2: /* $Header: POXGFSCB.pls 120.16.12010000.8 2010/01/26 00:39:29 vthevark ship $*/
3:
4: -- package globals
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_CHARGES_GRP';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_CHARGES_GRP';

1: PACKAGE BODY PO_CHARGES_GRP AS
2: /* $Header: POXGFSCB.pls 120.16.12010000.8 2010/01/26 00:39:29 vthevark ship $*/
3:
4: -- package globals
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_CHARGES_GRP';
6: G_LOG_MODULE CONSTANT VARCHAR2(40) := 'po.plsql.' || G_PKG_NAME;
7: G_CONC_LOG VARCHAR2(32767);
8:
9: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790: rcv debug enhancement

Line 895: FOR l_ap_po_charge_distribution in po_charges_grp.ap_po_charge_distributions_csr LOOP --{

891: asn_debug.put_line('Entering extract AP charges program.');
892: END IF;
893:
894:
895: FOR l_ap_po_charge_distribution in po_charges_grp.ap_po_charge_distributions_csr LOOP --{
896:
897: IF (g_asn_debug = 'Y') THEN
898: asn_debug.put_line('Inside the cursor loop.');
899: asn_debug.put_line('Charge cursor has '||

Line 900: po_charges_grp.ap_po_charge_distributions_csr%rowcount||' rows.');

896:
897: IF (g_asn_debug = 'Y') THEN
898: asn_debug.put_line('Inside the cursor loop.');
899: asn_debug.put_line('Charge cursor has '||
900: po_charges_grp.ap_po_charge_distributions_csr%rowcount||' rows.');
901: END IF;
902:
903: Process_AP_Actual_Charges(l_ap_po_charge_distribution,l_charge_table,
904: l_charge_alloc_table ,k);

Line 916: FOR l_ap_rcv_charge_distribution in po_charges_grp.ap_rcv_charge_distr_csr LOOP --{

912: ||l_charge_table.COUNT||' of them are new charges');
913: END IF;
914:
915:
916: FOR l_ap_rcv_charge_distribution in po_charges_grp.ap_rcv_charge_distr_csr LOOP --{
917:
918: IF (g_asn_debug = 'Y') THEN
919: asn_debug.put_line('Inside the cursor loop.');
920: asn_debug.put_line('Charge cursor has '||

Line 921: po_charges_grp.ap_rcv_charge_distr_csr%rowcount||' rows.');

917:
918: IF (g_asn_debug = 'Y') THEN
919: asn_debug.put_line('Inside the cursor loop.');
920: asn_debug.put_line('Charge cursor has '||
921: po_charges_grp.ap_rcv_charge_distr_csr%rowcount||' rows.');
922: END IF;
923:
924: Process_AP_Actual_Charges(l_ap_rcv_charge_distribution,
925: l_charge_table,l_charge_alloc_table ,k);

Line 973: , message => 'Error in PO_CHARGES_GRP.Extract_AP_Actual_Charges: ' || SQLERRM

969: EXCEPTION
970: WHEN OTHERS THEN
971: string( log_level => FND_LOG.LEVEL_UNEXPECTED
972: , module => G_LOG_MODULE
973: , message => 'Error in PO_CHARGES_GRP.Extract_AP_Actual_Charges: ' || SQLERRM
974: );
975: G_CONC_LOG := G_CONC_LOG || 'AP Charge Extraction failed'|| FND_GLOBAL.local_chr(10);
976: errbuf := G_CONC_LOG;
977: retcode := 2;

Line 978: CLOSE po_charges_grp.ap_po_charge_distributions_csr;

974: );
975: G_CONC_LOG := G_CONC_LOG || 'AP Charge Extraction failed'|| FND_GLOBAL.local_chr(10);
976: errbuf := G_CONC_LOG;
977: retcode := 2;
978: CLOSE po_charges_grp.ap_po_charge_distributions_csr;
979: CLOSE po_charges_grp.ap_rcv_charge_distr_csr;
980:
981: END Extract_AP_Actual_Charges;
982:

Line 979: CLOSE po_charges_grp.ap_rcv_charge_distr_csr;

975: G_CONC_LOG := G_CONC_LOG || 'AP Charge Extraction failed'|| FND_GLOBAL.local_chr(10);
976: errbuf := G_CONC_LOG;
977: retcode := 2;
978: CLOSE po_charges_grp.ap_po_charge_distributions_csr;
979: CLOSE po_charges_grp.ap_rcv_charge_distr_csr;
980:
981: END Extract_AP_Actual_Charges;
982:
983: PROCEDURE Process_AP_Actual_Charges

Line 985: l_ap_charge_distribution IN OUT NOCOPY po_charges_grp.ap_po_charge_distributions_csr%ROWTYPE,

981: END Extract_AP_Actual_Charges;
982:
983: PROCEDURE Process_AP_Actual_Charges
984: (
985: l_ap_charge_distribution IN OUT NOCOPY po_charges_grp.ap_po_charge_distributions_csr%ROWTYPE,
986: l_charge_table IN OUT NOCOPY CHARGE_TABLE_TYPE,
987: l_charge_alloc_table IN OUT NOCOPY CHARGE_ALLOCATION_TABLE_TYPE,
988: k IN OUT NOCOPY number
989: )

Line 1175: , message => 'Error in PO_CHARGES_GRP.Process_AP_Actual_Charges: ' || SQLERRM

1171: EXCEPTION
1172: WHEN OTHERS THEN
1173: string( log_level => FND_LOG.LEVEL_UNEXPECTED
1174: , module => G_LOG_MODULE
1175: , message => 'Error in PO_CHARGES_GRP.Process_AP_Actual_Charges: ' || SQLERRM
1176: );
1177:
1178: END Process_AP_Actual_Charges;
1179:

Line 1180: END PO_CHARGES_GRP;

1176: );
1177:
1178: END Process_AP_Actual_Charges;
1179:
1180: END PO_CHARGES_GRP;
1181: