DBA Data[Home] [Help]

APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT

Line 1: PACKAGE JAI_FBT_SETTLEMENT_P AS

1: PACKAGE JAI_FBT_SETTLEMENT_P AS
2: --$Header: jainfbtset.pls 120.0 2007/12/24 13:07:53 eaggarwa noship $
3: --+=======================================================================+
4: --| Copyright (c) 1998 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 9: --| jai_fbt_settlement_p.pls |

5: --| Redwood Shores, CA, USA |
6: --| All rights reserved. |
7: --+=======================================================================+
8: --| FILENAME |
9: --| jai_fbt_settlement_p.pls |
10: --| |
11: --| DESCRIPTION |
12: --| To be called by the concurrent program for inserting the |
13: --| data into jai_fbt_settlement table and ap interface tables |

Line 13: --| data into jai_fbt_settlement table and ap interface tables |

9: --| jai_fbt_settlement_p.pls |
10: --| |
11: --| DESCRIPTION |
12: --| To be called by the concurrent program for inserting the |
13: --| data into jai_fbt_settlement table and ap interface tables |
14: --| |
15: --| PROCEDURE LIST |
16: --| PROCEDURE Fbt_Settlement |
17: --| |

Line 24: GV_MODULE_PREFIX VARCHAR2(50) :='jai.plsql.JAI_FBT_SETTLEMENT_P';

20: --| |
21: --+======================================================================*/
22:
23: -- Declare global variable for package name
24: GV_MODULE_PREFIX VARCHAR2(50) :='jai.plsql.JAI_FBT_SETTLEMENT_P';
25: GV_DATE_MASK CONSTANT VARCHAR2(25):= 'DD-MON-YYYY';
26: -- type for ap_invoices_interface
27: TYPE inv_interface_rec_type IS RECORD
28: ( invoice_id ap_invoices_interface.invoice_id%TYPE

Line 73: -- program for inserting the data into jai_fbt_settlement table and

69: --
70: -- DESCRIPTION:
71: --
72: -- This is the main procedure which will be called by the concurrent
73: -- program for inserting the data into jai_fbt_settlement table and
74: -- ap interface tables
75: --
76: -- PARAMETERS:
77: -- In: pn_legal_entity_id Identifier of legal entity

Line 98: , pn_legal_entity_id IN jai_fbt_settlement.legal_entity_id%TYPE

94:
95: PROCEDURE Fbt_Settlement
96: ( pv_errbuf OUT NOCOPY VARCHAR2
97: , pv_retcode OUT NOCOPY VARCHAR2
98: , pn_legal_entity_id IN jai_fbt_settlement.legal_entity_id%TYPE
99: , pv_start_date IN VARCHAR2
100: , pv_end_date IN VARCHAR2
101: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE
102: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE

Line 101: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE

97: , pv_retcode OUT NOCOPY VARCHAR2
98: , pn_legal_entity_id IN jai_fbt_settlement.legal_entity_id%TYPE
99: , pv_start_date IN VARCHAR2
100: , pv_end_date IN VARCHAR2
101: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE
102: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE
103: , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE
104: );
105:

Line 102: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE

98: , pn_legal_entity_id IN jai_fbt_settlement.legal_entity_id%TYPE
99: , pv_start_date IN VARCHAR2
100: , pv_end_date IN VARCHAR2
101: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE
102: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE
103: , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE
104: );
105:
106: END JAI_FBT_SETTLEMENT_P;

Line 103: , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE

99: , pv_start_date IN VARCHAR2
100: , pv_end_date IN VARCHAR2
101: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE
102: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE
103: , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE
104: );
105:
106: END JAI_FBT_SETTLEMENT_P;

Line 106: END JAI_FBT_SETTLEMENT_P;

102: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE
103: , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE
104: );
105:
106: END JAI_FBT_SETTLEMENT_P;