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.JAI_RCV_RCV_RTV_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 415: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;

411: ln_vat_recoverable number;
412:
413: --lv_accounting_method_option ap_system_parameters_all.accounting_method_option%type; /* Service */
414: --commented the above by Sanjikum for Bug#4474501
415: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;
416: ln_excise_edu_cess number; /* Educational Cess */
417: ln_excise_sh_edu_cess number; /*Bug 5989740 bduvarag*/
418: ln_cvd_edu_cess number; /* Educational Cess */
419: ln_cvd_sh_edu_cess number; /*Bug 5989740 bduvarag*/

Line 1101: cursor c_po_distributions_all(cp_po_distribution_id number) is

1097: select ap_accrual_account
1098: from mtl_parameters
1099: where organization_id = cp_organization_id;
1100:
1101: cursor c_po_distributions_all(cp_po_distribution_id number) is
1102: select accrual_account_id
1103: from po_distributions_all
1104: where po_distribution_id = cp_po_distribution_id;
1105:

Line 1103: from po_distributions_all

1099: where organization_id = cp_organization_id;
1100:
1101: cursor c_po_distributions_all(cp_po_distribution_id number) is
1102: select accrual_account_id
1103: from po_distributions_all
1104: where po_distribution_id = cp_po_distribution_id;
1105:
1106: cursor c_po_distributions_all_1(cp_po_line_location_id number) is
1107: select accrual_account_id

Line 1106: cursor c_po_distributions_all_1(cp_po_line_location_id number) is

1102: select accrual_account_id
1103: from po_distributions_all
1104: where po_distribution_id = cp_po_distribution_id;
1105:
1106: cursor c_po_distributions_all_1(cp_po_line_location_id number) is
1107: select accrual_account_id
1108: from po_distributions_all
1109: where po_distribution_id =
1110: (

Line 1108: from po_distributions_all

1104: where po_distribution_id = cp_po_distribution_id;
1105:
1106: cursor c_po_distributions_all_1(cp_po_line_location_id number) is
1107: select accrual_account_id
1108: from po_distributions_all
1109: where po_distribution_id =
1110: (
1111: select max(po_distribution_id)
1112: from po_distributions_all

Line 1112: from po_distributions_all

1108: from po_distributions_all
1109: where po_distribution_id =
1110: (
1111: select max(po_distribution_id)
1112: from po_distributions_all
1113: where line_location_id = cp_po_line_location_id
1114: );
1115:
1116: cursor c_mtl_interorg_parameters

Line 1137: r_po_distributions_all c_po_distributions_all%rowtype;

1133:
1134: r_ja_in_hr_organization_units c_ja_in_hr_organization_units%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 */

Line 1138: r_po_distributions_all_1 c_po_distributions_all_1%rowtype;

1134: r_ja_in_hr_organization_units c_ja_in_hr_organization_units%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:

Line 1214: open c_po_distributions_all(p_po_distribution_id);

1210: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
1211: if p_po_distribution_id is not null then
1212:
1213: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1214: open c_po_distributions_all(p_po_distribution_id);
1215: fetch c_po_distributions_all into r_po_distributions_all;
1216: close c_po_distributions_all;
1217:
1218: p_po_accrual_account_id := r_po_distributions_all.accrual_account_id;

Line 1215: fetch c_po_distributions_all into r_po_distributions_all;

1211: if p_po_distribution_id is not null then
1212:
1213: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1214: open c_po_distributions_all(p_po_distribution_id);
1215: fetch c_po_distributions_all into r_po_distributions_all;
1216: close c_po_distributions_all;
1217:
1218: p_po_accrual_account_id := r_po_distributions_all.accrual_account_id;
1219:

Line 1216: close c_po_distributions_all;

1212:
1213: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
1214: open c_po_distributions_all(p_po_distribution_id);
1215: fetch c_po_distributions_all into r_po_distributions_all;
1216: close c_po_distributions_all;
1217:
1218: p_po_accrual_account_id := r_po_distributions_all.accrual_account_id;
1219:
1220: end if;

Line 1218: p_po_accrual_account_id := r_po_distributions_all.accrual_account_id;

1214: open c_po_distributions_all(p_po_distribution_id);
1215: fetch c_po_distributions_all into r_po_distributions_all;
1216: close c_po_distributions_all;
1217:
1218: p_po_accrual_account_id := r_po_distributions_all.accrual_account_id;
1219:
1220: end if;
1221:
1222:

Line 1223: if r_po_distributions_all.accrual_account_id is null and

1219:
1220: end if;
1221:
1222:
1223: if r_po_distributions_all.accrual_account_id is null and
1224: p_po_line_location_id is not null then
1225:
1226: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1227: open c_po_distributions_all_1(p_po_line_location_id);

Line 1227: open c_po_distributions_all_1(p_po_line_location_id);

1223: if r_po_distributions_all.accrual_account_id is null and
1224: p_po_line_location_id is not null then
1225:
1226: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1227: open c_po_distributions_all_1(p_po_line_location_id);
1228: fetch c_po_distributions_all_1 into r_po_distributions_all_1;
1229: close c_po_distributions_all_1;
1230:
1231: p_po_accrual_account_id := r_po_distributions_all_1.accrual_account_id;

Line 1228: fetch c_po_distributions_all_1 into r_po_distributions_all_1;

1224: p_po_line_location_id is not null then
1225:
1226: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1227: open c_po_distributions_all_1(p_po_line_location_id);
1228: fetch c_po_distributions_all_1 into r_po_distributions_all_1;
1229: close c_po_distributions_all_1;
1230:
1231: p_po_accrual_account_id := r_po_distributions_all_1.accrual_account_id;
1232:

Line 1229: close c_po_distributions_all_1;

1225:
1226: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
1227: open c_po_distributions_all_1(p_po_line_location_id);
1228: fetch c_po_distributions_all_1 into r_po_distributions_all_1;
1229: close c_po_distributions_all_1;
1230:
1231: p_po_accrual_account_id := r_po_distributions_all_1.accrual_account_id;
1232:
1233: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */

Line 1231: p_po_accrual_account_id := r_po_distributions_all_1.accrual_account_id;

1227: open c_po_distributions_all_1(p_po_line_location_id);
1228: fetch c_po_distributions_all_1 into r_po_distributions_all_1;
1229: close c_po_distributions_all_1;
1230:
1231: p_po_accrual_account_id := r_po_distributions_all_1.accrual_account_id;
1232:
1233: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1234:
1235: end if;