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_AP_ST_REVERSE_PROCESS dependencies on AP_INVOICE_DISTRIBUTIONS

Line 455: AP_INVOICE_DISTRIBUTIONS_ALL ap_dist

451: CURSOR c_jai_cmn_document_taxes
452: IS
453: SELECT ap_dist.invoice_distribution_id, ap_dist.amount, to_number(ap_line.REFERENCE_KEY1) tax_id
454: FROM AP_INVOICE_LINES_ALL ap_line,
455: AP_INVOICE_DISTRIBUTIONS_ALL ap_dist
456: WHERE ap_dist.invoice_id = pn_invoice_id
457: AND ap_line.invoice_id = ap_dist.invoice_id
458: AND ap_dist.invoice_line_number = ap_line.line_number
459: AND ap_line.line_type_lookup_code = 'MISCELLANEOUS'

Line 480: AP_INVOICE_DISTRIBUTIONS_ALL d

476:
477: CURSOR get_ap_tax_dtl (cn_dist_id NUMBER)IS
478: SELECT modvat_flag
479: FROM JAI_CMN_DOCUMENT_TAXES a,
480: AP_INVOICE_DISTRIBUTIONS_ALL d
481: WHERE d.invoice_distribution_id = cn_dist_id
482: AND a.source_doc_id = pn_invoice_id
483: AND d.invoice_line_number = a.source_doc_line_id;
484:

Line 486: /* changes done by abhidutt for bug 12358850. AP_INVOICE_DISTRIBUTIONS_ALL fetches no records when we directly enter Default-Distribution-Account without using distribution button for the invoice line

482: AND a.source_doc_id = pn_invoice_id
483: AND d.invoice_line_number = a.source_doc_line_id;
484:
485:
486: /* changes done by abhidutt for bug 12358850. AP_INVOICE_DISTRIBUTIONS_ALL fetches no records when we directly enter Default-Distribution-Account without using distribution button for the invoice line
487: in payables invoices. Added the cursor "get_assets_tracking_flag" so that asset_tracking_flag value will be fetched from the cursor instead of fetching it from SELECT query directly */
488:
489: CURSOR get_assets_tracking_flag
490: IS

Line 492: FROM ap_invoice_distributions_all

488:
489: CURSOR get_assets_tracking_flag
490: IS
491: SELECT assets_tracking_flag
492: FROM ap_invoice_distributions_all
493: WHERE invoice_id = pn_invoice_id
494: AND invoice_line_number = pn_line_number
495: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all
496: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ; /* Bug 13617527 */

Line 495: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all

491: SELECT assets_tracking_flag
492: FROM ap_invoice_distributions_all
493: WHERE invoice_id = pn_invoice_id
494: AND invoice_line_number = pn_line_number
495: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all
496: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ; /* Bug 13617527 */
497:
498: tax_rec get_tax_cur%ROWTYPE;
499: ap_tax_dtl_rec get_ap_tax_dtl%ROWTYPE;

Line 568: UPDATE ap_invoice_distributions_all

564: ln_chargeble_acct_ccid := NULL;
565: END IF;
566: END IF;
567:
568: UPDATE ap_invoice_distributions_all
569: SET dist_code_combination_id = ln_dist_acct_ccid
570: WHERE invoice_distribution_id = r_jai_cmn_document_taxes.invoice_distribution_id;
571:
572: END LOOP;

Line 710: ap_invoice_distributions_all

706: CURSOR item_dist_account_cur IS
707: SELECT
708: dist_code_combination_id
709: FROM
710: ap_invoice_distributions_all
711: WHERE invoice_id = pn_invoice_id
712: AND invoice_line_number = pn_item_line_number
713: AND distribution_line_number =1;
714:

Line 1424: p_ap_invoice_dist_all_rec IN ap_invoice_distributions_all%ROWTYPE

1420:
1421:
1422:
1423: PROCEDURE Insert_ap_inv_dst_line(
1424: p_ap_invoice_dist_all_rec IN ap_invoice_distributions_all%ROWTYPE
1425: )IS
1426: l_api_name CONSTANT VARCHAR2(50) := 'Insert_ap_inv_dst_line()';
1427: BEGIN
1428: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, GV_MODULE_PREFIX || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');

Line 1430: INSERT INTO ap_invoice_distributions_all

