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.3 2006/09/20 12:32:05 anthiyag noship $ */
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 47: p_rcv_accttxn IN GMF_RCV_ACCOUNTING_PKG.rcv_accttxn_rec_type,

43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_rcv_accttxn IN GMF_RCV_ACCOUNTING_PKG.rcv_accttxn_rec_type,
48: x_transaction_amount OUT NOCOPY NUMBER
49: )
50: IS
51: l_api_name CONSTANT VARCHAR2(30) := 'Get_TransactionAmount';

Line 440: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

436: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
440: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
441: x_source_doc_quantity OUT NOCOPY NUMBER
442: )
443: IS
444: l_api_name CONSTANT VARCHAR2 (30) := 'Get_Quantity';

Line 779: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

775: := fnd_api.g_valid_level_full,
776: x_return_status OUT NOCOPY VARCHAR2,
777: x_msg_count OUT NOCOPY NUMBER,
778: x_msg_data OUT NOCOPY VARCHAR2,
779: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
780: p_asset_item_pricing_option IN NUMBER,
781: p_expense_item_pricing_option IN NUMBER,
782: x_intercompany_pricing_option OUT NOCOPY NUMBER,
783: x_unit_price OUT NOCOPY NUMBER,

Line 1210: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

1206: := fnd_api.g_valid_level_full,
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,
1209: x_msg_data OUT NOCOPY VARCHAR2,
1210: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
1211: x_unit_nr_tax OUT NOCOPY NUMBER,
1212: x_unit_rec_tax OUT NOCOPY NUMBER,
1213: x_prior_nr_tax OUT NOCOPY NUMBER,
1214: x_prior_rec_tax OUT NOCOPY NUMBER

Line 1502: p_event_rec IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

1498: := fnd_api.g_valid_level_full,
1499: x_return_status OUT NOCOPY VARCHAR2,
1500: x_msg_count OUT NOCOPY NUMBER,
1501: x_msg_data OUT NOCOPY VARCHAR2,
1502: p_event_rec IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
1503: x_transaction_qty OUT NOCOPY NUMBER,
1504: x_primary_uom OUT NOCOPY mtl_units_of_measure.unit_of_measure%TYPE,
1505: x_primary_qty OUT NOCOPY NUMBER,
1506: x_trx_uom_code OUT NOCOPY VARCHAR2

Line 1816: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

1812: := fnd_api.g_valid_level_full,
1813: x_return_status OUT NOCOPY VARCHAR2,
1814: x_msg_count OUT NOCOPY NUMBER,
1815: x_msg_data OUT NOCOPY VARCHAR2,
1816: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
1817: x_currency_code OUT NOCOPY VARCHAR2,
1818: x_currency_conversion_rate OUT NOCOPY NUMBER,
1819: x_currency_conversion_date OUT NOCOPY DATE,
1820: x_currency_conversion_type OUT NOCOPY VARCHAR2

Line 2092: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

2088: := fnd_api.g_valid_level_full,
2089: x_return_status OUT NOCOPY VARCHAR2,
2090: x_msg_count OUT NOCOPY NUMBER,
2091: x_msg_data OUT NOCOPY VARCHAR2,
2092: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
2093: p_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,
2094: p_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,
2095: x_credit_acct_id OUT NOCOPY NUMBER,
2096: x_debit_acct_id OUT NOCOPY NUMBER,

Line 2782: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

2778: := fnd_api.g_valid_level_full,
2779: x_return_status OUT NOCOPY VARCHAR2,
2780: x_msg_count OUT NOCOPY NUMBER,
2781: x_msg_data OUT NOCOPY VARCHAR2,
2782: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
2783: x_ussgl_tc OUT NOCOPY VARCHAR2
2784: )
2785: IS
2786: l_api_name CONSTANT VARCHAR2 (30) := 'Get_UssglTC';

Line 3150: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,

3146: := fnd_api.g_valid_level_full,
3147: x_return_status OUT NOCOPY VARCHAR2,
3148: x_msg_count OUT NOCOPY NUMBER,
3149: x_msg_data OUT NOCOPY VARCHAR2,
3150: p_rcv_accttxn IN gmf_rcv_accounting_pkg.rcv_accttxn_rec_type,
3151: p_txn_type_id IN NUMBER,
3152: p_intercompany_price IN NUMBER,
3153: p_intercompany_curr_code IN VARCHAR2,
3154: p_acct_id IN NUMBER,

Line 3582: p_rcv_accttxn_tbl IN gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type

3578: := fnd_api.g_valid_level_full,
3579: x_return_status OUT NOCOPY VARCHAR2,
3580: x_msg_count OUT NOCOPY NUMBER,
3581: x_msg_data OUT NOCOPY VARCHAR2,
3582: p_rcv_accttxn_tbl IN gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type
3583: )
3584: IS
3585: l_api_name CONSTANT VARCHAR2 (30) := 'Insert_MMT';
3586: l_api_version CONSTANT NUMBER := 1.0;

Line 3604: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

3600: l_intercompany_price NUMBER;
3601: -- may include nr tax depending on the pricing option
3602: l_intercompany_curr_code gmf_rcv_accounting_txns.currency_code%TYPE;
3603: l_transfer_organization_id NUMBER := NULL;
3604: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
3605: invalid_event EXCEPTION;
3606: BEGIN
3607: -- Standard start of API savepoint
3608: SAVEPOINT insert_mmt_pvt;

Line 4224: x_rcv_accttxn OUT NOCOPY gmf_rcv_accounting_pkg.rcv_accttxn_rec_type

