DBA Data[Home] [Help]

APPS.GMF_RCV_ACCOUNTING_PKG dependencies on INV_TRANSACTION_FLOW_PUB

Line 1006: inv_transaction_flow_pub.get_transfer_price

1002: l_api_message
1003: );
1004: END IF;
1005:
1006: inv_transaction_flow_pub.get_transfer_price
1007: (p_api_version => 1.0,
1008: x_return_status => l_return_status,
1009: x_msg_data => l_msg_data,
1010: x_msg_count => l_msg_count,

Line 2099: p_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,

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

Line 2100: p_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,

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,
2103: x_ic_cogs_acct_id OUT NOCOPY NUMBER
2104: )

Line 4226: p_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,

4222: p_organization_id IN NUMBER,
4223: p_transfer_org_id IN NUMBER,
4224: p_transfer_organization_id IN NUMBER,
4225: p_trx_flow_header_id IN NUMBER,
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

Line 4227: p_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type,

4223: p_transfer_org_id IN NUMBER,
4224: p_transfer_organization_id IN NUMBER,
4225: p_trx_flow_header_id IN NUMBER,
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: )

Line 5422: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;

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;
5425: l_trx_flow_exists_flag NUMBER := 0;
5426: l_trx_flow_ctr NUMBER := 0;

Line 5423: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

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;
5425: l_trx_flow_exists_flag NUMBER := 0;
5426: l_trx_flow_ctr NUMBER := 0;
5427: l_po_header_id NUMBER;

Line 5424: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_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;
5425: l_trx_flow_exists_flag NUMBER := 0;
5426: l_trx_flow_ctr NUMBER := 0;
5427: l_po_header_id NUMBER;
5428: l_po_line_id NUMBER;

Line 5450: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;