1426: l_api_name CONSTANT VARCHAR2(50) := 'Insert_ap_inv_dst_line()';
1427: BEGIN
1428: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, GV_MODULE_PREFIX || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
1429:
1430: INSERT INTO ap_invoice_distributions_all
1431: (ACCOUNTING_DATE
1432: ,ACCRUAL_POSTED_FLAG
1433: ,ASSETS_ADDITION_FLAG
1434: ,ASSETS_TRACKING_FLAG

Line 2265: ap_invoice_distributions_all

2261: , ASSET_BOOK_TYPE_CODE
2262: , ASSET_CATEGORY_ID
2263: ,accounting_event_id --added for bug#10044104
2264: FROM
2265: ap_invoice_distributions_all
2266: WHERE invoice_id = ln_invoice_id
2267: AND invoice_line_number = pn_line_number
2268: AND distribution_line_number = pn_distribution_line_number; /*1; Bug 13617527 */
2269:

Line 2314: from ap_invoice_distributions_all

2310: and line_number=p_invoice_line_number;
2311:
2312: cursor c_exists_ap_invoice_dist_lines (p_invoice_id number, p_invoice_line_number number, p_distribution_line_number number) is
2313: select count(*)
2314: from ap_invoice_distributions_all
2315: where invoice_id = p_invoice_id
2316: and invoice_line_number = p_invoice_line_number
2317: and distribution_line_number = p_distribution_line_number;
2318: ln_exists number := null;

Line 2320: ap_invoice_distributions_all.assets_addition_flag%TYPE;

2316: and invoice_line_number = p_invoice_line_number
2317: and distribution_line_number = p_distribution_line_number;
2318: ln_exists number := null;
2319: ln_dist_asst_add_flag
2320: ap_invoice_distributions_all.assets_addition_flag%TYPE;
2321: ln_dist_asst_trck_flag
2322: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
2323: ln_dist_project_id
2324: ap_invoice_distributions_all.project_id%TYPE;

Line 2322: ap_invoice_distributions_all.assets_tracking_flag%TYPE;

2318: ln_exists number := null;
2319: ln_dist_asst_add_flag
2320: ap_invoice_distributions_all.assets_addition_flag%TYPE;
2321: ln_dist_asst_trck_flag
2322: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
2323: ln_dist_project_id
2324: ap_invoice_distributions_all.project_id%TYPE;
2325: ln_dist_task_id
2326: ap_invoice_distributions_all.task_id%TYPE;

Line 2324: ap_invoice_distributions_all.project_id%TYPE;

2320: ap_invoice_distributions_all.assets_addition_flag%TYPE;
2321: ln_dist_asst_trck_flag
2322: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
2323: ln_dist_project_id
2324: ap_invoice_distributions_all.project_id%TYPE;
2325: ln_dist_task_id
2326: ap_invoice_distributions_all.task_id%TYPE;
2327: ln_dist_exp_type
2328: ap_invoice_distributions_all.expenditure_type%TYPE;

Line 2326: ap_invoice_distributions_all.task_id%TYPE;

2322: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
2323: ln_dist_project_id
2324: ap_invoice_distributions_all.project_id%TYPE;
2325: ln_dist_task_id
2326: ap_invoice_distributions_all.task_id%TYPE;
2327: ln_dist_exp_type
2328: ap_invoice_distributions_all.expenditure_type%TYPE;
2329: ld_dist_exp_item_date
2330: ap_invoice_distributions_all.expenditure_item_date%TYPE;

Line 2328: ap_invoice_distributions_all.expenditure_type%TYPE;

2324: ap_invoice_distributions_all.project_id%TYPE;
2325: ln_dist_task_id
2326: ap_invoice_distributions_all.task_id%TYPE;
2327: ln_dist_exp_type
2328: ap_invoice_distributions_all.expenditure_type%TYPE;
2329: ld_dist_exp_item_date
2330: ap_invoice_distributions_all.expenditure_item_date%TYPE;
2331: ln_dist_exp_org_id
2332: ap_invoice_distributions_all.expenditure_organization_id%TYPE;

Line 2330: ap_invoice_distributions_all.expenditure_item_date%TYPE;

2326: ap_invoice_distributions_all.task_id%TYPE;
2327: ln_dist_exp_type
2328: ap_invoice_distributions_all.expenditure_type%TYPE;
2329: ld_dist_exp_item_date
2330: ap_invoice_distributions_all.expenditure_item_date%TYPE;
2331: ln_dist_exp_org_id
2332: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
2333: ln_dist_pa_context
2334: ap_invoice_distributions_all.project_accounting_context%TYPE;

Line 2332: ap_invoice_distributions_all.expenditure_organization_id%TYPE;

2328: ap_invoice_distributions_all.expenditure_type%TYPE;
2329: ld_dist_exp_item_date
2330: ap_invoice_distributions_all.expenditure_item_date%TYPE;
2331: ln_dist_exp_org_id
2332: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
2333: ln_dist_pa_context
2334: ap_invoice_distributions_all.project_accounting_context%TYPE;
2335: ln_dist_pa_addition_flag
2336: ap_invoice_distributions_all.pa_addition_flag%TYPE;

Line 2334: ap_invoice_distributions_all.project_accounting_context%TYPE;

2330: ap_invoice_distributions_all.expenditure_item_date%TYPE;
2331: ln_dist_exp_org_id
2332: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
2333: ln_dist_pa_context
2334: ap_invoice_distributions_all.project_accounting_context%TYPE;
2335: ln_dist_pa_addition_flag
2336: ap_invoice_distributions_all.pa_addition_flag%TYPE;
2337: lv_asset_book_type_code
2338: ap_invoice_distributions_all.asset_book_type_code%TYPE;

Line 2336: ap_invoice_distributions_all.pa_addition_flag%TYPE;

2332: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
2333: ln_dist_pa_context
2334: ap_invoice_distributions_all.project_accounting_context%TYPE;
2335: ln_dist_pa_addition_flag
2336: ap_invoice_distributions_all.pa_addition_flag%TYPE;
2337: lv_asset_book_type_code
2338: ap_invoice_distributions_all.asset_book_type_code%TYPE;
2339: ln_asset_category_id
2340: ap_invoice_distributions_all.asset_category_id%TYPE;

Line 2338: ap_invoice_distributions_all.asset_book_type_code%TYPE;

2334: ap_invoice_distributions_all.project_accounting_context%TYPE;
2335: ln_dist_pa_addition_flag
2336: ap_invoice_distributions_all.pa_addition_flag%TYPE;
2337: lv_asset_book_type_code
2338: ap_invoice_distributions_all.asset_book_type_code%TYPE;
2339: ln_asset_category_id
2340: ap_invoice_distributions_all.asset_category_id%TYPE;
2341: jai_ap_invoice_lines_rec jai_ap_invoice_lines%ROWTYPE;
2342: ap_invoice_lines_all_rec ap_invoice_lines_all%ROWTYPE;

Line 2340: ap_invoice_distributions_all.asset_category_id%TYPE;

2336: ap_invoice_distributions_all.pa_addition_flag%TYPE;
2337: lv_asset_book_type_code
2338: ap_invoice_distributions_all.asset_book_type_code%TYPE;
2339: ln_asset_category_id
2340: ap_invoice_distributions_all.asset_category_id%TYPE;
2341: jai_ap_invoice_lines_rec jai_ap_invoice_lines%ROWTYPE;
2342: ap_invoice_lines_all_rec ap_invoice_lines_all%ROWTYPE;
2343: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
2344: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

Line 2343: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;

2339: ln_asset_category_id
2340: ap_invoice_distributions_all.asset_category_id%TYPE;
2341: jai_ap_invoice_lines_rec jai_ap_invoice_lines%ROWTYPE;
2342: ap_invoice_lines_all_rec ap_invoice_lines_all%ROWTYPE;
2343: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
2344: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
2345: ln_proc_level NUMBER := FND_LOG.level_procedure;
2346: lv_proc_name VARCHAR2 (100):= 'Populate_ST_RVRS_Dist';
2347: ln_user_id NUMBER := fnd_global.user_id;

Line 2400: from ap_invoice_distributions_all where invoice_id = pn_invoice_id

2396: , pn_cr_percentage =>tax_rec.mod_cr_percentage
2397: );
2398:
2399: select min(distribution_line_number) into ln_distribution_line_number
2400: from ap_invoice_distributions_all where invoice_id = pn_invoice_id
2401: and invoice_line_number = ap_invoice_lines_rec.line_number;
2402:
2403: --get mandantory parameters from item line
2404: --the acct distribution will be handled in other procedure

