386: SUM(EDU_CESS_CUSTOMS_AMOUNT) customs_edu_cess,
387: SUM(ADDITIONAL_CVD_AMT) additional_CVD,
388: SUM(SH_CUSTOMS_CESS_AMOUNT) customs_sh_education_cess,
389: SUM(SH_CVD_CESS_AMOUNT) cvd_sh_edu_cess
390: FROM jai_cmn_boe_dtls
391: WHERE BOE_ID = pn_boe_id
392: GROUP BY BOE_ID;
393:
394: CURSOR detail_line_cur(pn_boe_id NUMBER) IS
392: GROUP BY BOE_ID;
393:
394: CURSOR detail_line_cur(pn_boe_id NUMBER) IS
395: SELECT customs_tariff,duty_code,PKG_NUMBER,SERIAL_NUMBER
396: FROM jai_cmn_boe_dtls
397: WHERE BOE_ID = pn_boe_id AND rownum = 1;
398:
399: ln_boe_detail_line_num NUMBER := 1;
400: ln_boe_detail_id NUMBER;
505: SUM(EDU_CESS_CUSTOMS_AMOUNT) customs_edu_cess,
506: SUM(ADDITIONAL_CVD_AMT) additional_CVD,
507: SUM(SH_CUSTOMS_CESS_AMOUNT) customs_sh_education_cess,
508: SUM(SH_CVD_CESS_AMOUNT) cvd_sh_edu_cess
509: FROM jai_cmn_boe_dtls
510: WHERE BOE_ID = v_boe_id
511: GROUP BY BOE_ID, item_number;
512:
513: CURSOR detail_line_cur(pn_boe_id NUMBER, pn_item_number NUMBER) IS
511: GROUP BY BOE_ID, item_number;
512:
513: CURSOR detail_line_cur(pn_boe_id NUMBER, pn_item_number NUMBER) IS
514: SELECT uom_code,customs_tariff,duty_code,PKG_NUMBER,SERIAL_NUMBER
515: FROM jai_cmn_boe_dtls
516: WHERE BOE_ID = pn_boe_id AND item_number = pn_item_number AND rownum = 1;
517:
518: ln_boe_detail_line_num NUMBER := 0;
519: ln_boe_detail_id NUMBER;