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 JAI_AP_INVOICE_LINES

Line 42: GV_JAI_AP_INVOICE_LINES VARCHAR2 (100) := 'JAI_AP_INVOICE_LINES';

38: GV_MODULE_PREFIX VARCHAR2 (100) := 'JAI.PLSQL.JAI_AP_ST_REVERSE_PROCESS';
39: GV_CONSTANT_MISCELLANEOUS VARCHAR2 (20) := 'MISCELLANEOUS';
40: GV_CONSTANT_ITEM VARCHAR2 (20) := 'ITEM';
41: GV_NOT_MATCH_TYPE VARCHAR2 (20) := 'NOT_MATCHED';
42: GV_JAI_AP_INVOICE_LINES VARCHAR2 (100) := 'JAI_AP_INVOICE_LINES';
43: GV_LINES_CREATEED VARCHAR2 (10) := 'NO';
44: GV_REVERSE_CHARGE VARCHAR2 (20) := 'REVERSE_CHARGE';
45: GV_INTERIM_LIABILITY VARCHAR2 (20) := 'INTERIM_LIABILITY';
46:

Line 938: p_jai_ap_invoice_lines_rec IN jai_ap_invoice_lines%ROWTYPE

934:
935:
936:
937: PROCEDURE Insert_jai_inv_line(
938: p_jai_ap_invoice_lines_rec IN jai_ap_invoice_lines%ROWTYPE
939: )IS
940: l_api_name CONSTANT VARCHAR2(50) := 'Insert_jai_inv_line()';
941: BEGIN
942: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, GV_MODULE_PREFIX || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');

Line 944: INSERT INTO jai_ap_invoice_lines

