[Home] [Help]
2101: flow as defined in paisql.lpc
2102: In case of GROUP, the total credit amount has to be pro-rated across the user selected lines indicated by
2103: credit_process_flag = 'Y'
2104: In case of LINES the credit amount is already populated on the lines that are to be credited
2105: In case of GROUP/LINES, after the credit amount is populated in the standard lines, corresponding retention lines
2106: are also to be credited . A separate API distribute_credit_amount_retn will be called to do the same */
2107:
2108: if p_credit_action_type = 'GROUP' then
2109:
2176:
2177: /*-----------------------------------------------------------------------------------------+
2178: | Procedure : distribute_credit_amount_retn |
2179: | Purpose : To distribute the credit amount on the retention lines based on the |
2180: | corresponding standard line's credit amount |
2181: | Parameters : |
2182: | ================================================================================== |
2183: | Name Mode Description |
2184: | ================================================================================== |
2264: and invoice_line_type = 'RETENTION';
2265:
2266: else -- NEW MODEL
2267:
2268: /* select the standard lines which are to be credited within a loop
2269: For every line of the draft invoice item, we require the retained amount
2270: (will be in invoice processing currency) , retention rule id and retention_line_num (indicates which line
2271: in the draft_invoice_items corresponds to retention of this standard line.
2272: Once we get these, store these values into local variables and set line_processed_flag to TRUE
2267:
2268: /* select the standard lines which are to be credited within a loop
2269: For every line of the draft invoice item, we require the retained amount
2270: (will be in invoice processing currency) , retention rule id and retention_line_num (indicates which line
2271: in the draft_invoice_items corresponds to retention of this standard line.
2272: Once we get these, store these values into local variables and set line_processed_flag to TRUE
2273: Call compute_retn_credit_amount API with the fetched values. The logic to get these values will be:
2274:
2275: If the line represents event (event_num will be not null)
2490:
2491: /*-----------------------------------------------------------------------------------------+
2492: | Procedure : compute_retn_credit_amount |
2493: | Purpose : To compute retention credit amount based on the retention setup of |
2494: | the standard lines |
2495: | Parameters : |
2496: | ================================================================================== |
2497: | Name Mode Description |
2498: | ================================================================================== |
2497: | Name Mode Description |
2498: | ================================================================================== |
2499: | p_project_id IN Project ID |
2500: | p_draft_invoice_num IN Draft invoice for which retention is to be credited |
2501: | p_retention_rule_id IN Retention rule id applied on the standard line |
2502: | p_retention_line_num IN Draft invoice line num on which retention credit amt |
2503: | is to be stamped/computed |
2504: | p_retained_amount IN Retained amount on the standard invoice line |
2505: | p_amount IN Line amount of the standard line for which retention |
2500: | p_draft_invoice_num IN Draft invoice for which retention is to be credited |
2501: | p_retention_rule_id IN Retention rule id applied on the standard line |
2502: | p_retention_line_num IN Draft invoice line num on which retention credit amt |
2503: | is to be stamped/computed |
2504: | p_retained_amount IN Retained amount on the standard invoice line |
2505: | p_amount IN Line amount of the standard line for which retention |
2506: | credit amount is to be computed |
2507: | p_credit_amount IN Line credit amount of the standard line for which |
2508: | retention credit amount is to be computed |
2501: | p_retention_rule_id IN Retention rule id applied on the standard line |
2502: | p_retention_line_num IN Draft invoice line num on which retention credit amt |
2503: | is to be stamped/computed |
2504: | p_retained_amount IN Retained amount on the standard invoice line |
2505: | p_amount IN Line amount of the standard line for which retention |
2506: | credit amount is to be computed |
2507: | p_credit_amount IN Line credit amount of the standard line for which |
2508: | retention credit amount is to be computed |
2509: | x_return_status OUT Return status of this procedure |
2503: | is to be stamped/computed |
2504: | p_retained_amount IN Retained amount on the standard invoice line |
2505: | p_amount IN Line amount of the standard line for which retention |
2506: | credit amount is to be computed |
2507: | p_credit_amount IN Line credit amount of the standard line for which |
2508: | retention credit amount is to be computed |
2509: | x_return_status OUT Return status of this procedure |
2510: | x_msg_count OUT Error message count |
2511: | x_msg_data OUT Error message |
2542: credit amount
2543:
2544: If there is a threshold amount/retention amount defined, it is not possible to figure out the value of these
2545: amounts at the point invoice was generated. So we get the ratio of retained amount over line amount of the
2546: standard line on the line credit amount to get retention credit amount */
2547:
2548: select nvl(threshold_amount,0), nvl(retention_percentage,0), nvl(retention_amount,0)
2549: into l_threshold_amount, l_retention_percentage, l_retention_amount
2550: from pa_proj_retn_rules