Line 2565: ap_invoice_distributions_s.NEXTVAL

2561: , pv_ac_type => GV_REVERSE_CHARGE
2562: );
2563:
2564: SELECT
2565: ap_invoice_distributions_s.NEXTVAL
2566: INTO
2567: ln_inv_dist_id
2568: FROM DUAL;
2569:

Line 2571: FROM ap_invoice_distributions_all

2567: ln_inv_dist_id
2568: FROM DUAL;
2569:
2570: select invoice_distribution_id into lv_invoice_distribution_id
2571: FROM ap_invoice_distributions_all
2572: WHERE invoice_id = pn_invoice_id
2573: AND invoice_line_number = pn_line_number
2574: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all
2575: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ;

Line 2574: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all

2570: select invoice_distribution_id into lv_invoice_distribution_id
2571: FROM ap_invoice_distributions_all
2572: WHERE invoice_id = pn_invoice_id
2573: AND invoice_line_number = pn_line_number
2574: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all
2575: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ;
2576:
2577:
2578: IF ( ln_dist_asst_trck_flag = 'N') THEN

Line 2595: FROM ap_invoice_distributions aid

2591:
2592:
2593: SELECT count(*)
2594: INTO l_null_event_id
2595: FROM ap_invoice_distributions aid
2596: WHERE aid.invoice_id = ln_invoice_id
2597: AND aid.accounting_event_id is NULL;
2598:
2599: if l_null_event_id>0 then

Line 2624: , 'ln_inv_dist_id:'||ln_inv_dist_id||'ln_dist_acct_ccid:'||ln_dist_acct_ccid||'Table ap_invoice_distributions_all inserted '