940: l_api_name CONSTANT VARCHAR2(50) := 'Insert_jai_inv_line()';
941: BEGIN
942: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, GV_MODULE_PREFIX || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
943:
944: INSERT INTO jai_ap_invoice_lines
945: (JAI_AP_INVOICE_LINES_ID
946: ,ORGANIZATION_ID
947: ,LOCATION_ID
948: ,INVOICE_ID

Line 945: (JAI_AP_INVOICE_LINES_ID

941: BEGIN
942: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, GV_MODULE_PREFIX || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
943:
944: INSERT INTO jai_ap_invoice_lines
945: (JAI_AP_INVOICE_LINES_ID
946: ,ORGANIZATION_ID
947: ,LOCATION_ID
948: ,INVOICE_ID
949: ,INVOICE_LINE_NUMBER

Line 965: (p_jai_ap_invoice_lines_rec.JAI_AP_INVOICE_LINES_ID

961: ,LAST_UPDATE_LOGIN
962: ,LAST_UPDATED_BY
963: )
964: VALUES
965: (p_jai_ap_invoice_lines_rec.JAI_AP_INVOICE_LINES_ID
966: ,p_jai_ap_invoice_lines_rec.ORGANIZATION_ID
967: ,p_jai_ap_invoice_lines_rec.LOCATION_ID
968: ,p_jai_ap_invoice_lines_rec.INVOICE_ID
969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER

Line 966: ,p_jai_ap_invoice_lines_rec.ORGANIZATION_ID

962: ,LAST_UPDATED_BY
963: )
964: VALUES
965: (p_jai_ap_invoice_lines_rec.JAI_AP_INVOICE_LINES_ID
966: ,p_jai_ap_invoice_lines_rec.ORGANIZATION_ID
967: ,p_jai_ap_invoice_lines_rec.LOCATION_ID
968: ,p_jai_ap_invoice_lines_rec.INVOICE_ID
969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER
970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID

Line 967: ,p_jai_ap_invoice_lines_rec.LOCATION_ID

963: )
964: VALUES
965: (p_jai_ap_invoice_lines_rec.JAI_AP_INVOICE_LINES_ID
966: ,p_jai_ap_invoice_lines_rec.ORGANIZATION_ID
967: ,p_jai_ap_invoice_lines_rec.LOCATION_ID
968: ,p_jai_ap_invoice_lines_rec.INVOICE_ID
969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER
970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID
971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER

Line 968: ,p_jai_ap_invoice_lines_rec.INVOICE_ID

964: VALUES
965: (p_jai_ap_invoice_lines_rec.JAI_AP_INVOICE_LINES_ID
966: ,p_jai_ap_invoice_lines_rec.ORGANIZATION_ID
967: ,p_jai_ap_invoice_lines_rec.LOCATION_ID
968: ,p_jai_ap_invoice_lines_rec.INVOICE_ID
969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER
970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID
971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER
972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID

Line 969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER

965: (p_jai_ap_invoice_lines_rec.JAI_AP_INVOICE_LINES_ID
966: ,p_jai_ap_invoice_lines_rec.ORGANIZATION_ID
967: ,p_jai_ap_invoice_lines_rec.LOCATION_ID
968: ,p_jai_ap_invoice_lines_rec.INVOICE_ID
969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER
970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID
971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER
972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID
973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE

Line 970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID

966: ,p_jai_ap_invoice_lines_rec.ORGANIZATION_ID
967: ,p_jai_ap_invoice_lines_rec.LOCATION_ID
968: ,p_jai_ap_invoice_lines_rec.INVOICE_ID
969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER
970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID
971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER
972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID
973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE
974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE

Line 971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER

967: ,p_jai_ap_invoice_lines_rec.LOCATION_ID
968: ,p_jai_ap_invoice_lines_rec.INVOICE_ID
969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER
970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID
971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER
972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID
973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE
974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE
975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE

Line 972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID

968: ,p_jai_ap_invoice_lines_rec.INVOICE_ID
969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER
970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID
971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER
972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID
973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE
974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE
975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE
976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT

Line 973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE

969: ,p_jai_ap_invoice_lines_rec.INVOICE_LINE_NUMBER
970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID
971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER
972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID
973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE
974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE
975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE
976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT
977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE

Line 974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE

970: ,p_jai_ap_invoice_lines_rec.SUPPLIER_SITE_ID
971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER
972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID
973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE
974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE
975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE
976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT
977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE
978: ,p_jai_ap_invoice_lines_rec.CREATED_BY

Line 975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE

971: ,p_jai_ap_invoice_lines_rec.PARENT_INVOICE_LINE_NUMBER
972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID
973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE
974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE
975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE
976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT
977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE
978: ,p_jai_ap_invoice_lines_rec.CREATED_BY
979: ,p_jai_ap_invoice_lines_rec.CREATION_DATE

Line 976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT

972: ,p_jai_ap_invoice_lines_rec.TAX_CATEGORY_ID
973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE
974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE
975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE
976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT
977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE
978: ,p_jai_ap_invoice_lines_rec.CREATED_BY
979: ,p_jai_ap_invoice_lines_rec.CREATION_DATE
980: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_DATE

Line 977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE

973: ,p_jai_ap_invoice_lines_rec.SERVICE_TYPE_CODE
974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE
975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE
976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT
977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE
978: ,p_jai_ap_invoice_lines_rec.CREATED_BY
979: ,p_jai_ap_invoice_lines_rec.CREATION_DATE
980: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_DATE
981: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_LOGIN

Line 978: ,p_jai_ap_invoice_lines_rec.CREATED_BY

974: ,p_jai_ap_invoice_lines_rec.MATCH_TYPE
975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE
976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT
977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE
978: ,p_jai_ap_invoice_lines_rec.CREATED_BY
979: ,p_jai_ap_invoice_lines_rec.CREATION_DATE
980: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_DATE
981: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_LOGIN
982: ,p_jai_ap_invoice_lines_rec.LAST_UPDATED_BY

Line 979: ,p_jai_ap_invoice_lines_rec.CREATION_DATE

975: ,p_jai_ap_invoice_lines_rec.CURRENCY_CODE
976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT
977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE
978: ,p_jai_ap_invoice_lines_rec.CREATED_BY
979: ,p_jai_ap_invoice_lines_rec.CREATION_DATE
980: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_DATE
981: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_LOGIN
982: ,p_jai_ap_invoice_lines_rec.LAST_UPDATED_BY
983: );

Line 980: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_DATE

976: ,p_jai_ap_invoice_lines_rec.LINE_AMOUNT
977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE
978: ,p_jai_ap_invoice_lines_rec.CREATED_BY
979: ,p_jai_ap_invoice_lines_rec.CREATION_DATE
980: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_DATE
981: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_LOGIN
982: ,p_jai_ap_invoice_lines_rec.LAST_UPDATED_BY
983: );
984:

Line 981: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_LOGIN

977: ,p_jai_ap_invoice_lines_rec.LINE_TYPE_LOOKUP_CODE
978: ,p_jai_ap_invoice_lines_rec.CREATED_BY
979: ,p_jai_ap_invoice_lines_rec.CREATION_DATE
980: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_DATE
981: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_LOGIN
982: ,p_jai_ap_invoice_lines_rec.LAST_UPDATED_BY
983: );
984:
985: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, GV_MODULE_PREFIX || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');

Line 982: ,p_jai_ap_invoice_lines_rec.LAST_UPDATED_BY

978: ,p_jai_ap_invoice_lines_rec.CREATED_BY
979: ,p_jai_ap_invoice_lines_rec.CREATION_DATE
980: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_DATE
981: ,p_jai_ap_invoice_lines_rec.LAST_UPDATE_LOGIN
982: ,p_jai_ap_invoice_lines_rec.LAST_UPDATED_BY
983: );
984:
985: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, GV_MODULE_PREFIX || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
986: EXCEPTION

Line 2073: WHERE jcdt.source_table_name = 'JAI_AP_INVOICE_LINES'

2069: ---------------------------------------------------------------------------------
2070: AND NOT EXISTS(
2071: SELECT 1
2072: FROM ap_invoices_all aia_in
2073: WHERE jcdt.source_table_name = 'JAI_AP_INVOICE_LINES'
2074: AND jcdt.source_doc_id = aia_in.invoice_id
2075: AND aia_in.invoice_type_lookup_code in ('CREDIT' ,'DEBIT')
2076: )
2077: ---------------------------------------------------------------------------------

Line 2139: WHERE jcdt.source_table_name = 'JAI_AP_INVOICE_LINES'

2135: ---------------------------------------------------------------------------------
2136: AND NOT EXISTS(
2137: SELECT 1
2138: FROM ap_invoices_all aia_in
2139: WHERE jcdt.source_table_name = 'JAI_AP_INVOICE_LINES'
2140: AND jcdt.source_doc_id = aia_in.invoice_id
2141: AND aia_in.invoice_type_lookup_code in ('CREDIT' ,'DEBIT')
2142: )
2143: ---------------------------------------------------------------------------------

Line 2272: FROM jai_ap_invoice_lines

2268: AND distribution_line_number = pn_distribution_line_number; /*1; Bug 13617527 */
2269:
2270: Cursor get_service_type(p_invoice_id NUMBER,p_invoice_line_number NUMBER) IS
2271: SELECT service_type_code,organization_id, location_id
2272: FROM jai_ap_invoice_lines
2273: WHERE invoice_id = p_invoice_id
2274: AND invoice_line_number = p_invoice_line_number;
2275:
2276: lv_organization_id jai_ap_invoice_lines.ORGANIZATION_ID%type;

Line 2276: lv_organization_id jai_ap_invoice_lines.ORGANIZATION_ID%type;

2272: FROM jai_ap_invoice_lines
2273: WHERE invoice_id = p_invoice_id
2274: AND invoice_line_number = p_invoice_line_number;
2275:
2276: lv_organization_id jai_ap_invoice_lines.ORGANIZATION_ID%type;
2277: lv_location_id jai_ap_invoice_lines.LOCATION_ID%type;
2278:
2279: ap_invoice_dist_rec ap_invoice_dist_cur%ROWTYPE;
2280: tax_rec get_tax_cur%ROWTYPE;

Line 2277: lv_location_id jai_ap_invoice_lines.LOCATION_ID%type;

2273: WHERE invoice_id = p_invoice_id
2274: AND invoice_line_number = p_invoice_line_number;
2275:
2276: lv_organization_id jai_ap_invoice_lines.ORGANIZATION_ID%type;
2277: lv_location_id jai_ap_invoice_lines.LOCATION_ID%type;
2278:
2279: ap_invoice_dist_rec ap_invoice_dist_cur%ROWTYPE;
2280: tax_rec get_tax_cur%ROWTYPE;
2281: ln_inv_dist_id NUMBER;

Line 2300: cursor c_exists_jai_ap_invoice_lines (p_invoice_id number, p_invoice_line_number number) is

2296: ln_task_id ap_invoice_lines_all.task_id%TYPE;
2297: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
2298: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
2299: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
2300: cursor c_exists_jai_ap_invoice_lines (p_invoice_id number, p_invoice_line_number number) is
2301: select count(*)
2302: from jai_ap_invoice_lines
2303: where invoice_id=p_invoice_id
2304: and invoice_line_number=p_invoice_line_number;

Line 2302: from jai_ap_invoice_lines

2298: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
2299: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
2300: cursor c_exists_jai_ap_invoice_lines (p_invoice_id number, p_invoice_line_number number) is
2301: select count(*)
2302: from jai_ap_invoice_lines
2303: where invoice_id=p_invoice_id
2304: and invoice_line_number=p_invoice_line_number;
2305:
2306: cursor c_exists_ap_invoice_lines (p_invoice_id number, p_invoice_line_number number) is

Line 2341: jai_ap_invoice_lines_rec jai_ap_invoice_lines%ROWTYPE;

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;
2345: ln_proc_level NUMBER := FND_LOG.level_procedure;

Line 2456: SELECT jai_ap_invoice_lines_s.NEXTVAL

2452:
2453:
2454: IF (NVL(jai_doc_taxes_rec.inc_tax_flag,'N')='N') THEN
2455:
2456: SELECT jai_ap_invoice_lines_s.NEXTVAL
2457: INTO ln_jai_inv_line_id FROM DUAL;
2458:
2459: lv_service_type_code_tmp := null;
2460: OPEN get_service_type (ln_invoice_id, ap_invoice_lines_rec.line_number);

Line 2466: open c_exists_jai_ap_invoice_lines(jai_doc_taxes_rec.source_doc_id,jai_doc_taxes_rec.source_doc_line_id);

2462: CLOSE get_service_type;
2463:
2464: lv_service_type_code := nvl(lv_service_type_code, lv_service_type_code_tmp);
2465:
2466: open c_exists_jai_ap_invoice_lines(jai_doc_taxes_rec.source_doc_id,jai_doc_taxes_rec.source_doc_line_id);
2467: fetch c_exists_jai_ap_invoice_lines into ln_exists;
2468: close c_exists_jai_ap_invoice_lines;
2469:
2470: if (ln_exists =0) then

Line 2467: fetch c_exists_jai_ap_invoice_lines into ln_exists;

2463:
2464: lv_service_type_code := nvl(lv_service_type_code, lv_service_type_code_tmp);
2465:
2466: open c_exists_jai_ap_invoice_lines(jai_doc_taxes_rec.source_doc_id,jai_doc_taxes_rec.source_doc_line_id);
2467: fetch c_exists_jai_ap_invoice_lines into ln_exists;
2468: close c_exists_jai_ap_invoice_lines;
2469:
2470: if (ln_exists =0) then
2471: jai_ap_invoice_lines_rec := NULL;

Line 2468: close c_exists_jai_ap_invoice_lines;

2464: lv_service_type_code := nvl(lv_service_type_code, lv_service_type_code_tmp);
2465:
2466: open c_exists_jai_ap_invoice_lines(jai_doc_taxes_rec.source_doc_id,jai_doc_taxes_rec.source_doc_line_id);
2467: fetch c_exists_jai_ap_invoice_lines into ln_exists;
2468: close c_exists_jai_ap_invoice_lines;
2469:
2470: if (ln_exists =0) then
2471: jai_ap_invoice_lines_rec := NULL;
2472: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;

Line 2471: jai_ap_invoice_lines_rec := NULL;

2467: fetch c_exists_jai_ap_invoice_lines into ln_exists;
2468: close c_exists_jai_ap_invoice_lines;
2469:
2470: if (ln_exists =0) then
2471: jai_ap_invoice_lines_rec := NULL;
2472: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2473: jai_ap_invoice_lines_rec.organization_id := lv_organization_id ;
2474: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;

Line 2472: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;

2468: close c_exists_jai_ap_invoice_lines;
2469:
2470: if (ln_exists =0) then
2471: jai_ap_invoice_lines_rec := NULL;
2472: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2473: jai_ap_invoice_lines_rec.organization_id := lv_organization_id ;
2474: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;

Line 2473: jai_ap_invoice_lines_rec.organization_id := lv_organization_id ;

2469:
2470: if (ln_exists =0) then
2471: jai_ap_invoice_lines_rec := NULL;
2472: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2473: jai_ap_invoice_lines_rec.organization_id := lv_organization_id ;
2474: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;
2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;

Line 2474: jai_ap_invoice_lines_rec.location_id := lv_location_id;

2470: if (ln_exists =0) then
2471: jai_ap_invoice_lines_rec := NULL;
2472: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2473: jai_ap_invoice_lines_rec.organization_id := lv_organization_id ;
2474: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;
2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;

Line 2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;

2471: jai_ap_invoice_lines_rec := NULL;
2472: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2473: jai_ap_invoice_lines_rec.organization_id := lv_organization_id ;
2474: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;
2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;

Line 2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;

2472: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2473: jai_ap_invoice_lines_rec.organization_id := lv_organization_id ;
2474: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;
2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;

Line 2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;

2473: jai_ap_invoice_lines_rec.organization_id := lv_organization_id ;
2474: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;
2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;

Line 2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;

2474: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;
2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;

Line 2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;

2475: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;
2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;

Line 2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;

2476: jai_ap_invoice_lines_rec.invoice_line_number := jai_doc_taxes_rec.source_doc_line_id;
2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;
2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;

Line 2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;

2477: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;
2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;

Line 2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;

2478: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;
2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;

Line 2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;

2479: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;
2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2487: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;

Line 2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;

2480: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;
2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2487: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2488: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;

Line 2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;

2481: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;
2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2487: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2488: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2489: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;

Line 2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;

2482: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;
2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2487: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2488: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2489: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2490: Insert_jai_inv_line(jai_ap_invoice_lines_rec);

Line 2487: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;

2483: jai_ap_invoice_lines_rec.line_amount := jai_doc_taxes_rec.tax_amt;
2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2487: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2488: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2489: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2490: Insert_jai_inv_line(jai_ap_invoice_lines_rec);
2491:

Line 2488: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;

2484: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2487: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2488: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2489: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2490: Insert_jai_inv_line(jai_ap_invoice_lines_rec);
2491:
2492: --log for debug

Line 2489: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;

2485: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2487: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2488: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2489: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2490: Insert_jai_inv_line(jai_ap_invoice_lines_rec);
2491:
2492: --log for debug
2493: IF ( ln_proc_level >= ln_dbg_level)

Line 2490: Insert_jai_inv_line(jai_ap_invoice_lines_rec);

2486: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2487: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2488: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2489: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2490: Insert_jai_inv_line(jai_ap_invoice_lines_rec);
2491:
2492: --log for debug
2493: IF ( ln_proc_level >= ln_dbg_level)
2494: THEN

Line 2498: , 'Table jai_ap_invoice_lines inserted '

2494: THEN
2495: FND_LOG.STRING ( ln_proc_level
2496: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2497: || '.debug Info.'
2498: , 'Table jai_ap_invoice_lines inserted '
2499: );
2500: END IF; --( ln_proc_level >= ln_dbg_level )
2501: end if;
2502: --insert into ap_invoice_lines_all

Line 2792: jai_ap_invoice_lines_s.NEXTVAL

2788:
2789: ln_max_pro_line_num := ln_max_pro_line_num + 1;
2790:
2791: SELECT
2792: jai_ap_invoice_lines_s.NEXTVAL
2793: INTO
2794: ln_jai_inv_line_id
2795: FROM DUAL;
2796:

Line 2803: --insert into jai_ap_invoice_lines

2799: FETCH get_service_type INTO lv_service_type_code_tmp, lv_organization_id,lv_location_id ;
2800: CLOSE get_service_type;
2801: lv_service_type_code := nvl(lv_service_type_code, lv_service_type_code_tmp);
2802:
2803: --insert into jai_ap_invoice_lines
2804: jai_ap_invoice_lines_rec := NULL;
2805: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2806: jai_ap_invoice_lines_rec.organization_id := lv_organization_id;
2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;

Line 2804: jai_ap_invoice_lines_rec := NULL;

2800: CLOSE get_service_type;
2801: lv_service_type_code := nvl(lv_service_type_code, lv_service_type_code_tmp);
2802:
2803: --insert into jai_ap_invoice_lines
2804: jai_ap_invoice_lines_rec := NULL;
2805: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2806: jai_ap_invoice_lines_rec.organization_id := lv_organization_id;
2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;

Line 2805: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;

2801: lv_service_type_code := nvl(lv_service_type_code, lv_service_type_code_tmp);
2802:
2803: --insert into jai_ap_invoice_lines
2804: jai_ap_invoice_lines_rec := NULL;
2805: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2806: jai_ap_invoice_lines_rec.organization_id := lv_organization_id;
2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;

Line 2806: jai_ap_invoice_lines_rec.organization_id := lv_organization_id;

2802:
2803: --insert into jai_ap_invoice_lines
2804: jai_ap_invoice_lines_rec := NULL;
2805: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2806: jai_ap_invoice_lines_rec.organization_id := lv_organization_id;
2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;
2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;

Line 2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;

2803: --insert into jai_ap_invoice_lines
2804: jai_ap_invoice_lines_rec := NULL;
2805: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2806: jai_ap_invoice_lines_rec.organization_id := lv_organization_id;
2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;
2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;

Line 2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;

2804: jai_ap_invoice_lines_rec := NULL;
2805: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2806: jai_ap_invoice_lines_rec.organization_id := lv_organization_id;
2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;
2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;

Line 2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;

2805: jai_ap_invoice_lines_rec.jai_ap_invoice_lines_id := ln_jai_inv_line_id;
2806: jai_ap_invoice_lines_rec.organization_id := lv_organization_id;
2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;
2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;

Line 2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;

2806: jai_ap_invoice_lines_rec.organization_id := lv_organization_id;
2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;
2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;

Line 2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;

2807: jai_ap_invoice_lines_rec.location_id := lv_location_id;
2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;
2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;

Line 2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;

2808: jai_ap_invoice_lines_rec.invoice_id := jai_doc_taxes_rec.source_doc_id;
2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;
2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line

Line 2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;

2809: jai_ap_invoice_lines_rec.invoice_line_number := ln_max_pro_line_num;
2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line
2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;

Line 2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;

2810: jai_ap_invoice_lines_rec.supplier_site_id := ln_vendor_site_id;
2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line
2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;

Line 2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;

2811: jai_ap_invoice_lines_rec.parent_invoice_line_number := jai_doc_taxes_rec.source_doc_parent_line_no;
2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line
2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;

Line 2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line

2812: jai_ap_invoice_lines_rec.tax_category_id := jai_doc_taxes_rec.tax_category_id;
2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line
2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2820: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;

Line 2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;

2813: jai_ap_invoice_lines_rec.service_type_code := lv_service_type_code;
2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line
2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2820: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2821: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;

Line 2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;

2814: jai_ap_invoice_lines_rec.match_type := ap_invoice_lines_rec.match_type;
2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line
2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2820: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2821: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2822: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;

Line 2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;

2815: jai_ap_invoice_lines_rec.currency_code := lv_currency_code;
2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line
2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2820: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2821: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2822: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2823: Insert_jai_inv_line(jai_ap_invoice_lines_rec);

Line 2820: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;

2816: jai_ap_invoice_lines_rec.line_amount := - jai_doc_taxes_rec.tax_amt; --negative amount for liability line
2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2820: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2821: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2822: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2823: Insert_jai_inv_line(jai_ap_invoice_lines_rec);
2824:

Line 2821: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;

2817: jai_ap_invoice_lines_rec.line_type_lookup_code := GV_CONSTANT_MISCELLANEOUS;
2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2820: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2821: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2822: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2823: Insert_jai_inv_line(jai_ap_invoice_lines_rec);
2824:
2825: --log for debug

Line 2822: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;

2818: jai_ap_invoice_lines_rec.created_by := ln_user_id;
2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2820: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2821: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2822: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2823: Insert_jai_inv_line(jai_ap_invoice_lines_rec);
2824:
2825: --log for debug
2826: IF ( ln_proc_level >= ln_dbg_level)

Line 2823: Insert_jai_inv_line(jai_ap_invoice_lines_rec);

2819: jai_ap_invoice_lines_rec.creation_date := SYSDATE;
2820: jai_ap_invoice_lines_rec.last_update_date := SYSDATE;
2821: jai_ap_invoice_lines_rec.last_update_login := ln_login_id;
2822: jai_ap_invoice_lines_rec.last_updated_by := ln_user_id;
2823: Insert_jai_inv_line(jai_ap_invoice_lines_rec);
2824:
2825: --log for debug
2826: IF ( ln_proc_level >= ln_dbg_level)
2827: THEN

Line 2831: , 'Table jai_ap_invoice_lines for liability line inserted '

2827: THEN
2828: FND_LOG.STRING ( ln_proc_level
2829: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2830: || '.debug Info.'
2831: , 'Table jai_ap_invoice_lines for liability line inserted '
2832: );
2833: END IF; --( ln_proc_level >= ln_dbg_level )
2834:
2835: --insert into ap_invoice_lines_all