4220: p_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,
4221: p_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,
4222: p_unit_price IN NUMBER,
4223: p_prior_unit_price IN NUMBER,
4224: x_rcv_accttxn OUT NOCOPY gmf_rcv_accounting_pkg.rcv_accttxn_rec_type
4225: )
4226: IS
4227: c_log_module CONSTANT VARCHAR2 (30) := 'Insert_Txn';
4228: l_api_version CONSTANT NUMBER := 1.0;

Line 4235: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

4231: l_msg_data VARCHAR2 (8000) := '';
4232: l_stmt_num NUMBER := 0;
4233: l_api_message VARCHAR2 (1000);
4234: l_api_name CONSTANT VARCHAR2 (30) := 'Insert_Txn';
4235: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
4236: l_transaction_amount NUMBER := 0;
4237: l_source_doc_quantity NUMBER := 0;
4238: l_transaction_quantity NUMBER := 0;
4239: l_ic_pricing_option NUMBER := 1;

Line 5050: p_rcv_accttxn_tbl IN gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type

5046: := fnd_api.g_valid_level_full,
5047: x_return_status OUT NOCOPY VARCHAR2,
5048: x_msg_count OUT NOCOPY NUMBER,
5049: x_msg_data OUT NOCOPY VARCHAR2,
5050: p_rcv_accttxn_tbl IN gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type
5051: )
5052: IS
5053: l_api_name CONSTANT VARCHAR2 (30) := 'Insert_Txn2';
5054: l_api_version CONSTANT NUMBER := 1.0;

Line 5401: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

5397: l_msg_count NUMBER := 0;
5398: l_msg_data VARCHAR2 (8000) := '';
5399: l_stmt_num NUMBER := 0;
5400: l_api_message VARCHAR2 (1000);
5401: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
5402: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
5403: l_event_type_id NUMBER;
5404: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
5405: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

Line 5402: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

5398: l_msg_data VARCHAR2 (8000) := '';
5399: l_stmt_num NUMBER := 0;
5400: l_api_message VARCHAR2 (1000);
5401: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
5402: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
5403: l_event_type_id NUMBER;
5404: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
5405: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;
5406: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

Line 6232: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

6228: l_msg_data VARCHAR2 (8000) := '';
6229: l_stmt_num NUMBER := 0;
6230: l_api_message VARCHAR2 (1000);
6231: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Deliver_Txns';
6232: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
6233: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
6234: l_event_type_id NUMBER;
6235: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
6236: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type

Line 6233: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

6229: l_stmt_num NUMBER := 0;
6230: l_api_message VARCHAR2 (1000);
6231: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Deliver_Txns';
6232: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
6233: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
6234: l_event_type_id NUMBER;
6235: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
6236: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type
6237: := NULL;

Line 6749: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

6745: l_msg_count NUMBER := 0;
6746: l_msg_data VARCHAR2 (8000) := '';
6747: l_stmt_num NUMBER := 0;
6748: l_api_message VARCHAR2 (1000);
6749: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
6750: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
6751: l_event_type_id NUMBER;
6752: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
6753: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type

Line 6750: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

6746: l_msg_data VARCHAR2 (8000) := '';
6747: l_stmt_num NUMBER := 0;
6748: l_api_message VARCHAR2 (1000);
6749: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
6750: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
6751: l_event_type_id NUMBER;
6752: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
6753: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type
6754: := NULL;

Line 7365: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

7361: l_msg_count NUMBER := 0;
7362: l_msg_data VARCHAR2 (8000) := '';
7363: l_stmt_num NUMBER := 0;
7364: l_api_message VARCHAR2 (1000);
7365: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
7366: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
7367: l_event_type_id NUMBER;
7368: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
7369: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

Line 7366: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

7362: l_msg_data VARCHAR2 (8000) := '';
7363: l_stmt_num NUMBER := 0;
7364: l_api_message VARCHAR2 (1000);
7365: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
7366: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
7367: l_event_type_id NUMBER;
7368: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;
7369: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;
7370: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

Line 8110: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

8106: l_grparent_trx_type rcv_transactions.transaction_type%TYPE;
8107: l_po_header_id po_headers_all.po_header_id%TYPE;
8108: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8109: l_shipment_type po_line_locations_all.shipment_type%TYPE;
8110: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8111: l_api_version NUMBER := 1.0;
8112: l_return_status VARCHAR2 (100);
8113: l_msg_count NUMBER (38);
8114: l_msg_data VARCHAR2 (4000);

Line 8463: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;

8459: l_msg_count NUMBER := 0;
8460: l_msg_data VARCHAR2 (8000) := '';
8461: l_stmt_num NUMBER := 0;
8462: l_api_message VARCHAR2 (1000);
8463: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
8464: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8465: l_rae_count NUMBER;
8466: -- 12i Complex Work Procurement------------------------------------
8467: l_matching_basis po_line_locations.matching_basis%TYPE;

Line 8464: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;

8460: l_msg_data VARCHAR2 (8000) := '';
8461: l_stmt_num NUMBER := 0;
8462: l_api_message VARCHAR2 (1000);
8463: l_rcv_accttxn gmf_rcv_accounting_pkg.rcv_accttxn_rec_type;
8464: l_rcv_accttxn_tbl gmf_rcv_accounting_pkg.rcv_accttxn_tbl_type;
8465: l_rae_count NUMBER;
8466: -- 12i Complex Work Procurement------------------------------------
8467: l_matching_basis po_line_locations.matching_basis%TYPE;
8468: l_shipment_type po_line_locations.shipment_type%TYPE;

Line 8983: END gmf_rcv_accounting_pkg;

8979: fnd_msg_pub.count_and_get (p_count => x_msg_count,
8980: p_data => x_msg_data
8981: );
8982: END create_adjust_txns;
8983: END gmf_rcv_accounting_pkg;