2620: THEN
2621: FND_LOG.STRING ( ln_proc_level
2622: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2623: || '.debug Info.'
2624: , 'ln_inv_dist_id:'||ln_inv_dist_id||'ln_dist_acct_ccid:'||ln_dist_acct_ccid||'Table ap_invoice_distributions_all inserted '
2625: );
2626: END IF;
2627:
2628: ap_invoice_dist_all_rec := NULL;

Line 2730: from ap_invoice_distributions_all where invoice_id = pn_invoice_id

2726: , pn_cr_percentage =>tax_rec.mod_cr_percentage
2727: );
2728:
2729: select min(distribution_line_number) into ln_distribution_line_number
2730: from ap_invoice_distributions_all where invoice_id = pn_invoice_id
2731: and invoice_line_number = ap_invoice_lines_rec.line_number;
2732:
2733: --get mandantory parameters from item line
2734: --the acct distribution will be handled in other procedure

Line 2892: ap_invoice_distributions_s.NEXTVAL

2888: , pv_ac_type => GV_INTERIM_LIABILITY
2889: );
2890:
2891: SELECT
2892: ap_invoice_distributions_s.NEXTVAL
2893: INTO
2894: ln_inv_dist_id
2895: FROM DUAL;
2896: select invoice_distribution_id into lv_invoice_distribution_id

Line 2897: FROM ap_invoice_distributions_all

2893: INTO
2894: ln_inv_dist_id
2895: FROM DUAL;
2896: select invoice_distribution_id into lv_invoice_distribution_id
2897: FROM ap_invoice_distributions_all
2898: WHERE invoice_id = pn_invoice_id
2899: AND invoice_line_number = pn_line_number
2900: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all
2901: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ;

Line 2900: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all

2896: select invoice_distribution_id into lv_invoice_distribution_id
2897: FROM ap_invoice_distributions_all
2898: WHERE invoice_id = pn_invoice_id
2899: AND invoice_line_number = pn_line_number
2900: AND distribution_line_number =(select min(distribution_line_number) from ap_invoice_distributions_all
2901: where invoice_id = pn_invoice_id AND invoice_line_number = pn_line_number) ;
2902: -- IF (ap_invoice_dist_rec.assets_tracking_flag = 'N')
2903: IF ( ln_dist_asst_trck_flag = 'N')
2904: THEN

Line 2913: FROM ap_invoice_distributions aid

2909: END IF;
2910:
2911: SELECT count(*)
2912: INTO l_null_event_id
2913: FROM ap_invoice_distributions aid
2914: WHERE aid.invoice_id = ln_invoice_id
2915: AND aid.accounting_event_id is NULL;
2916:
2917: if l_null_event_id>0

Line 3143: ap_invoice_distributions_all apd,

3139: api.last_update_date,
3140: api.last_updated_by,
3141: api.invoice_date
3142: FROM ap_invoices_all api,
3143: ap_invoice_distributions_all apd,
3144: po_distributions_all pod,
3145: po_headers_all poh
3146: WHERE apd.invoice_id = api.invoice_id
3147: AND pod.po_header_id = poh.po_header_id

Line 3154: ( cpn_invoice_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID%TYPE

3150: AND api.invoice_id = inv_id
3151: AND apd.distribution_line_number = cpn_min_dist_line_no;
3152: -- Added by Brathod to get minimum invoice line number from invoice distributions, Bug#4445989
3153: CURSOR cur_get_min_dist_linenum
3154: ( cpn_invoice_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID%TYPE
3155: ,cpn_invoice_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE
3156: )
3157: IS
3158: SELECT min(distribution_line_number)

Line 3155: ,cpn_invoice_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE

3151: AND apd.distribution_line_number = cpn_min_dist_line_no;
3152: -- Added by Brathod to get minimum invoice line number from invoice distributions, Bug#4445989
3153: CURSOR cur_get_min_dist_linenum
3154: ( cpn_invoice_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID%TYPE
3155: ,cpn_invoice_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE
3156: )
3157: IS
3158: SELECT min(distribution_line_number)
3159: FROM ap_invoice_distributions_all apid

Line 3159: FROM ap_invoice_distributions_all apid

3155: ,cpn_invoice_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE
3156: )
3157: IS
3158: SELECT min(distribution_line_number)
3159: FROM ap_invoice_distributions_all apid
3160: WHERE apid.invoice_id = cpn_invoice_id
3161: AND apid.invoice_line_number = cpn_invoice_line_number;
3162:
3163:

Line 3236: FROM ap_invoice_distributions_all a,

3232: ,project_accounting_context
3233: ,pa_addition_flag
3234: /* End 5763527 */
3235: ,a.dist_match_type --Added by nprashar for bug # 12832424
3236: FROM ap_invoice_distributions_all a,
3237: ap_invoice_lines_all b
3238: WHERE a.invoice_id = cp_invoice_id
3239: AND a.invoice_line_number = cp_line_num
3240: AND b.invoice_id = cp_invoice_id

