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.CSI_RMA_FULFILL_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 152: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)

148: PROCEDURE rma_fulfillment(
149: p_rma_line_id IN number,
150: p_message_id IN number,
151: x_return_status OUT NOCOPY varchar2,
152: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
153: IS
154:
155: l_api_name varchar2(30) := 'rma_fulfillment';
156:

Line 161: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

157: l_txn_line_id number;
158: l_txn_sub_type_id number ;
159: l_src_txn_table varchar2(30) := 'OE_ORDER_LINES_ALL';
160: l_txn_type_id number := 54;
161: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
162:
163: l_g_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
164: l_g_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
165:

Line 196: l_error_rec csi_datastructures_pub.transaction_error_rec;

192: l_msg_dummy varchar2(32767);
193: l_msg_count number;
194: do_not_process exception;
195:
196: l_error_rec csi_datastructures_pub.transaction_error_rec;
197: l_orgn_id number;
198: l_tld_quantity number;
199: l_canceled_qty NUMBER;
200:

Line 586: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

582: End rma_fulfillment;
583:
584: PROCEDURE fulfill_rma_line(
585: p_rma_line_rec IN oe_order_lines_all%rowtype,
586: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
587: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
588: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
589: x_msg_count OUT NOCOPY number,
590: x_msg_data OUT NOCOPY varchar2,

Line 588: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

584: PROCEDURE fulfill_rma_line(
585: p_rma_line_rec IN oe_order_lines_all%rowtype,
586: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
587: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
588: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
589: x_msg_count OUT NOCOPY number,
590: x_msg_data OUT NOCOPY varchar2,
591: x_return_status OUT NOCOPY varchar2)
592: IS

Line 596: l_csi_trxn_rec csi_datastructures_pub.transaction_rec;

592: IS
593:
594: l_api_name varchar2(30) := 'fulfill_rma_line';
595: l_txn_type_id number := 54;
596: l_csi_trxn_rec csi_datastructures_pub.transaction_rec;
597: l_txn_sub_type_rec csi_order_ship_pub.txn_sub_type_rec;
598: l_src_line_rec csi_order_ship_pub.order_line_rec;
599:
600: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 615: l_instance_rec csi_datastructures_pub.instance_header_rec;

611: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
612: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
613: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
614:
615: l_instance_rec csi_datastructures_pub.instance_header_rec;
616: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
617: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
618: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 616: l_party_header_tbl csi_datastructures_pub.party_header_tbl;

612: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
613: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
614:
615: l_instance_rec csi_datastructures_pub.instance_header_rec;
616: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
617: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
618: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 617: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

613: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
614:
615: l_instance_rec csi_datastructures_pub.instance_header_rec;
616: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
617: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
618: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
621: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 618: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;

614:
615: l_instance_rec csi_datastructures_pub.instance_header_rec;
616: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
617: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
618: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
621: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
622: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;

615: l_instance_rec csi_datastructures_pub.instance_header_rec;
616: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
617: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
618: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
621: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
622: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
623: l_upd_parties_tbl csi_datastructures_pub.party_tbl;

Line 620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;

616: l_party_header_tbl csi_datastructures_pub.party_header_tbl;
617: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
618: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
621: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
622: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
623: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
624: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 621: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;

617: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
618: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
621: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
622: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
623: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
624: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
625:

Line 622: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;

618: l_org_assignments_tbl csi_datastructures_pub.org_units_header_tbl;
619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
621: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
622: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
623: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
624: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
625:
626: -- update_item_instance variables

Line 623: l_upd_parties_tbl csi_datastructures_pub.party_tbl;

619: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
621: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
622: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
623: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
624: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
625:
626: -- update_item_instance variables
627: l_u_instance_rec csi_datastructures_pub.instance_rec;

Line 624: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

620: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl;
621: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl;
622: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_header_tbl;
623: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
624: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
625:
626: -- update_item_instance variables
627: l_u_instance_rec csi_datastructures_pub.instance_rec;
628: l_u_parties_tbl csi_datastructures_pub.party_tbl;

Line 627: l_u_instance_rec csi_datastructures_pub.instance_rec;

623: l_upd_parties_tbl csi_datastructures_pub.party_tbl;
624: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
625:
626: -- update_item_instance variables
627: l_u_instance_rec csi_datastructures_pub.instance_rec;
628: l_u_parties_tbl csi_datastructures_pub.party_tbl;
629: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
630: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
631: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 628: l_u_parties_tbl csi_datastructures_pub.party_tbl;

624: l_upd_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
625:
626: -- update_item_instance variables
627: l_u_instance_rec csi_datastructures_pub.instance_rec;
628: l_u_parties_tbl csi_datastructures_pub.party_tbl;
629: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
630: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
631: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
632: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 629: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

625:
626: -- update_item_instance variables
627: l_u_instance_rec csi_datastructures_pub.instance_rec;
628: l_u_parties_tbl csi_datastructures_pub.party_tbl;
629: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
630: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
631: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
632: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
633: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 630: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

626: -- update_item_instance variables
627: l_u_instance_rec csi_datastructures_pub.instance_rec;
628: l_u_parties_tbl csi_datastructures_pub.party_tbl;
629: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
630: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
631: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
632: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
633: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
634: l_u_instance_ids_list csi_datastructures_pub.id_tbl;

Line 631: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

627: l_u_instance_rec csi_datastructures_pub.instance_rec;
628: l_u_parties_tbl csi_datastructures_pub.party_tbl;
629: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
630: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
631: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
632: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
633: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
634: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
635:

Line 632: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

628: l_u_parties_tbl csi_datastructures_pub.party_tbl;
629: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
630: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
631: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
632: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
633: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
634: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
635:
636: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 633: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

629: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
630: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
631: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
632: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
633: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
634: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
635:
636: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
637: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 634: l_u_instance_ids_list csi_datastructures_pub.id_tbl;

630: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
631: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
632: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
633: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
634: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
635:
636: l_u_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
637: l_u_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
638: l_u_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 696: l_chg_instance_rec csi_datastructures_pub.instance_rec;

692: l_literal1 VARCHAR2(30) ;
693: l_literal2 VARCHAR2(30) ;
694:
695: -- added as part of fix for Bug 2733128
696: l_chg_instance_rec csi_datastructures_pub.instance_rec;
697: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
698: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
699: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
700: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 697: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

693: l_literal2 VARCHAR2(30) ;
694:
695: -- added as part of fix for Bug 2733128
696: l_chg_instance_rec csi_datastructures_pub.instance_rec;
697: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
698: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
699: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
700: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
701: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

Line 698: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

694:
695: -- added as part of fix for Bug 2733128
696: l_chg_instance_rec csi_datastructures_pub.instance_rec;
697: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
698: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
699: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
700: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
701: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
702: -- split item instance variables

Line 699: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;

695: -- added as part of fix for Bug 2733128
696: l_chg_instance_rec csi_datastructures_pub.instance_rec;
697: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
698: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
699: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
700: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
701: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
702: -- split item instance variables
703: l_split_src_inst_rec csi_datastructures_pub.instance_rec;

Line 700: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

696: l_chg_instance_rec csi_datastructures_pub.instance_rec;
697: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
698: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
699: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
700: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
701: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
702: -- split item instance variables
703: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
704: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

Line 701: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

697: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
698: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
699: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
700: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
701: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
702: -- split item instance variables
703: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
704: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
705: l_quantity1 NUMBER;

Line 703: l_split_src_inst_rec csi_datastructures_pub.instance_rec;

699: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
700: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
701: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
702: -- split item instance variables
703: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
704: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
705: l_quantity1 NUMBER;
706: l_locked_inst_rev_num NUMBER;
707: l_lock_id NUMBER;

Line 704: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

700: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
701: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
702: -- split item instance variables
703: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
704: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
705: l_quantity1 NUMBER;
706: l_locked_inst_rev_num NUMBER;
707: l_lock_id NUMBER;
708: l_lock_status NUMBER;

Line 733: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

729: SELECT internal_party_id, ownership_override_at_txn
730: INTO l_internal_party_id, l_pty_override_flag
731: FROM csi_install_parameters;
732: */
733: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
734: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
735:
736: SELECT party_id
737: INTO l_src_txn_owner_pty_id

Line 734: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;

730: INTO l_internal_party_id, l_pty_override_flag
731: FROM csi_install_parameters;
732: */
733: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
734: l_pty_override_flag := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
735:
736: SELECT party_id
737: INTO l_src_txn_owner_pty_id
738: FROM hz_cust_accounts_all