DBA Data[Home] [Help]

APPS.GMF_RCV_ACCOUNTING_PKG dependencies on INV_TRANSACTION_FLOW_PUB

Line 1000: inv_transaction_flow_pub.get_transfer_price

996: l_api_message
997: );
998: END IF;
999:
1000: inv_transaction_flow_pub.get_transfer_price
1001: (p_api_version => 1.0,
1002: x_return_status => l_return_status,
1003: x_msg_data => l_msg_data,
1004: x_msg_count => l_msg_count,

Line 2093: p_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,

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,
2097: x_ic_cogs_acct_id OUT NOCOPY NUMBER

Line 2094: p_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,

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,
2097: x_ic_cogs_acct_id OUT NOCOPY NUMBER
2098: )

Line 4220: p_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,

4216: p_organization_id IN NUMBER,
4217: p_transfer_org_id IN NUMBER,
4218: p_transfer_organization_id IN NUMBER,
4219: p_trx_flow_header_id IN NUMBER,
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

Line 4221: p_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,

4217: p_transfer_org_id IN NUMBER,
4218: p_transfer_organization_id IN NUMBER,
4219: p_trx_flow_header_id IN NUMBER,
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: )

Line 5404: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;

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;
5407: l_trx_flow_exists_flag NUMBER := 0;
5408: l_trx_flow_ctr NUMBER := 0;

Line 5405: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

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;
5407: l_trx_flow_exists_flag NUMBER := 0;
5408: l_trx_flow_ctr NUMBER := 0;
5409: l_po_header_id NUMBER;

Line 5406: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_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;
5407: l_trx_flow_exists_flag NUMBER := 0;
5408: l_trx_flow_ctr NUMBER := 0;
5409: l_po_header_id NUMBER;
5410: l_po_line_id NUMBER;

Line 5432: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;