Line 3399: FROM ap_invoice_distributions_all a

3395: ,project_accounting_context
3396: ,pa_addition_flag
3397: /* End 5763527 */
3398: , dist_match_type --Added by nprashar for bug # 12832424
3399: FROM ap_invoice_distributions_all a
3400: WHERE invoice_id = cpn_invoice_id
3401: AND invoice_line_number = cpn_inv_line_num
3402: AND distribution_line_number = cpn_min_dist_line_num;
3403:

Line 3539: select ap_invoice_distributions_s.nextval

3535:
3536:
3537: -- Start add for bug#3632810
3538: CURSOR c_get_invoice_distribution is -- bug#3332988
3539: select ap_invoice_distributions_s.nextval
3540: from dual;
3541:
3542: -- start addition by ssumaith -bug# 3127834
3543:

Line 3591: v_price_var_accnt ap_invoice_distributions_all.price_var_code_combination_id%type;

3587: get_ven_info_rec get_ven_info%ROWTYPE;
3588: chk_for_pcking_slip_rec checking_for_packing_slip%ROWTYPE;
3589: v_tax_variance_inv_cur number; -- bug # 2775043
3590: v_tax_variance_fun_cur number; -- bug # 2775043
3591: v_price_var_accnt ap_invoice_distributions_all.price_var_code_combination_id%type;
3592: v_distribution_no ap_invoice_distributions_all.distribution_line_number%type;
3593: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
3594: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196
3595: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;

Line 3592: v_distribution_no ap_invoice_distributions_all.distribution_line_number%type;

3588: chk_for_pcking_slip_rec checking_for_packing_slip%ROWTYPE;
3589: v_tax_variance_inv_cur number; -- bug # 2775043
3590: v_tax_variance_fun_cur number; -- bug # 2775043
3591: v_price_var_accnt ap_invoice_distributions_all.price_var_code_combination_id%type;
3592: v_distribution_no ap_invoice_distributions_all.distribution_line_number%type;
3593: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
3594: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196
3595: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;
3596: v_update_payment_schedule boolean; -- bug#3218978

Line 3593: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;

3589: v_tax_variance_inv_cur number; -- bug # 2775043
3590: v_tax_variance_fun_cur number; -- bug # 2775043
3591: v_price_var_accnt ap_invoice_distributions_all.price_var_code_combination_id%type;
3592: v_distribution_no ap_invoice_distributions_all.distribution_line_number%type;
3593: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
3594: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196
3595: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;
3596: v_update_payment_schedule boolean; -- bug#3218978
3597: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988

Line 3594: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196

3590: v_tax_variance_fun_cur number; -- bug # 2775043
3591: v_price_var_accnt ap_invoice_distributions_all.price_var_code_combination_id%type;
3592: v_distribution_no ap_invoice_distributions_all.distribution_line_number%type;
3593: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
3594: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196
3595: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;
3596: v_update_payment_schedule boolean; -- bug#3218978
3597: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
3598: v_functional_currency gl_sets_of_books.currency_code%type; -- bug#3354932

Line 3595: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;

3591: v_price_var_accnt ap_invoice_distributions_all.price_var_code_combination_id%type;
3592: v_distribution_no ap_invoice_distributions_all.distribution_line_number%type;
3593: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
3594: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196
3595: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;
3596: v_update_payment_schedule boolean; -- bug#3218978
3597: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
3598: v_functional_currency gl_sets_of_books.currency_code%type; -- bug#3354932
3599: v_batch_id NUMBER;

Line 3597: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988

3593: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
3594: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;--bug#367196
3595: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;
3596: v_update_payment_schedule boolean; -- bug#3218978
3597: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
3598: v_functional_currency gl_sets_of_books.currency_code%type; -- bug#3354932
3599: v_batch_id NUMBER;
3600: c_tax_rec c_tax%ROWTYPE;
3601: v_source VARCHAR2(25);

Line 3617: ln_project_id ap_invoice_distributions_all.project_id%TYPE;

3613: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
3614:
3615:
3616: /* 5763527 , Project costing Fwd porting*/
3617: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
3618: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
3619: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
3620: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
3621: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;

Line 3618: ln_task_id ap_invoice_distributions_all.task_id%TYPE;

3614:
3615:
3616: /* 5763527 , Project costing Fwd porting*/
3617: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
3618: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
3619: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
3620: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
3621: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
3622: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;

Line 3619: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;

3615:
3616: /* 5763527 , Project costing Fwd porting*/
3617: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
3618: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
3619: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
3620: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
3621: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
3622: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
3623: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;

Line 3620: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;

3616: /* 5763527 , Project costing Fwd porting*/
3617: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
3618: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
3619: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
3620: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
3621: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
3622: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
3623: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
3624:

Line 3621: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;

3617: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
3618: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
3619: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
3620: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
3621: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
3622: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
3623: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
3624:
3625: ln_lines_to_insert number;

Line 3622: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;

3618: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
3619: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
3620: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
3621: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
3622: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
3623: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
3624:
3625: ln_lines_to_insert number;
3626: ln_nrec_tax_amt number;

Line 3623: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;

3619: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
3620: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
3621: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
3622: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
3623: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
3624:
3625: ln_lines_to_insert number;
3626: ln_nrec_tax_amt number;
3627: ln_rec_tax_amt number;

Line 3638: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;

3634: lv_ap_line_to_inst_flag VARCHAR2(1);
3635: lv_tax_line_to_inst_flag VARCHAR2(1);
3636: ln_inclurec_tax_amt NUMBER;
3637: ap_invoice_lines_all_rec ap_invoice_lines_all%ROWTYPE;
3638: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
3639:
3640: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
3641: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type, --Added by Bgowrava for Bug#7503308
3642: cp_shipment_header_id JAI_RCV_TRANSACTIONS.shipment_header_id%type, --Added by Bgowrava for Bug#7503308

Line 3837: from ap_invoice_distributions_all

3833:
3834: -- get the corresponding base line amount in original invoice
3835: cursor c_check_orig_item_line(p_price_correct_inv_id number, p_po_distribution_id number) is
3836: select amount, invoice_distribution_id
3837: from ap_invoice_distributions_all
3838: WHERE invoice_id = p_price_correct_inv_id
3839: and po_distribution_id = p_po_distribution_id
3840: AND line_type_lookup_code = 'ITEM';
3841:

Line 4427: 'Before inserting into ap_invoice_distributions_all for distribution line no :'

4423: lv_pa_addition_flag := r_ap_dist.pa_addition_flag;
4424: END IF;
4425:
4426: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
4427: 'Before inserting into ap_invoice_distributions_all for distribution line no :'
4428: ||v_distribution_no );
4429:
4430: open c_get_invoice_distribution;
4431: fetch c_get_invoice_distribution into v_invoice_distribution_id;

Line 5039: 'Before inserting into ap_invoice_distributions_all for distribution line no :' || v_distribution_no);

5035: ap_invoice_lines_all_rec.reference_key2 := pn_invoice_line_number;
5036: Insert_ap_inv_line( ap_invoice_lines_all_rec);
5037:
5038: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
5039: 'Before inserting into ap_invoice_distributions_all for distribution line no :' || v_distribution_no);
5040:
5041: open c_get_invoice_distribution;
5042: fetch c_get_invoice_distribution into v_invoice_distribution_id;
5043: close c_get_invoice_distribution;

Line 5229: 'Before inserting liability line into ap_invoice_distributions_all for distribution line no :' || v_distribution_no);

5225: Insert_ap_inv_line( ap_invoice_lines_all_rec);
5226:
5227:
5228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
5229: 'Before inserting liability line into ap_invoice_distributions_all for distribution line no :' || v_distribution_no);
5230:
5231:
5232: open c_get_invoice_distribution;
5233: fetch c_get_invoice_distribution into v_invoice_distribution_id;

Line 5413: ap_invoice_distributions_all apd,

5409: api.last_update_date,
5410: api.last_updated_by,
5411: api.invoice_date
5412: FROM ap_invoices_all api,
5413: ap_invoice_distributions_all apd,
5414: po_distributions_all pod,
5415: po_headers_all poh
5416: WHERE api.invoice_id = inv_id
5417: AND api.invoice_id = apd.invoice_id

Line 5425: ( cpn_invoice_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID%TYPE

5421: AND apd.distribution_line_number = cpn_max_dist_line_num;
5422:
5423: -- Added by Brathod to get minimum invoice line number from invoice distributions, Bug#4445989
5424: CURSOR cur_get_min_dist_linenum
5425: ( cpn_invoice_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID%TYPE
5426: ,cpn_invoice_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE
5427: )
5428: IS
5429: SELECT min(distribution_line_number)

Line 5426: ,cpn_invoice_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE

5422:
5423: -- Added by Brathod to get minimum invoice line number from invoice distributions, Bug#4445989
5424: CURSOR cur_get_min_dist_linenum
5425: ( cpn_invoice_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_ID%TYPE
5426: ,cpn_invoice_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE
5427: )
5428: IS
5429: SELECT min(distribution_line_number)
5430: FROM ap_invoice_distributions_all apid

Line 5430: FROM ap_invoice_distributions_all apid

5426: ,cpn_invoice_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE
5427: )
5428: IS
5429: SELECT min(distribution_line_number)
5430: FROM ap_invoice_distributions_all apid
5431: WHERE apid.invoice_id = cpn_invoice_id
5432: AND apid.invoice_line_number = cpn_invoice_line_number;
5433:
5434: --> Cursor to fetch the maximum line_number for current invoice, Bug# 4445989

