DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_INTERFACE_PKG

Line 8451: l_source_header_rec csi_interface_pkg.source_header_rec;

8447:
8448: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8449: l_td_found boolean := FALSE;
8450:
8451: l_source_header_rec csi_interface_pkg.source_header_rec;
8452: l_source_line_rec csi_interface_pkg.source_line_rec;
8453:
8454: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8455:

Line 8452: l_source_line_rec csi_interface_pkg.source_line_rec;

8448: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8449: l_td_found boolean := FALSE;
8450:
8451: l_source_header_rec csi_interface_pkg.source_header_rec;
8452: l_source_line_rec csi_interface_pkg.source_line_rec;
8453:
8454: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8455:
8456: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 8497: csi_interface_pkg.get_source_info(

8493: api_log('cz_fulfillment');
8494:
8495: savepoint cz_fulfillment;
8496:
8497: csi_interface_pkg.get_source_info(
8498: p_source_table => csi_interface_pkg.g_om_source_table,
8499: p_source_id => p_order_line_id,
8500: x_source_header_rec => l_source_header_rec,
8501: x_source_line_rec => l_source_line_rec,

Line 8498: p_source_table => csi_interface_pkg.g_om_source_table,

8494:
8495: savepoint cz_fulfillment;
8496:
8497: csi_interface_pkg.get_source_info(
8498: p_source_table => csi_interface_pkg.g_om_source_table,
8499: p_source_id => p_order_line_id,
8500: x_source_header_rec => l_source_header_rec,
8501: x_source_line_rec => l_source_line_rec,
8502: x_return_status => l_return_status);

Line 8509: l_txn_line_rec.source_transaction_table := csi_interface_pkg.g_om_source_table;

8505: RAISE fnd_api.g_exc_error;
8506: END IF;
8507:
8508: -- check for user entered transaction details
8509: l_txn_line_rec.source_transaction_table := csi_interface_pkg.g_om_source_table;
8510: l_txn_line_rec.source_transaction_id := l_source_line_rec.source_line_id;
8511:
8512: l_td_found := csi_t_txn_details_pvt.check_txn_details_exist(
8513: p_txn_line_rec => l_txn_line_rec);

Line 8518: l_txn_line_query_rec.source_transaction_table := csi_interface_pkg.g_om_source_table;

8514:
8515: -- if entered then re build using the transaction details using the source info
8516: IF l_td_found THEN
8517:
8518: l_txn_line_query_rec.source_transaction_table := csi_interface_pkg.g_om_source_table;
8519: l_txn_line_query_rec.source_transaction_id := l_source_line_rec.source_line_id;
8520:
8521: csi_t_txn_details_grp.get_transaction_details(
8522: p_api_version => 1.0,

Line 8553: -- l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_om_txn_type_id;

8549: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8550: RAISE fnd_api.g_exc_error;
8551: END IF;
8552:
8553: -- l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_om_txn_type_id;
8554: l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_macd_txn_type_id; --bug 5194812
8555:
8556: l_txn_line_rec.processing_status := 'SUBMIT';
8557:

Line 8554: l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_macd_txn_type_id; --bug 5194812

8550: RAISE fnd_api.g_exc_error;
8551: END IF;
8552:
8553: -- l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_om_txn_type_id;
8554: l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_macd_txn_type_id; --bug 5194812
8555:
8556: l_txn_line_rec.processing_status := 'SUBMIT';
8557:
8558: l_txn_line_detail_tbl := l_g_line_dtl_tbl;

Line 8563: csi_interface_pkg.rebuild_txn_detail(

8559: l_txn_party_tbl := l_g_pty_dtl_tbl;
8560: l_txn_party_acct_tbl := l_g_pty_acct_tbl;
8561: l_txn_org_assgn_tbl := l_g_org_assgn_tbl;
8562:
8563: csi_interface_pkg.rebuild_txn_detail(
8564: p_source_table => csi_interface_pkg.g_om_source_table,
8565: p_source_id => p_order_line_id,
8566: p_source_header_rec => l_source_header_rec,
8567: p_source_line_rec => l_source_line_rec,

Line 8564: p_source_table => csi_interface_pkg.g_om_source_table,

8560: l_txn_party_acct_tbl := l_g_pty_acct_tbl;
8561: l_txn_org_assgn_tbl := l_g_org_assgn_tbl;
8562:
8563: csi_interface_pkg.rebuild_txn_detail(
8564: p_source_table => csi_interface_pkg.g_om_source_table,
8565: p_source_id => p_order_line_id,
8566: p_source_header_rec => l_source_header_rec,
8567: p_source_line_rec => l_source_line_rec,
8568: p_csi_txn_rec => l_csi_txn_rec,

Line 8584: l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_macd_txn_type_id;

8580:
8581: ELSE -- if not entered then build a brand new one using the source info
8582:
8583: --code for bug 5194812--
8584: l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_macd_txn_type_id;
8585:
8586: csi_interface_pkg.build_default_txn_detail(
8587: p_source_table => csi_interface_pkg.g_om_source_table,
8588: p_source_id => p_order_line_id,

Line 8586: csi_interface_pkg.build_default_txn_detail(

8582:
8583: --code for bug 5194812--
8584: l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_macd_txn_type_id;
8585:
8586: csi_interface_pkg.build_default_txn_detail(
8587: p_source_table => csi_interface_pkg.g_om_source_table,
8588: p_source_id => p_order_line_id,
8589: p_source_header_rec => l_source_header_rec,
8590: p_source_line_rec => l_source_line_rec,

Line 8587: p_source_table => csi_interface_pkg.g_om_source_table,

8583: --code for bug 5194812--
8584: l_txn_line_rec.source_transaction_type_id := csi_interface_pkg.g_macd_txn_type_id;
8585:
8586: csi_interface_pkg.build_default_txn_detail(
8587: p_source_table => csi_interface_pkg.g_om_source_table,
8588: p_source_id => p_order_line_id,
8589: p_source_header_rec => l_source_header_rec,
8590: p_source_line_rec => l_source_line_rec,
8591: p_csi_txn_rec => l_csi_txn_rec,

Line 8608: csi_interface_pkg.get_relations(

8604: END IF;
8605:
8606: --get the relations from om/config transaction details
8607:
8608: csi_interface_pkg.get_relations(
8609: p_source_id => p_order_line_id,
8610: p_source_table => csi_interface_pkg.g_om_source_table,
8611: p_source_header_rec => l_source_header_rec,
8612: p_source_line_rec => l_source_line_rec,

Line 8610: p_source_table => csi_interface_pkg.g_om_source_table,

8606: --get the relations from om/config transaction details
8607:
8608: csi_interface_pkg.get_relations(
8609: p_source_id => p_order_line_id,
8610: p_source_table => csi_interface_pkg.g_om_source_table,
8611: p_source_header_rec => l_source_header_rec,
8612: p_source_line_rec => l_source_line_rec,
8613: px_txn_line_rec => l_txn_line_rec,
8614: px_txn_line_dtl_tbl => l_txn_line_detail_tbl,

Line 8654: csi_interface_pkg.interface_ib(

8650: END LOOP;
8651: END IF;
8652:
8653:
8654: csi_interface_pkg.interface_ib(
8655: p_source_header_rec => l_source_header_rec,
8656: p_source_line_rec => l_source_line_rec,
8657: px_csi_txn_rec => l_csi_txn_rec,
8658: px_txn_line_rec => l_txn_line_rec,

Line 9521: l_macd_processing := csi_interface_pkg.check_macd_processing(

9517: l_om_session_key.session_hdr_id := l_order_line_rec.config_header_id;
9518: l_om_session_key.session_rev_num := l_order_line_rec.config_rev_nbr;
9519: l_om_session_key.session_item_id := l_order_line_rec.configuration_id;
9520:
9521: l_macd_processing := csi_interface_pkg.check_macd_processing(
9522: p_config_session_key => l_om_session_key,
9523: x_return_status => l_return_status);
9524:
9525: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 9573: l_csi_txn_rec.transaction_type_id := csi_interface_pkg.g_macd_txn_type_id; --l_txn_type_id; --bug 5194812

9569: l_order_line_rec.option_number;
9570: l_csi_txn_rec.source_header_ref := l_order_header_rec.order_number;
9571: l_csi_txn_rec.source_header_ref_id := l_p_order_line_rec.header_id;
9572:
9573: l_csi_txn_rec.transaction_type_id := csi_interface_pkg.g_macd_txn_type_id; --l_txn_type_id; --bug 5194812
9574:
9575: l_csi_txn_rec.transaction_date := sysdate;
9576: l_csi_txn_rec.source_transaction_date := nvl(l_order_line_rec.fulfillment_date, sysdate);
9577: --