5428: l_accrual_flag VARCHAR2 (1);
5429: l_counter NUMBER;
5430: l_procurement_org_flag VARCHAR2 (1);
5431: l_trx_flow_header_id NUMBER;
5432: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
5433: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
5434:
5435: CURSOR c_po_distributions_csr (
5436: p_po_distribution_id NUMBER,

Line 5433: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;

5429: l_counter NUMBER;
5430: l_procurement_org_flag VARCHAR2 (1);
5431: l_trx_flow_header_id NUMBER;
5432: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
5433: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
5434:
5435: CURSOR c_po_distributions_csr (
5436: p_po_distribution_id NUMBER,
5437: p_po_line_location_id NUMBER

Line 5560: inv_transaction_flow_pub.g_qualifier_code;

5556: ELSE
5557: l_cross_ou_flag := 'Y';
5558: /* For 11i10, the only supported qualifier is category id. */
5559: l_qualifier_code_tbl (l_qualifier_code_tbl.COUNT + 1) :=
5560: inv_transaction_flow_pub.g_qualifier_code;
5561: l_qualifier_value_tbl (l_qualifier_value_tbl.COUNT + 1) :=
5562: l_category_id;
5563: l_stmt_num := 50;
5564:

Line 5583: inv_transaction_flow_pub.get_transaction_flow

5579: l_api_message
5580: );
5581: END IF;
5582:
5583: inv_transaction_flow_pub.get_transaction_flow
5584: (x_return_status => l_return_status,
5585: x_msg_data => l_msg_data,
5586: x_msg_count => l_msg_count,
5587: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 5591: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,

5587: x_transaction_flows_tbl => l_transaction_flows_tbl,
5588: p_api_version => 1.0,
5589: p_start_operating_unit => l_po_org_id,
5590: p_end_operating_unit => l_rcv_org_id,
5591: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,
5592: p_organization_id => l_rcv_organization_id,
5593: p_qualifier_code_tbl => l_qualifier_code_tbl,
5594: p_qualifier_value_tbl => l_qualifier_value_tbl,
5595: p_transaction_date => l_rcv_trx_date,

Line 6235: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;

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;
6238: l_trx_flow_exists_flag NUMBER := 0;
6239: l_trx_flow_ctr NUMBER := 0;

Line 6236: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type

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;
6238: l_trx_flow_exists_flag NUMBER := 0;
6239: l_trx_flow_ctr NUMBER := 0;
6240: l_po_header_id NUMBER;

Line 6258: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;

6254: l_cross_ou_flag VARCHAR2 (1) := 'N';
6255: l_accrual_flag VARCHAR2 (1) := 'N';
6256: l_procurement_org_flag VARCHAR2 (1) := 'Y';
6257: l_trx_flow_header_id NUMBER;
6258: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
6259: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
6260: l_encumbrance_flag VARCHAR2 (1);
6261: l_ussgl_option VARCHAR2 (1);
6262: BEGIN

Line 6259: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;

6255: l_accrual_flag VARCHAR2 (1) := 'N';
6256: l_procurement_org_flag VARCHAR2 (1) := 'Y';
6257: l_trx_flow_header_id NUMBER;
6258: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
6259: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
6260: l_encumbrance_flag VARCHAR2 (1);
6261: l_ussgl_option VARCHAR2 (1);
6262: BEGIN
6263: -- Standard start of API savepoint

Line 6368: inv_transaction_flow_pub.g_qualifier_code;

6364: IF (l_cross_ou_flag = 'Y' AND l_project_id IS NULL)
6365: THEN
6366: /* For 11i10, the only supported qualifier is category id. */
6367: l_qualifier_code_tbl (l_qualifier_code_tbl.COUNT + 1) :=
6368: inv_transaction_flow_pub.g_qualifier_code;
6369: l_qualifier_value_tbl (l_qualifier_value_tbl.COUNT + 1) :=
6370: l_category_id;
6371:
6372: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 6388: inv_transaction_flow_pub.get_transaction_flow

6384: l_api_message
6385: );
6386: END IF;
6387:
6388: inv_transaction_flow_pub.get_transaction_flow
6389: (x_return_status => l_return_status,
6390: x_msg_data => l_msg_data,
6391: x_msg_count => l_msg_count,
6392: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 6396: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,

6392: x_transaction_flows_tbl => l_transaction_flows_tbl,
6393: p_api_version => 1.0,
6394: p_start_operating_unit => l_po_org_id,
6395: p_end_operating_unit => l_rcv_org_id,
6396: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,
6397: p_organization_id => l_rcv_organization_id,
6398: p_qualifier_code_tbl => l_qualifier_code_tbl,
6399: p_qualifier_value_tbl => l_qualifier_value_tbl,
6400: p_transaction_date => l_rcv_trx_date,

Line 6752: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;

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;
6755: l_trx_flow_exists_flag NUMBER := 0;
6756: l_trx_flow_ctr NUMBER := 0;

Line 6753: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type

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;
6755: l_trx_flow_exists_flag NUMBER := 0;
6756: l_trx_flow_ctr NUMBER := 0;
6757: l_po_header_id NUMBER;

Line 6775: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;

6771: l_cross_ou_flag VARCHAR2 (1) := 'N';
6772: l_accrual_flag VARCHAR2 (1) := 'N';
6773: l_procurement_org_flag VARCHAR2 (1) := 'Y';
6774: l_trx_flow_header_id NUMBER;
6775: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
6776: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
6777: l_encumbrance_flag VARCHAR2 (1);
6778: l_ussgl_option VARCHAR2 (1);
6779: BEGIN

Line 6776: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;

6772: l_accrual_flag VARCHAR2 (1) := 'N';
6773: l_procurement_org_flag VARCHAR2 (1) := 'Y';
6774: l_trx_flow_header_id NUMBER;
6775: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
6776: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
6777: l_encumbrance_flag VARCHAR2 (1);
6778: l_ussgl_option VARCHAR2 (1);
6779: BEGIN
6780: -- Standard start of API savepoint

Line 6910: inv_transaction_flow_pub.g_qualifier_code;

6906: IF (l_cross_ou_flag = 'Y' AND l_project_id IS NULL)
6907: THEN
6908: /* For 11i10, the only supported qualifier is category id. */
6909: l_qualifier_code_tbl (l_qualifier_code_tbl.COUNT + 1) :=
6910: inv_transaction_flow_pub.g_qualifier_code;
6911: l_qualifier_value_tbl (l_qualifier_value_tbl.COUNT + 1) :=
6912: l_category_id;
6913: l_stmt_num := 40;
6914:

Line 6933: inv_transaction_flow_pub.get_transaction_flow

6929: l_api_message
6930: );
6931: END IF;
6932:
6933: inv_transaction_flow_pub.get_transaction_flow
6934: (x_return_status => l_return_status,
6935: x_msg_data => l_msg_data,
6936: x_msg_count => l_msg_count,
6937: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 6941: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,

6937: x_transaction_flows_tbl => l_transaction_flows_tbl,
6938: p_api_version => 1.0,
6939: p_start_operating_unit => l_po_org_id,
6940: p_end_operating_unit => l_rcv_org_id,
6941: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,
6942: p_organization_id => l_rcv_organization_id,
6943: p_qualifier_code_tbl => l_qualifier_code_tbl,
6944: p_qualifier_value_tbl => l_qualifier_value_tbl,
6945: p_transaction_date => l_rcv_trx_date,

Line 7368: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;

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;
7371: l_trx_flow_exists_flag NUMBER := 0;
7372: l_trx_flow_ctr NUMBER := 0;

Line 7369: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

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;
7371: l_trx_flow_exists_flag NUMBER := 0;
7372: l_trx_flow_ctr NUMBER := 0;
7373: l_po_header_id NUMBER;

Line 7370: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_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;
7371: l_trx_flow_exists_flag NUMBER := 0;
7372: l_trx_flow_ctr NUMBER := 0;
7373: l_po_header_id NUMBER;
7374: l_po_line_id NUMBER;

Line 7396: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;

7392: l_accrual_flag VARCHAR2 (1);
7393: l_counter NUMBER;
7394: l_procurement_org_flag VARCHAR2 (1);
7395: l_trx_flow_header_id NUMBER;
7396: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
7397: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
7398:
7399: CURSOR c_po_distributions_csr (
7400: p_po_distribution_id NUMBER,

Line 7397: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;

7393: l_counter NUMBER;
7394: l_procurement_org_flag VARCHAR2 (1);
7395: l_trx_flow_header_id NUMBER;
7396: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
7397: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
7398:
7399: CURSOR c_po_distributions_csr (
7400: p_po_distribution_id NUMBER,
7401: p_po_line_location_id NUMBER

Line 7524: inv_transaction_flow_pub.g_qualifier_code;

7520: ELSE
7521: l_cross_ou_flag := 'Y';
7522: /* For 11i10, the only supported qualifier is category id. */
7523: l_qualifier_code_tbl (l_qualifier_code_tbl.COUNT + 1) :=
7524: inv_transaction_flow_pub.g_qualifier_code;
7525: l_qualifier_value_tbl (l_qualifier_value_tbl.COUNT + 1) :=
7526: l_category_id;
7527: l_stmt_num := 50;
7528:

Line 7547: inv_transaction_flow_pub.get_transaction_flow

7543: l_api_message
7544: );
7545: END IF;
7546:
7547: inv_transaction_flow_pub.get_transaction_flow
7548: (x_return_status => l_return_status,
7549: x_msg_data => l_msg_data,
7550: x_msg_count => l_msg_count,
7551: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 7555: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,

7551: x_transaction_flows_tbl => l_transaction_flows_tbl,
7552: p_api_version => 1.0,
7553: p_start_operating_unit => l_po_org_id,
7554: p_end_operating_unit => l_rcv_org_id,
7555: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,
7556: p_organization_id => l_rcv_organization_id,
7557: p_qualifier_code_tbl => l_qualifier_code_tbl,
7558: p_qualifier_value_tbl => l_qualifier_value_tbl,
7559: p_transaction_date => l_rcv_trx_date,