Line 5520: FROM ap_invoice_distributions_all a

5516: org_id -- Bug 4863208
5517: , project_accounting_context /* 5763527 */
5518: , pa_addition_flag /* 5763527 */
5519: , asset_book_type_code /* 8406404 */
5520: FROM ap_invoice_distributions_all a
5521: WHERE invoice_id = inv_id
5522: AND invoice_line_number = inv_line_num
5523: AND distribution_line_number = cpn_min_dist_line_num;
5524:

Line 5617: FROM ap_invoice_distributions_all

5613: ORDER BY tax_line_no; --pramasub FP end
5614:
5615: CURSOR c_dist_reversal_cnt(p_invoice_id IN NUMBER) IS
5616: SELECT 1
5617: FROM ap_invoice_distributions_all
5618: WHERE invoice_id = p_invoice_id
5619: AND reversal_flag = 'Y'
5620: AND rownum = 1; -- Added by avallabh for bug 4926094 on 03-Feb-2006
5621:

Line 5624: AP_INVOICE_DISTRIBUTIONS_ALL WHERE

5620: AND rownum = 1; -- Added by avallabh for bug 4926094 on 03-Feb-2006
5621:
5622: CURSOR count_dist_no(inv_id NUMBER) IS
5623: SELECT NVL(DISTRIBUTION_LINE_NUMBER,1) FROM
5624: AP_INVOICE_DISTRIBUTIONS_ALL WHERE
5625: INVOICE_ID = inv_id
5626: AND DISTRIBUTION_LINE_NUMBER =
5627: (SELECT MAX(DISTRIBUTION_LINE_NUMBER)
5628: FROM AP_INVOICE_DISTRIBUTIONS_ALL

Line 5628: FROM AP_INVOICE_DISTRIBUTIONS_ALL

5624: AP_INVOICE_DISTRIBUTIONS_ALL WHERE
5625: INVOICE_ID = inv_id
5626: AND DISTRIBUTION_LINE_NUMBER =
5627: (SELECT MAX(DISTRIBUTION_LINE_NUMBER)
5628: FROM AP_INVOICE_DISTRIBUTIONS_ALL
5629: WHERE INVOICE_ID = inv_id)
5630: FOR UPDATE OF DISTRIBUTION_LINE_NUMBER;
5631:
5632: cursor c_get_invoice_distribution is -- bug#3332988

Line 5633: select ap_invoice_distributions_s.nextval

5629: WHERE INVOICE_ID = inv_id)
5630: FOR UPDATE OF DISTRIBUTION_LINE_NUMBER;
5631:
5632: cursor c_get_invoice_distribution is -- bug#3332988
5633: select ap_invoice_distributions_s.nextval
5634: from dual;
5635:
5636: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
5637: select precision

Line 5686: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;

5682: v_sup_inv_type VARCHAR2(25);
5683: v_ship_num VARCHAR2(30); -- added pramasub FP
5684: get_ven_info_rec get_ven_info%ROWTYPE;
5685: chk_for_pcking_slip_rec checking_for_packing_slip%ROWTYPE;
5686: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
5687: v_update_payment_schedule boolean; -- bug#3206083
5688: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
5689: v_apportn_factor_for_item_line number;
5690: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;

Line 5688: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988

5684: get_ven_info_rec get_ven_info%ROWTYPE;
5685: chk_for_pcking_slip_rec checking_for_packing_slip%ROWTYPE;
5686: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
5687: v_update_payment_schedule boolean; -- bug#3206083
5688: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
5689: v_apportn_factor_for_item_line number;
5690: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
5691: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;
5692:

Line 5690: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;

5686: v_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
5687: v_update_payment_schedule boolean; -- bug#3206083
5688: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
5689: v_apportn_factor_for_item_line number;
5690: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
5691: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;
5692:
5693: -- Bug 5401111. Added by Lakshmi Gopalsami
5694: lv_account_type gl_code_combinations.account_type%TYPE;

Line 5691: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;

5687: v_update_payment_schedule boolean; -- bug#3206083
5688: v_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%type; -- bug#3332988
5689: v_apportn_factor_for_item_line number;
5690: v_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
5691: v_dist_ccid_liability ap_invoice_distributions_all.dist_code_combination_id%type;
5692:
5693: -- Bug 5401111. Added by Lakshmi Gopalsami
5694: lv_account_type gl_code_combinations.account_type%TYPE;
5695:

Line 5697: ln_project_id ap_invoice_distributions_all.project_id%TYPE;

5693: -- Bug 5401111. Added by Lakshmi Gopalsami
5694: lv_account_type gl_code_combinations.account_type%TYPE;
5695:
5696: /* 5763527 */
5697: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
5698: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
5699: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
5700: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
5701: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;

