DBA Data[Home] [Help]

APPS.RCV_ACCEVENTS_PVT dependencies on INV_TRANSACTION_FLOW_PUB

Line 876: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

872: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
873: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
874: l_event_type_id NUMBER;
875:
876: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
877: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
878: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
879: l_trx_flow_exists_flag NUMBER := 0;
880: l_trx_flow_ctr NUMBER := 0;

Line 877: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;

873: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
874: l_event_type_id NUMBER;
875:
876: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
877: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
878: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
879: l_trx_flow_exists_flag NUMBER := 0;
880: l_trx_flow_ctr NUMBER := 0;
881:

Line 878: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;

874: l_event_type_id NUMBER;
875:
876: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
877: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
878: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
879: l_trx_flow_exists_flag NUMBER := 0;
880: l_trx_flow_ctr NUMBER := 0;
881:
882: l_po_header_id NUMBER;

Line 903: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

899: l_order_type_lookup_code PO_LINES.ORDER_TYPE_LOOKUP_CODE%TYPE;
900: l_inv_amount NUMBER;
901: l_price_correction_flag VARCHAR2(1) := 'N';
902:
903: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
904: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
905:
906:
907: BEGIN

Line 904: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

900: l_inv_amount NUMBER;
901: l_price_correction_flag VARCHAR2(1) := 'N';
902:
903: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
904: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
905:
906:
907: BEGIN
908: -- Standard start of API savepoint

Line 1043: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

1039: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
1040: l_event_type_id NUMBER;
1041:
1042:
1043: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1044: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
1045: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
1046: l_trx_flow_exists_flag NUMBER := 0;
1047: l_trx_flow_ctr NUMBER := 0;

Line 1044: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;

1040: l_event_type_id NUMBER;
1041:
1042:
1043: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1044: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
1045: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
1046: l_trx_flow_exists_flag NUMBER := 0;
1047: l_trx_flow_ctr NUMBER := 0;
1048:

Line 1045: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;

1041:
1042:
1043: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1044: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
1045: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
1046: l_trx_flow_exists_flag NUMBER := 0;
1047: l_trx_flow_ctr NUMBER := 0;
1048:
1049:

Line 1078: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

1074: l_is_shared_proc VARCHAR2(1);
1075: /* Support for Landed Cost Management */
1076: l_lcm_flag VARCHAR2(1);
1077:
1078: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1079: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1080:
1081: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS
1082: SELECT po_distribution_id,destination_type_code, project_id

Line 1079: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

1075: /* Support for Landed Cost Management */
1076: l_lcm_flag VARCHAR2(1);
1077:
1078: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1079: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1080:
1081: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS
1082: SELECT po_distribution_id,destination_type_code, project_id
1083: FROM po_distributions POD

Line 1198: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;

