DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on RCV_PARAMETERS

Line 1091: cursor c_rcv_parameters(cp_organization_id number) is

1087: from JAI_CMN_INVENTORY_ORGS
1088: where organization_id = cp_organization_id
1089: and location_id = cp_location_id;
1090:
1091: cursor c_rcv_parameters(cp_organization_id number) is
1092: select receiving_account_id
1093: from rcv_parameters
1094: Where organization_id = cp_organization_id;
1095:

Line 1093: from rcv_parameters

1089: and location_id = cp_location_id;
1090:
1091: cursor c_rcv_parameters(cp_organization_id number) is
1092: select receiving_account_id
1093: from rcv_parameters
1094: Where organization_id = cp_organization_id;
1095:
1096: cursor c_mtl_parameters(cp_organization_id number) is
1097: select ap_accrual_account

Line 1139: r_rcv_parameters c_rcv_parameters%rowtype;

1135: r_ja_in_hr_organization_units1 c_ja_in_hr_organization_units%rowtype;
1136: r_mtl_parameters c_mtl_parameters%rowtype;
1137: r_po_distributions_all c_po_distributions_all%rowtype;
1138: r_po_distributions_all_1 c_po_distributions_all_1%rowtype;
1139: r_rcv_parameters c_rcv_parameters%rowtype;
1140: r_mtl_interorg_parameters c_mtl_interorg_parameters%rowtype;
1141: r_iso_from_org_type c_iso_from_org_type%rowtype; /* Bug#4171469 */
1142:
1143: begin

Line 1196: open c_rcv_parameters(p_organization_id);

1192: p_excise_rcvble_account := r_ja_in_hr_organization_units1.excise_rcvble_account ;
1193: end if;
1194:
1195: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1196: open c_rcv_parameters(p_organization_id);
1197: fetch c_rcv_parameters into r_rcv_parameters;
1198: close c_rcv_parameters;
1199:
1200: p_receiving_account_id := r_rcv_parameters.receiving_account_id;

Line 1197: fetch c_rcv_parameters into r_rcv_parameters;

1193: end if;
1194:
1195: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1196: open c_rcv_parameters(p_organization_id);
1197: fetch c_rcv_parameters into r_rcv_parameters;
1198: close c_rcv_parameters;
1199:
1200: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1201:

Line 1198: close c_rcv_parameters;

1194:
1195: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1196: open c_rcv_parameters(p_organization_id);
1197: fetch c_rcv_parameters into r_rcv_parameters;
1198: close c_rcv_parameters;
1199:
1200: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1201:
1202: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */

Line 1200: p_receiving_account_id := r_rcv_parameters.receiving_account_id;

1196: open c_rcv_parameters(p_organization_id);
1197: fetch c_rcv_parameters into r_rcv_parameters;
1198: close c_rcv_parameters;
1199:
1200: p_receiving_account_id := r_rcv_parameters.receiving_account_id;
1201:
1202: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1203: open c_mtl_parameters(p_organization_id);
1204: fetch c_mtl_parameters into r_mtl_parameters;

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

1848: elsif p_receiving_account_id is null then
1849:
1850: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
1851: p_process_flag := 'E';
1852: p_process_message := 'Receiving Account is not defined in rcv_parameters for the organization.';
1853: goto exit_from_procedure;
1854:
1855: end if; /* if p_receipt_source_code = 'CUSTOMER' then
1856: (p_attribute_category = 'INDIA RMA RECEIPT') */