Line 5698: ln_task_id ap_invoice_distributions_all.task_id%TYPE;

5694: lv_account_type gl_code_combinations.account_type%TYPE;
5695:
5696: /* 5763527 */
5697: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
5698: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
5699: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
5700: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
5701: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
5702: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;

Line 5699: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;

5695:
5696: /* 5763527 */
5697: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
5698: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
5699: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
5700: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
5701: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
5702: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
5703: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;

Line 5700: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;

5696: /* 5763527 */
5697: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
5698: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
5699: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
5700: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
5701: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
5702: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
5703: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
5704:

Line 5701: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;

5697: ln_project_id ap_invoice_distributions_all.project_id%TYPE;
5698: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
5699: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
5700: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
5701: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
5702: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
5703: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
5704:
5705: ln_lines_to_insert number;

Line 5702: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;

5698: ln_task_id ap_invoice_distributions_all.task_id%TYPE;
5699: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
5700: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
5701: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
5702: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
5703: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
5704:
5705: ln_lines_to_insert number;
5706: ln_nrec_tax_amt number;

Line 5703: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;

5699: lv_exp_type ap_invoice_distributions_all.expenditure_type%TYPE;
5700: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE;
5701: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE;
5702: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE;
5703: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE;
5704:
5705: ln_lines_to_insert number;
5706: ln_nrec_tax_amt number;
5707: ln_rec_tax_amt number;

Line 5775: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;

5771: ln_base_amount number ; --Added by kunkumar for bug#5593895
5772: ln_tax_precision JAI_CMN_TAXES_ALL.rounding_factor%type;--Added by kunkumar for bug#5593895
5773: l_api_name CONSTANT VARCHAR2(50) := 'process_batch_record()';
5774: ap_invoice_lines_all_rec ap_invoice_lines_all%ROWTYPE;
5775: ap_invoice_dist_all_rec ap_invoice_distributions_all%ROWTYPE;
5776:
5777: FUNCTION update_payment_schedule (p_total_tax NUMBER) RETURN boolean IS -- bug # 3218978
5778:
5779: v_total_tax_in_payment number;

Line 6230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,'Before inserting into ap_invoice_distributions_all for Invoice distribution id:'|| v_invoice_distribution_id );

6226:
6227: open c_get_invoice_distribution;
6228: fetch c_get_invoice_distribution into v_invoice_distribution_id;
6229: close c_get_invoice_distribution;
6230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,'Before inserting into ap_invoice_distributions_all for Invoice distribution id:'|| v_invoice_distribution_id );
6231:
6232: ap_invoice_dist_all_rec := NULL;
6233: ap_invoice_dist_all_rec.accounting_date := rec_max_ap_lines_all.accounting_date;
6234: ap_invoice_dist_all_rec.accrual_posted_flag := 'N';

Line 6422: '@Before inserting liability line into ap_invoice_distributions_all for distribution no :' || v_invoice_distribution_id);

6418: open c_get_invoice_distribution;
6419: fetch c_get_invoice_distribution into v_invoice_distribution_id;
6420: close c_get_invoice_distribution;
6421: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
6422: '@Before inserting liability line into ap_invoice_distributions_all for distribution no :' || v_invoice_distribution_id);
6423:
6424: ap_invoice_dist_all_rec := NULL;
6425: ap_invoice_dist_all_rec.accounting_date := rec_max_ap_lines_all.accounting_date;
6426: ap_invoice_dist_all_rec.accrual_posted_flag := 'N';

Line 6760: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,'Before inserting into ap_invoice_distributions_all for Invoice distribution id:'|| v_invoice_distribution_id );

6756:
6757: open c_get_invoice_distribution;
6758: fetch c_get_invoice_distribution into v_invoice_distribution_id;
6759: close c_get_invoice_distribution;
6760: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,'Before inserting into ap_invoice_distributions_all for Invoice distribution id:'|| v_invoice_distribution_id );
6761:
6762: ap_invoice_dist_all_rec := NULL;
6763: ap_invoice_dist_all_rec.accounting_date := rec_max_ap_lines_all.accounting_date;
6764: ap_invoice_dist_all_rec.accrual_posted_flag := 'N';

Line 6954: '@Before inserting liability line into ap_invoice_distributions_all for distribution no :' || v_invoice_distribution_id);

6950: open c_get_invoice_distribution;
6951: fetch c_get_invoice_distribution into v_invoice_distribution_id;
6952: close c_get_invoice_distribution;
6953: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
6954: '@Before inserting liability line into ap_invoice_distributions_all for distribution no :' || v_invoice_distribution_id);
6955:
6956: ap_invoice_dist_all_rec := NULL;
6957: ap_invoice_dist_all_rec.accounting_date := rec_max_ap_lines_all.accounting_date;
6958: ap_invoice_dist_all_rec.accrual_posted_flag := 'N';