5446: l_accrual_flag VARCHAR2 (1);
5447: l_counter NUMBER;
5448: l_procurement_org_flag VARCHAR2 (1);
5449: l_trx_flow_header_id NUMBER;
5450: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
5451: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
5452:
5453: CURSOR c_po_distributions_csr (
5454: p_po_distribution_id NUMBER,

Line 5451: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;

5447: l_counter NUMBER;
5448: l_procurement_org_flag VARCHAR2 (1);
5449: l_trx_flow_header_id NUMBER;
5450: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
5451: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
5452:
5453: CURSOR c_po_distributions_csr (
5454: p_po_distribution_id NUMBER,
5455: p_po_line_location_id NUMBER

Line 5578: inv_transaction_flow_pub.g_qualifier_code;

5574: ELSE
5575: l_cross_ou_flag := 'Y';
5576: /* For 11i10, the only supported qualifier is category id. */
5577: l_qualifier_code_tbl (l_qualifier_code_tbl.COUNT + 1) :=
5578: inv_transaction_flow_pub.g_qualifier_code;
5579: l_qualifier_value_tbl (l_qualifier_value_tbl.COUNT + 1) :=
5580: l_category_id;
5581: l_stmt_num := 50;
5582:

Line 5601: inv_transaction_flow_pub.get_transaction_flow

5597: l_api_message
5598: );
5599: END IF;
5600:
5601: inv_transaction_flow_pub.get_transaction_flow
5602: (x_return_status => l_return_status,
5603: x_msg_data => l_msg_data,
5604: x_msg_count => l_msg_count,
5605: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 5609: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,

5605: x_transaction_flows_tbl => l_transaction_flows_tbl,
5606: p_api_version => 1.0,
5607: p_start_operating_unit => l_po_org_id,
5608: p_end_operating_unit => l_rcv_org_id,
5609: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,
5610: p_organization_id => l_rcv_organization_id,
5611: p_qualifier_code_tbl => l_qualifier_code_tbl,
5612: p_qualifier_value_tbl => l_qualifier_value_tbl,
5613: p_transaction_date => l_rcv_trx_date,

Line 6253: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;

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;
6256: l_trx_flow_exists_flag NUMBER := 0;
6257: l_trx_flow_ctr NUMBER := 0;

Line 6254: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type

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;
6256: l_trx_flow_exists_flag NUMBER := 0;
6257: l_trx_flow_ctr NUMBER := 0;
6258: l_po_header_id NUMBER;

Line 6276: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;

6272: l_cross_ou_flag VARCHAR2 (1) := 'N';
6273: l_accrual_flag VARCHAR2 (1) := 'N';
6274: l_procurement_org_flag VARCHAR2 (1) := 'Y';
6275: l_trx_flow_header_id NUMBER;
6276: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
6277: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
6278: l_encumbrance_flag VARCHAR2 (1);
6279: l_ussgl_option VARCHAR2 (1);
6280: l_rcv_quantity NUMBER := 0; /* Bug 8517463 */

Line 6277: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;

6273: l_accrual_flag VARCHAR2 (1) := 'N';
6274: l_procurement_org_flag VARCHAR2 (1) := 'Y';
6275: l_trx_flow_header_id NUMBER;
6276: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
6277: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
6278: l_encumbrance_flag VARCHAR2 (1);
6279: l_ussgl_option VARCHAR2 (1);
6280: l_rcv_quantity NUMBER := 0; /* Bug 8517463 */
6281: l_rcv_transaction_type VARCHAR2(25); /* Bug 8517463 */

Line 6389: inv_transaction_flow_pub.g_qualifier_code;

6385: IF (l_cross_ou_flag = 'Y' AND l_project_id IS NULL)
6386: THEN
6387: /* For 11i10, the only supported qualifier is category id. */
6388: l_qualifier_code_tbl (l_qualifier_code_tbl.COUNT + 1) :=
6389: inv_transaction_flow_pub.g_qualifier_code;
6390: l_qualifier_value_tbl (l_qualifier_value_tbl.COUNT + 1) :=
6391: l_category_id;
6392:
6393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 6409: inv_transaction_flow_pub.get_transaction_flow

6405: l_api_message
6406: );
6407: END IF;
6408:
6409: inv_transaction_flow_pub.get_transaction_flow
6410: (x_return_status => l_return_status,
6411: x_msg_data => l_msg_data,
6412: x_msg_count => l_msg_count,
6413: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 6417: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,

6413: x_transaction_flows_tbl => l_transaction_flows_tbl,
6414: p_api_version => 1.0,
6415: p_start_operating_unit => l_po_org_id,
6416: p_end_operating_unit => l_rcv_org_id,
6417: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,
6418: p_organization_id => l_rcv_organization_id,
6419: p_qualifier_code_tbl => l_qualifier_code_tbl,
6420: p_qualifier_value_tbl => l_qualifier_value_tbl,
6421: p_transaction_date => l_rcv_trx_date,

Line 6807: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;

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;
6810: l_trx_flow_exists_flag NUMBER := 0;
6811: l_trx_flow_ctr NUMBER := 0;

Line 6808: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type

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;
6810: l_trx_flow_exists_flag NUMBER := 0;
6811: l_trx_flow_ctr NUMBER := 0;
6812: l_po_header_id NUMBER;

Line 6830: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;

6826: l_cross_ou_flag VARCHAR2 (1) := 'N';
6827: l_accrual_flag VARCHAR2 (1) := 'N';
6828: l_procurement_org_flag VARCHAR2 (1) := 'Y';
6829: l_trx_flow_header_id NUMBER;
6830: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
6831: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
6832: l_encumbrance_flag VARCHAR2 (1);
6833: l_ussgl_option VARCHAR2 (1);
6834: BEGIN

Line 6831: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;

6827: l_accrual_flag VARCHAR2 (1) := 'N';
6828: l_procurement_org_flag VARCHAR2 (1) := 'Y';
6829: l_trx_flow_header_id NUMBER;
6830: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
6831: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
6832: l_encumbrance_flag VARCHAR2 (1);
6833: l_ussgl_option VARCHAR2 (1);
6834: BEGIN
6835: -- Standard start of API savepoint

Line 6965: inv_transaction_flow_pub.g_qualifier_code;

6961: IF (l_cross_ou_flag = 'Y' AND l_project_id IS NULL)
6962: THEN
6963: /* For 11i10, the only supported qualifier is category id. */
6964: l_qualifier_code_tbl (l_qualifier_code_tbl.COUNT + 1) :=
6965: inv_transaction_flow_pub.g_qualifier_code;
6966: l_qualifier_value_tbl (l_qualifier_value_tbl.COUNT + 1) :=
6967: l_category_id;
6968: l_stmt_num := 40;
6969:

Line 6988: inv_transaction_flow_pub.get_transaction_flow

6984: l_api_message
6985: );
6986: END IF;
6987:
6988: inv_transaction_flow_pub.get_transaction_flow
6989: (x_return_status => l_return_status,
6990: x_msg_data => l_msg_data,
6991: x_msg_count => l_msg_count,
6992: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 6996: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,

6992: x_transaction_flows_tbl => l_transaction_flows_tbl,
6993: p_api_version => 1.0,
6994: p_start_operating_unit => l_po_org_id,
6995: p_end_operating_unit => l_rcv_org_id,
6996: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,
6997: p_organization_id => l_rcv_organization_id,
6998: p_qualifier_code_tbl => l_qualifier_code_tbl,
6999: p_qualifier_value_tbl => l_qualifier_value_tbl,
7000: p_transaction_date => l_rcv_trx_date,

Line 7423: l_transaction_flows_tbl inv_transaction_flow_pub.g_transaction_flow_tbl_type;

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;
7426: l_trx_flow_exists_flag NUMBER := 0;
7427: l_trx_flow_ctr NUMBER := 0;

Line 7424: l_transaction_forward_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_rec_type;

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;
7426: l_trx_flow_exists_flag NUMBER := 0;
7427: l_trx_flow_ctr NUMBER := 0;
7428: l_po_header_id NUMBER;

Line 7425: l_transaction_reverse_flow_rec inv_transaction_flow_pub.mtl_transaction_flow_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;
7426: l_trx_flow_exists_flag NUMBER := 0;
7427: l_trx_flow_ctr NUMBER := 0;
7428: l_po_header_id NUMBER;
7429: l_po_line_id NUMBER;

Line 7451: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;

7447: l_accrual_flag VARCHAR2 (1);
7448: l_counter NUMBER;
7449: l_procurement_org_flag VARCHAR2 (1);
7450: l_trx_flow_header_id NUMBER;
7451: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
7452: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
7453:
7454: CURSOR c_po_distributions_csr (
7455: p_po_distribution_id NUMBER,

Line 7452: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;

7448: l_counter NUMBER;
7449: l_procurement_org_flag VARCHAR2 (1);
7450: l_trx_flow_header_id NUMBER;
7451: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
7452: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
7453:
7454: CURSOR c_po_distributions_csr (
7455: p_po_distribution_id NUMBER,
7456: p_po_line_location_id NUMBER

Line 7579: inv_transaction_flow_pub.g_qualifier_code;

7575: ELSE
7576: l_cross_ou_flag := 'Y';
7577: /* For 11i10, the only supported qualifier is category id. */
7578: l_qualifier_code_tbl (l_qualifier_code_tbl.COUNT + 1) :=
7579: inv_transaction_flow_pub.g_qualifier_code;
7580: l_qualifier_value_tbl (l_qualifier_value_tbl.COUNT + 1) :=
7581: l_category_id;
7582: l_stmt_num := 50;
7583:

Line 7602: inv_transaction_flow_pub.get_transaction_flow

7598: l_api_message
7599: );
7600: END IF;
7601:
7602: inv_transaction_flow_pub.get_transaction_flow
7603: (x_return_status => l_return_status,
7604: x_msg_data => l_msg_data,
7605: x_msg_count => l_msg_count,
7606: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 7610: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,

7606: x_transaction_flows_tbl => l_transaction_flows_tbl,
7607: p_api_version => 1.0,
7608: p_start_operating_unit => l_po_org_id,
7609: p_end_operating_unit => l_rcv_org_id,
7610: p_flow_type => inv_transaction_flow_pub.g_procuring_flow_type,
7611: p_organization_id => l_rcv_organization_id,
7612: p_qualifier_code_tbl => l_qualifier_code_tbl,
7613: p_qualifier_value_tbl => l_qualifier_value_tbl,
7614: p_transaction_date => l_rcv_trx_date,