APPS.JAI_RCV_RCV_RTV_PKG dependencies on RCV_PARAMETERS

Line 948: cursor c_rcv_parameters(cp_organization_id number) is

944: from JAI_CMN_INVENTORY_ORGS
945: where organization_id = cp_organization_id
946: and location_id = cp_location_id;
947:
948: cursor c_rcv_parameters(cp_organization_id number) is
949: select receiving_account_id
950: from rcv_parameters
951: Where organization_id = cp_organization_id;
952:

Line 950: from rcv_parameters

946: and location_id = cp_location_id;
947:
948: cursor c_rcv_parameters(cp_organization_id number) is
949: select receiving_account_id
950: from rcv_parameters
951: Where organization_id = cp_organization_id;
952:
953: cursor c_mtl_parameters(cp_organization_id number) is
954: select ap_accrual_account

Line 996: r_rcv_parameters c_rcv_parameters%rowtype;

992: r_ja_in_hr_organization_units1 c_ja_in_hr_organization_units%rowtype;
993: r_mtl_parameters c_mtl_parameters%rowtype;
994: r_po_distributions_all c_po_distributions_all%rowtype;
995: r_po_distributions_all_1 c_po_distributions_all_1%rowtype;
996: r_rcv_parameters c_rcv_parameters%rowtype;
997: r_mtl_interorg_parameters c_mtl_interorg_parameters%rowtype;
998: r_iso_from_org_type c_iso_from_org_type%rowtype; /* Bug#4171469 */
999:
1000: begin

Line 1053: open c_rcv_parameters(p_organization_id);

1049: p_excise_rcvble_account := r_ja_in_hr_organization_units1.excise_rcvble_account ;
1050: end if;
1051:
1052: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1053: open c_rcv_parameters(p_organization_id);
1054: fetch c_rcv_parameters into r_rcv_parameters;
1055: close c_rcv_parameters;
1056:
1057: p_receiving_account_id := r_rcv_parameters.receiving_account_id;

Line 1054: fetch c_rcv_parameters into r_rcv_parameters;

1050: end if;
1051:
1052: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1053: open c_rcv_parameters(p_organization_id);
1054: fetch c_rcv_parameters into r_rcv_parameters;
1055: close c_rcv_parameters;
1056:
1057: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1058:

Line 1055: close c_rcv_parameters;

1051:
1052: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1053: open c_rcv_parameters(p_organization_id);
1054: fetch c_rcv_parameters into r_rcv_parameters;
1055: close c_rcv_parameters;
1056:
1057: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1058:
1059: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */

Line 1057: p_receiving_account_id := r_rcv_parameters.receiving_account_id;

1053: open c_rcv_parameters(p_organization_id);
1054: fetch c_rcv_parameters into r_rcv_parameters;
1055: close c_rcv_parameters;
1056:
1057: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1058:
1059: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1060: open c_mtl_parameters(p_organization_id);
1061: fetch c_mtl_parameters into r_mtl_parameters;

Line 1554: p_process_message := 'Receiving Account is not defined in rcv_parameters for the organization.';

1550: elsif p_receiving_account_id is null then
1551:
1552: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
1553: p_process_flag := 'E';
1554: p_process_message := 'Receiving Account is not defined in rcv_parameters for the organization.';
1555: goto exit_from_procedure;
1556:
1557: end if; /* if p_receipt_source_code = 'CUSTOMER' then
1558: (p_attribute_category = 'INDIA RMA RECEIPT') */