eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_RCV_ACCOUNTING_PKG dependencies on GMF_RCV_ACCOUNTING_PKG

Line 1: PACKAGE BODY GMF_RCV_ACCOUNTING_PKG AS

1: PACKAGE BODY GMF_RCV_ACCOUNTING_PKG AS
2: /* $Header: gmfrcvab.pls 120.7 2010/08/27 13:19:43 uphadtar ship $ */
3:
4: /**************************
5: * Package Level Constants *

Line 7: MODULE CONSTANT VARCHAR2(80) := 'gmf.plsql.gmf_rcv_accounting_pkg';

3:
4: /**************************
5: * Package Level Constants *
6: **************************/
7: MODULE CONSTANT VARCHAR2(80) := 'gmf.plsql.gmf_rcv_accounting_pkg';
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_RCV_ACCOUNTING_PKG';
9: G_DEBUG CONSTANT VARCHAR2(10) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'gmf.plsql.'||G_PKG_NAME;
11:

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_RCV_ACCOUNTING_PKG';

4: /**************************
5: * Package Level Constants *
6: **************************/
7: MODULE CONSTANT VARCHAR2(80) := 'gmf.plsql.gmf_rcv_accounting_pkg';
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMF_RCV_ACCOUNTING_PKG';
9: G_DEBUG CONSTANT VARCHAR2(10) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'gmf.plsql.'||G_PKG_NAME;
11:
12: /**********************************************************************************************

Line 53: p_rcv_accttxn IN GMF_RCV_ACCOUNTING_PKG.rcv_accttxn_rec_type,

49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: p_rcv_accttxn IN GMF_RCV_ACCOUNTING_PKG.rcv_accttxn_rec_type,
54: x_transaction_amount OUT NOCOPY NUMBER
55: )
56: IS
57: l_api_name CONSTANT VARCHAR2(30) := 'Get_TransactionAmount';

Line 446: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

442: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
443: x_return_status OUT NOCOPY VARCHAR2,
444: x_msg_count OUT NOCOPY NUMBER,
445: x_msg_data OUT NOCOPY VARCHAR2,
446: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
447: x_source_doc_quantity OUT NOCOPY NUMBER
448: )
449: IS
450: l_api_name CONSTANT VARCHAR2 (30) := 'Get_Quantity';

Line 785: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

781: := fnd_api.g_valid_level_full,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2,
785: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
786: p_asset_item_pricing_option IN NUMBER,
787: p_expense_item_pricing_option IN NUMBER,
788: x_intercompany_pricing_option OUT NOCOPY NUMBER,
789: x_unit_price OUT NOCOPY NUMBER,

Line 1216: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

1212: := fnd_api.g_valid_level_full,
1213: x_return_status OUT NOCOPY VARCHAR2,
1214: x_msg_count OUT NOCOPY NUMBER,
1215: x_msg_data OUT NOCOPY VARCHAR2,
1216: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
1217: x_unit_nr_tax OUT NOCOPY NUMBER,
1218: x_unit_rec_tax OUT NOCOPY NUMBER,
1219: x_prior_nr_tax OUT NOCOPY NUMBER,
1220: x_prior_rec_tax OUT NOCOPY NUMBER

Line 1508: p_event_rec IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

1504: := fnd_api.g_valid_level_full,
1505: x_return_status OUT NOCOPY VARCHAR2,
1506: x_msg_count OUT NOCOPY NUMBER,
1507: x_msg_data OUT NOCOPY VARCHAR2,
1508: p_event_rec IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
1509: x_transaction_qty OUT NOCOPY NUMBER,
1510: x_primary_uom OUT NOCOPY mtl_units_of_measure.unit_of_measure%TYPE,
1511: x_primary_qty OUT NOCOPY NUMBER,
1512: x_trx_uom_code OUT NOCOPY VARCHAR2

Line 1822: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

1818: := fnd_api.g_valid_level_full,
1819: x_return_status OUT NOCOPY VARCHAR2,
1820: x_msg_count OUT NOCOPY NUMBER,
1821: x_msg_data OUT NOCOPY VARCHAR2,
1822: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
1823: x_currency_code OUT NOCOPY VARCHAR2,
1824: x_currency_conversion_rate OUT NOCOPY NUMBER,
1825: x_currency_conversion_date OUT NOCOPY DATE,
1826: x_currency_conversion_type OUT NOCOPY VARCHAR2

Line 2098: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

2094: := fnd_api.g_valid_level_full,
2095: x_return_status OUT NOCOPY VARCHAR2,
2096: x_msg_count OUT NOCOPY NUMBER,
2097: x_msg_data OUT NOCOPY VARCHAR2,
2098: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
2099: p_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,
2100: p_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,
2101: x_credit_acct_id OUT NOCOPY NUMBER,
2102: x_debit_acct_id OUT NOCOPY NUMBER,

Line 2788: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

2784: := fnd_api.g_valid_level_full,
2785: x_return_status OUT NOCOPY VARCHAR2,
2786: x_msg_count OUT NOCOPY NUMBER,
2787: x_msg_data OUT NOCOPY VARCHAR2,
2788: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
2789: x_ussgl_tc OUT NOCOPY VARCHAR2
2790: )
2791: IS
2792: l_api_name CONSTANT VARCHAR2 (30) := 'Get_UssglTC';

Line 3156: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

3152: := fnd_api.g_valid_level_full,
3153: x_return_status OUT NOCOPY VARCHAR2,
3154: x_msg_count OUT NOCOPY NUMBER,
3155: x_msg_data OUT NOCOPY VARCHAR2,
3156: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
3157: p_txn_type_id IN NUMBER,
3158: p_intercompany_price IN NUMBER,
3159: p_intercompany_curr_code IN VARCHAR2,
3160: p_acct_id IN NUMBER,

Line 3588: p_rcv_accttxn_tbl IN gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type

3584: := fnd_api.g_valid_level_full,
3585: x_return_status OUT NOCOPY VARCHAR2,
3586: x_msg_count OUT NOCOPY NUMBER,
3587: x_msg_data OUT NOCOPY VARCHAR2,
3588: p_rcv_accttxn_tbl IN gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type
3589: )
3590: IS
3591: l_api_name CONSTANT VARCHAR2 (30) := 'Insert_MMT';
3592: l_api_version CONSTANT NUMBER := 1.0;

Line 3610: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

3606: l_intercompany_price NUMBER;
3607: -- may include nr tax depending on the pricing option
3608: l_intercompany_curr_code gmf_rcv_accounting_txns.currency_code%TYPE;
3609: l_transfer_organization_id NUMBER := NULL;
3610: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
3611: invalid_event EXCEPTION;
3612: BEGIN
3613: -- Standard start of API savepoint
3614: SAVEPOINT insert_mmt_pvt;

Line 4230: x_rcv_accttxn OUT NOCOPY gmf_rcv_accounting_pkg.rcv_accttxn_rec_type

4226: p_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,
4227: p_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,
4228: p_unit_price IN NUMBER,
4229: p_prior_unit_price IN NUMBER,
4230: x_rcv_accttxn OUT NOCOPY gmf_rcv_accounting_pkg.rcv_accttxn_rec_type
4231: )
4232: IS
4233: c_log_module CONSTANT VARCHAR2 (30) := 'Insert_Txn';
4234: l_api_version CONSTANT NUMBER := 1.0;

Line 4241: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

4237: l_msg_data VARCHAR2 (8000) := '';
4238: l_stmt_num NUMBER := 0;
4239: l_api_message VARCHAR2 (1000);
4240: l_api_name CONSTANT VARCHAR2 (30) := 'Insert_Txn';
4241: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
4242: l_transaction_amount NUMBER := 0;
4243: l_source_doc_quantity NUMBER := 0;
4244: l_transaction_quantity NUMBER := 0;
4245: l_ic_pricing_option NUMBER := 1;

Line 5062: p_rcv_accttxn_tbl IN gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type

5058: := fnd_api.g_valid_level_full,
5059: x_return_status OUT NOCOPY VARCHAR2,
5060: x_msg_count OUT NOCOPY NUMBER,
5061: x_msg_data OUT NOCOPY VARCHAR2,
5062: p_rcv_accttxn_tbl IN gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type
5063: )
5064: IS
5065: l_api_name CONSTANT VARCHAR2 (30) := 'Insert_Txn2';
5066: l_api_version CONSTANT NUMBER := 1.0;

Line 5419: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

5415: l_msg_count NUMBER := 0;
5416: l_msg_data VARCHAR2 (8000) := '';
5417: l_stmt_num NUMBER := 0;
5418: l_api_message VARCHAR2 (1000);
5419: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
5420: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
5421: l_event_type_id NUMBER;
5422: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
5423: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

Line 5420: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

5416: l_msg_data VARCHAR2 (8000) := '';
5417: l_stmt_num NUMBER := 0;
5418: l_api_message VARCHAR2 (1000);
5419: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
5420: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
5421: l_event_type_id NUMBER;
5422: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
5423: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;
5424: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

Line 6250: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

6246: l_msg_data VARCHAR2 (8000) := '';
6247: l_stmt_num NUMBER := 0;
6248: l_api_message VARCHAR2 (1000);
6249: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Deliver_Txns';
6250: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
6251: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
6252: l_event_type_id NUMBER;
6253: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
6254: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type

Line 6251: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

6247: l_stmt_num NUMBER := 0;
6248: l_api_message VARCHAR2 (1000);
6249: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Deliver_Txns';
6250: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
6251: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
6252: l_event_type_id NUMBER;
6253: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
6254: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type
6255: := NULL;

Line 6804: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

6800: l_msg_count NUMBER := 0;
6801: l_msg_data VARCHAR2 (8000) := '';
6802: l_stmt_num NUMBER := 0;
6803: l_api_message VARCHAR2 (1000);
6804: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
6805: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
6806: l_event_type_id NUMBER;
6807: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
6808: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type

Line 6805: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

6801: l_msg_data VARCHAR2 (8000) := '';
6802: l_stmt_num NUMBER := 0;
6803: l_api_message VARCHAR2 (1000);
6804: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
6805: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
6806: l_event_type_id NUMBER;
6807: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
6808: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type
6809: := NULL;

Line 7420: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

7416: l_msg_count NUMBER := 0;
7417: l_msg_data VARCHAR2 (8000) := '';
7418: l_stmt_num NUMBER := 0;
7419: l_api_message VARCHAR2 (1000);
7420: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
7421: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
7422: l_event_type_id NUMBER;
7423: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
7424: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

Line 7421: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

7417: l_msg_data VARCHAR2 (8000) := '';
7418: l_stmt_num NUMBER := 0;
7419: l_api_message VARCHAR2 (1000);
7420: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
7421: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
7422: l_event_type_id NUMBER;
7423: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
7424: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;
7425: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

Line 8165: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

8161: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8162: l_po_header_id po_headers_all.po_header_id%TYPE;
8163: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8164: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8165: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8166: l_api_version NUMBER := 1.0;
8167: l_return_status VARCHAR2 (100);
8168: l_msg_count NUMBER (38);
8169: l_msg_data VARCHAR2 (4000);

Line 8521: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

8517: l_msg_count NUMBER := 0;
8518: l_msg_data VARCHAR2 (8000) := '';
8519: l_stmt_num NUMBER := 0;
8520: l_api_message VARCHAR2 (1000);
8521: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
8522: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8523: l_rae_count NUMBER;
8524: -- 12i Complex Work Procurement------------------------------------
8525: l_matching_basis po_line_locations.matching_basis%TYPE;

Line 8522: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

8518: l_msg_data VARCHAR2 (8000) := '';
8519: l_stmt_num NUMBER := 0;
8520: l_api_message VARCHAR2 (1000);
8521: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
8522: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8523: l_rae_count NUMBER;
8524: -- 12i Complex Work Procurement------------------------------------
8525: l_matching_basis po_line_locations.matching_basis%TYPE;
8526: l_shipment_type po_line_locations.shipment_type%TYPE;

Line 9041: END gmf_rcv_accounting_pkg;

9037: fnd_msg_pub.count_and_get (p_count => x_msg_count,
9038: p_data => x_msg_data
9039: );
9040: END create_adjust_txns;
9041: END gmf_rcv_accounting_pkg;