1194: ELSE
1195: l_cross_ou_flag := 'Y';
1196:
1197: /* For 11i10, the only supported qualifier is category id. */
1198: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;
1199: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
1200:
1201: l_stmt_num := 50;
1202: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1212: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(

1208: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
1209: ,l_api_message);
1210: END IF;
1211:
1212: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(
1213: x_return_status => l_return_status,
1214: x_msg_data => l_msg_data,
1215: x_msg_count => l_msg_count,
1216: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 1220: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,

1216: x_transaction_flows_tbl => l_transaction_flows_tbl,
1217: p_api_version => 1.0,
1218: p_start_operating_unit => l_po_org_id,
1219: p_end_operating_unit => l_rcv_org_id,
1220: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,
1221: p_organization_id => l_rcv_organization_id,
1222: p_qualifier_code_tbl => l_qualifier_code_tbl,
1223: p_qualifier_value_tbl => l_qualifier_value_tbl,
1224: p_transaction_date => l_rcv_trx_date,

Line 1747: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

1743: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
1744: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
1745: l_event_type_id NUMBER;
1746:
1747: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1748: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type := NULL;
1749: l_trx_flow_exists_flag NUMBER := 0;
1750: l_trx_flow_ctr NUMBER := 0;
1751:

Line 1748: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type := NULL;

1744: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
1745: l_event_type_id NUMBER;
1746:
1747: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
1748: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type := NULL;
1749: l_trx_flow_exists_flag NUMBER := 0;
1750: l_trx_flow_ctr NUMBER := 0;
1751:
1752: l_po_header_id NUMBER;

Line 1770: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

1766: l_cross_ou_flag VARCHAR2(1) := 'N';
1767: l_accrual_flag VARCHAR2(1) := 'N';
1768: l_procurement_org_flag VARCHAR2(1) := 'Y';
1769: l_trx_flow_header_id NUMBER;
1770: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1771: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1772: l_encumbrance_flag VARCHAR2(1);
1773: l_ussgl_option VARCHAR2(1);
1774: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 1771: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

1767: l_accrual_flag VARCHAR2(1) := 'N';
1768: l_procurement_org_flag VARCHAR2(1) := 'Y';
1769: l_trx_flow_header_id NUMBER;
1770: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1771: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1772: l_encumbrance_flag VARCHAR2(1);
1773: l_ussgl_option VARCHAR2(1);
1774: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1775: l_is_shared_proc VARCHAR2(1);

Line 1898: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;

1894: -- procurement.
1895: IF(l_cross_ou_flag = 'Y' AND l_project_id is NULL) THEN
1896:
1897: /* For 11i10, the only supported qualifier is category id. */
1898: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;
1899: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
1900:
1901: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1902: l_api_message := 'Getting Procurement Transaction Flow :'||

Line 1912: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(

1908: ,l_api_message);
1909: END IF;
1910:
1911:
1912: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(
1913: x_return_status => l_return_status,
1914: x_msg_data => l_msg_data,
1915: x_msg_count => l_msg_count,
1916: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 1920: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,

1916: x_transaction_flows_tbl => l_transaction_flows_tbl,
1917: p_api_version => 1.0,
1918: p_start_operating_unit => l_po_org_id,
1919: p_end_operating_unit => l_rcv_org_id,
1920: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,
1921: p_organization_id => l_rcv_organization_id,
1922: p_qualifier_code_tbl => l_qualifier_code_tbl,
1923: p_qualifier_value_tbl => l_qualifier_value_tbl,
1924: p_transaction_date => l_rcv_trx_date,

Line 2294: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

2290: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
2291: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
2292: l_event_type_id NUMBER;
2293:
2294: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
2295: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type := NULL;
2296: l_trx_flow_exists_flag NUMBER := 0;
2297: l_trx_flow_ctr NUMBER := 0;
2298:

Line 2295: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type := NULL;

2291: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
2292: l_event_type_id NUMBER;
2293:
2294: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
2295: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type := NULL;
2296: l_trx_flow_exists_flag NUMBER := 0;
2297: l_trx_flow_ctr NUMBER := 0;
2298:
2299: l_po_header_id NUMBER;

Line 2317: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

2313: l_cross_ou_flag VARCHAR2(1) := 'N';
2314: l_accrual_flag VARCHAR2(1) := 'N';
2315: l_procurement_org_flag VARCHAR2(1) := 'Y';
2316: l_trx_flow_header_id NUMBER;
2317: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2318: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2319: l_encumbrance_flag VARCHAR2(1);
2320: l_ussgl_option VARCHAR2(1);
2321: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;

Line 2318: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

2314: l_accrual_flag VARCHAR2(1) := 'N';
2315: l_procurement_org_flag VARCHAR2(1) := 'Y';
2316: l_trx_flow_header_id NUMBER;
2317: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2318: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2319: l_encumbrance_flag VARCHAR2(1);
2320: l_ussgl_option VARCHAR2(1);
2321: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;
2322: l_is_shared_proc VARCHAR2(1);

Line 2447: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;

2443: -- procurement.
2444: IF(l_cross_ou_flag = 'Y' AND l_project_id is NULL) THEN
2445:
2446: /* For 11i10, the only supported qualifier is category id. */
2447: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;
2448: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
2449:
2450: l_stmt_num := 40;
2451: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2461: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(

2457: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2458: ,l_api_message);
2459: END IF;
2460:
2461: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(
2462: x_return_status => l_return_status,
2463: x_msg_data => l_msg_data,
2464: x_msg_count => l_msg_count,
2465: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 2469: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,

2465: x_transaction_flows_tbl => l_transaction_flows_tbl,
2466: p_api_version => 1.0,
2467: p_start_operating_unit => l_po_org_id,
2468: p_end_operating_unit => l_rcv_org_id,
2469: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,
2470: p_organization_id => l_rcv_organization_id,
2471: p_qualifier_code_tbl => l_qualifier_code_tbl,
2472: p_qualifier_value_tbl => l_qualifier_value_tbl,
2473: p_transaction_date => l_rcv_trx_date,

Line 2831: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

2827: l_rcv_events_tbl RCV_SeedEvents_PVT.rcv_event_tbl_type;
2828: l_event_type_id NUMBER;
2829:
2830:
2831: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
2832: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
2833: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
2834: l_trx_flow_exists_flag NUMBER := 0;
2835: l_trx_flow_ctr NUMBER := 0;

Line 2832: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;

2828: l_event_type_id NUMBER;
2829:
2830:
2831: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
2832: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
2833: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
2834: l_trx_flow_exists_flag NUMBER := 0;
2835: l_trx_flow_ctr NUMBER := 0;
2836:

Line 2833: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;

2829:
2830:
2831: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
2832: l_transaction_forward_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
2833: l_transaction_reverse_flow_rec INV_TRANSACTION_FLOW_PUB.mtl_transaction_flow_rec_type;
2834: l_trx_flow_exists_flag NUMBER := 0;
2835: l_trx_flow_ctr NUMBER := 0;
2836:
2837:

Line 2868: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

2864: l_is_shared_proc VARCHAR2(1);
2865: /* Support for Landed Cost Management */
2866: l_lcm_flag VARCHAR2(1);
2867:
2868: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2869: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2870:
2871: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS
2872: SELECT po_distribution_id,destination_type_code, project_id

Line 2869: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

2865: /* Support for Landed Cost Management */
2866: l_lcm_flag VARCHAR2(1);
2867:
2868: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2869: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2870:
2871: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS
2872: SELECT po_distribution_id,destination_type_code, project_id
2873: FROM po_distributions POD

Line 2987: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;

2983: ELSE
2984: l_cross_ou_flag := 'Y';
2985:
2986: /* For 11i10, the only supported qualifier is category id. */
2987: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;
2988: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
2989:
2990:
2991: l_stmt_num := 50;

Line 3002: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(

2998: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
2999: ,l_api_message);
3000: END IF;
3001:
3002: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(
3003: x_return_status => l_return_status,
3004: x_msg_data => l_msg_data,
3005: x_msg_count => l_msg_count,
3006: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 3010: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,

3006: x_transaction_flows_tbl => l_transaction_flows_tbl,
3007: p_api_version => 1.0,
3008: p_start_operating_unit => l_po_org_id,
3009: p_end_operating_unit => l_rcv_org_id,
3010: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,
3011: p_organization_id => l_rcv_organization_id,
3012: p_qualifier_code_tbl => l_qualifier_code_tbl,
3013: p_qualifier_value_tbl => l_qualifier_value_tbl,
3014: p_transaction_date => l_rcv_trx_date,

Line 3499: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;

3495: l_msg_data VARCHAR2(8000) := '';
3496: l_stmt_num NUMBER := 0;
3497: l_api_message VARCHAR2(1000);
3498:
3499: l_transaction_flows_tbl INV_TRANSACTION_FLOW_PUB.g_transaction_flow_tbl_type;
3500: l_consigned_flag RCV_TRANSACTIONS.consigned_flag%TYPE;
3501: l_source_doc_code RCV_TRANSACTIONS.source_document_code%TYPE;
3502: l_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
3503: l_parent_trx_id RCV_TRANSACTIONS.transaction_id%TYPE;

Line 3526: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

3522: l_accrual_flag VARCHAR2(1);
3523: l_counter NUMBER;
3524: l_procurement_org_flag VARCHAR2(1);
3525:
3526: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
3527: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
3528:
3529: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
3530: l_ic_pricing_option NUMBER := 1;

Line 3527: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;

3523: l_counter NUMBER;
3524: l_procurement_org_flag VARCHAR2(1);
3525:
3526: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
3527: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
3528:
3529: l_rcv_event RCV_SeedEvents_PVT.rcv_event_rec_type;
3530: l_ic_pricing_option NUMBER := 1;
3531: l_unit_price NUMBER := 0;

Line 3699: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;

3695: l_ic_pricing_option := 1;
3696: ELSE
3697:
3698: /* For 11i10, the only supported qualifier is category id. */
3699: l_qualifier_code_tbl(l_qualifier_code_tbl.count+1) := INV_TRANSACTION_FLOW_PUB.G_QUALIFIER_CODE;
3700: l_qualifier_value_tbl(l_qualifier_value_tbl.count+1) := l_category_id;
3701:
3702: l_stmt_num := 50;
3703: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3713: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(

3709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
3710: ,l_api_message);
3711: END IF;
3712:
3713: INV_TRANSACTION_FLOW_PUB.GET_TRANSACTION_FLOW(
3714: x_return_status => l_return_status,
3715: x_msg_data => l_msg_data,
3716: x_msg_count => l_msg_count,
3717: x_transaction_flows_tbl => l_transaction_flows_tbl,

Line 3721: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,

3717: x_transaction_flows_tbl => l_transaction_flows_tbl,
3718: p_api_version => 1.0,
3719: p_start_operating_unit => l_po_org_id,
3720: p_end_operating_unit => l_rcv_org_id,
3721: p_flow_type => INV_TRANSACTION_FLOW_PUB.G_PROCURING_FLOW_TYPE,
3722: p_organization_id => l_rcv_organization_id,
3723: p_qualifier_code_tbl => l_qualifier_code_tbl,
3724: p_qualifier_value_tbl => l_qualifier_value_tbl,
3725: p_transaction_date => l_rcv_trx_date,