[Home] [Help]
5993: END IF;
5994:
5995: --Risk Score evaluation -- Bug 6805953
5996: IF nvl(p_risk_eval_flag, 'Y') = 'Y' THEN --change flag to p_risk_eval_flag l_RiskEval_Enable_Flag verify
5997: -- l_risk_threshold := oe_sys_parameters.value('RISK_FACTOR_THRESHOLD');
5998: IF l_debug_level > 0 THEN
5999: oe_debug_pub.add('Risk threshold value....'||L_auth_result.risk_result.Risk_Threshold_Val);
6000: oe_debug_pub.add('Risk score...'||L_auth_result.risk_result.risk_score);
6001: oe_debug_pub.add('Risky Flag : ' || L_auth_result.risk_result.risky_flag);
6782: (SELECT 'Non Invoiceable Item Line'
6783: FROM mtl_system_items mti
6784: WHERE mti.inventory_item_id = ool.inventory_item_id
6785: AND mti.organization_id = nvl(ool.ship_from_org_id,
6786: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
6787: AND (mti.invoiceable_item_flag = 'N'
6788: OR mti.invoice_enabled_flag = 'N'));
6789:
6790: EXCEPTION
6811: FROM mtl_system_items mti, oe_order_lines_all ool
6812: WHERE ool.line_id = op.line_id
6813: AND mti.inventory_item_id = ool.inventory_item_id
6814: AND mti.organization_id = nvl(ool.ship_from_org_id,
6815: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
6816: AND (mti.invoiceable_item_flag = 'N'
6817: OR mti.invoice_enabled_flag = 'N'));
6818: ELSE
6819: SELECT nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price)
6828: (SELECT 'Non Invoiceable Item Line'
6829: FROM mtl_system_items mti
6830: WHERE mti.inventory_item_id = ool.inventory_item_id
6831: AND mti.organization_id = nvl(ool.ship_from_org_id,
6832: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
6833: AND (mti.invoiceable_item_flag = 'N'
6834: OR mti.invoice_enabled_flag = 'N'));
6835: END IF;
6836:
6895: + nvl(l_charge_amount,0);
6896:
6897: --pnpl adding the checks w.r.t p_amount_type
6898: IF p_amount_type IS NULL THEN
6899: --IF oe_sys_parameters.value('ACCOUNT_FIRST_INSTALLMENT_ONLY') = 'Y'
6900: --pnpl
6901: IF Oe_Prepayment_Util.Get_Installment_Options = 'AUTHORIZE_FIRST_INSTALLMENT' THEN
6902:
6903: l_pay_now_total_detail_tbl(1).line_id := p_line_id;
7050: (SELECT 'Non Invoiceable Item Line'
7051: FROM mtl_system_items mti
7052: WHERE mti.inventory_item_id = ool.inventory_item_id
7053: AND mti.organization_id = nvl(ool.ship_from_org_id,
7054: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7055: AND (mti.invoiceable_item_flag = 'N'
7056: OR mti.invoice_enabled_flag = 'N'));
7057: EXCEPTION
7058: WHEN NO_DATA_FOUND THEN
7078: FROM mtl_system_items mti, oe_order_lines_all ool
7079: WHERE ool.line_id = op.line_id
7080: AND mti.inventory_item_id = ool.inventory_item_id
7081: AND mti.organization_id = nvl(ool.ship_from_org_id,
7082: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7083: AND (mti.invoiceable_item_flag = 'N'
7084: OR mti.invoice_enabled_flag = 'N'));
7085: ELSE
7086: SELECT nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price)
7093: (SELECT 'Non Invoiceable Item Line'
7094: FROM mtl_system_items mti
7095: WHERE mti.inventory_item_id = ool.inventory_item_id
7096: AND mti.organization_id = nvl(ool.ship_from_org_id,
7097: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7098: AND (mti.invoiceable_item_flag = 'N'
7099: OR mti.invoice_enabled_flag = 'N'));
7100: END IF;
7101:
7283: (SELECT 'Non Invoiceable Item Line'
7284: FROM mtl_system_items mti
7285: WHERE mti.inventory_item_id = ool.inventory_item_id
7286: AND mti.organization_id = nvl(ool.ship_from_org_id,
7287: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7288: AND (mti.invoiceable_item_flag = 'N'
7289: OR mti.invoice_enabled_flag = 'N'));
7290:
7291: IF OE_Commitment_Pvt.Do_Commitment_Sequencing THEN
7303: FROM mtl_system_items mti, oe_order_lines_all ool
7304: WHERE ool.line_id = op.line_id
7305: AND mti.inventory_item_id = ool.inventory_item_id
7306: AND mti.organization_id = nvl(ool.ship_from_org_id,
7307: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7308: AND (mti.invoiceable_item_flag = 'N'
7309: OR mti.invoice_enabled_flag = 'N'));
7310: ELSE
7311: -- Select the Outbound Extended Price for lines that have committment
7321: (SELECT 'Non Invoiceable Item Line'
7322: FROM mtl_system_items mti
7323: WHERE mti.inventory_item_id = ool.inventory_item_id
7324: AND mti.organization_id = nvl(ool.ship_from_org_id,
7325: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))
7326: AND (mti.invoiceable_item_flag = 'N'
7327: OR mti.invoice_enabled_flag = 'N'));
7328: END IF;
7329:
7365: (SELECT 'Non Invoiceable Item Line'
7366: FROM MTL_SYSTEM_ITEMS MTI
7367: WHERE MTI.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
7368: AND MTI.ORGANIZATION_ID = NVL(L.SHIP_FROM_ORG_ID,
7369: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', L.org_id))
7370: AND (MTI.INVOICEABLE_ITEM_FLAG = 'N'
7371: OR MTI.INVOICE_ENABLED_FLAG = 'N'));
7372:
7373: l_charges := nvl(l_chgs_wo_line_id,0) + nvl(l_chgs_w_line_id,0);