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_AR_SUP_TRX_PKG dependencies on JAI_AR_SUP_HDRS_ALL

Line 18: Sequence JAI_AR_SUP_HDRS_ALL_S1 is used instead of JAI_AR_SUP_HDRS_ALL_S2 and JAI_AR_SUP_HDRS_ALL_S3

14: 13-Jun-2005 File Version: 116.4
15: Ramananda for bug#4428980. Removal of SQL LITERALs is done
16:
17: 18-JUL-2005 Ramananda for bug# 4499078, File Version # 120.2
18: Sequence JAI_AR_SUP_HDRS_ALL_S1 is used instead of JAI_AR_SUP_HDRS_ALL_S2 and JAI_AR_SUP_HDRS_ALL_S3
19:
20: 26-JUL-2005 Ramananda for bug#4499078, File Version # 120.3
21: Added column Interface_Line_Attribute2 column in Cursor GET_SUPP_INV_LINES
22:

Line 195: FROM JAI_AR_SUP_HDRS_ALL

191: -- CURSOR FOR CHECKING WHETHER AN INVOICE HAS AN EXISTING ENTRY --
192:
193: CURSOR CHK_FOR_SUPP_INV_ENT(ID NUMBER) IS
194: SELECT 1
195: FROM JAI_AR_SUP_HDRS_ALL
196: WHERE CUSTOMER_TRX_ID = ID ;
197:
198: -- CURSOR FOR SELECTING INVOICE FILTERED BY EFFECTIVE DATE AND TYPE --
199:

Line 613: FROM JAI_AR_SUP_HDRS_ALL

609: ORDER BY CUSTOMER_TRX_ID;
610:
611: CURSOR CHECK_FOR_INV(INV NUMBER) IS
612: SELECT customer_trx_id
613: FROM JAI_AR_SUP_HDRS_ALL
614: WHERE customer_trx_id = INV;
615:
616: CURSOR CHECK_SUPP_ASSESS_INV(STAT VARCHAR2,NO NUMBER) IS
617: SELECT 1

Line 618: FROM JAI_AR_SUP_HDRS_ALL

614: WHERE customer_trx_id = INV;
615:
616: CURSOR CHECK_SUPP_ASSESS_INV(STAT VARCHAR2,NO NUMBER) IS
617: SELECT 1
618: FROM JAI_AR_SUP_HDRS_ALL
619: WHERE customer_trx_id = NO
620: AND supp_inv_type = STAT;
621:
622: CURSOR get_inv_line( ino NUMBER,

Line 894: JAI_AR_SUP_HDRS_ALL.

890: of the table JAI_AR_SUP_LINES.
891:
892: 07-Jul-2007 Bgowrava for Bug#6139693, File Version 120.13
893: Added the NVL condition for the EXIST_NET_SALES_AMT fields in the update statements of
894: JAI_AR_SUP_HDRS_ALL.
895:
896: 12-Sep-2007 Bgowrava for bug#6400997, File Version 120.9.12000000.6
897: Added the columns SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS in the insert statements
898: and assigned values 'N' to both of them. This was done because the default values were

Line 936: -- CURSOR TO CHECK IF AN INVOICE HAS ENTRIES EXISTING IN THE JAI_AR_SUP_HDRS_ALL --

932: END IF;
933:
934: v_statement_id := '3';
935:
936: -- CURSOR TO CHECK IF AN INVOICE HAS ENTRIES EXISTING IN THE JAI_AR_SUP_HDRS_ALL --
937: OPEN CHECK_FOR_INV(FETCH_INV.CUSTOMER_TRX_ID);
938: FETCH CHECK_FOR_INV INTO INV_NO;
939:
940: IF CHECK_FOR_INV%NOTFOUND THEN -- 0000a1

Line 1164: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,

1160: FETCH CHECK_SUPP_ASSESS_INV INTO CHECK_ASSESS_INV ;
1161:
1162: IF CHECK_SUPP_ASSESS_INV%NOTFOUND THEN
1163: v_statement_id := '21';
1164: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1165: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE, LAST_UPDATE_DATE, CREATED_BY,
1166: CREATION_DATE, LAST_UPDATED_BY, EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT,
1167: SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1168: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

Line 1168: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

1164: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1165: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE, LAST_UPDATE_DATE, CREATED_BY,
1166: CREATION_DATE, LAST_UPDATED_BY, EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT,
1167: SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1168: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1169: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS, SYSDATE, fnd_global.user_id,
1170: SYSDATE, fnd_global.user_id, OAMOUNT, NAMOUNT,
1171: I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1172: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS

Line 1177: UPDATE JAI_AR_SUP_HDRS_ALL

1173:
1174: ELSE
1175: v_statement_id := '22';
1176:
1177: UPDATE JAI_AR_SUP_HDRS_ALL
1178: SET EXIST_NET_SALES_AMT = nvl(EXIST_NET_SALES_AMT,0)+OAMOUNT,
1179: NEW_NET_SALES_AMT = nvl(NEW_NET_SALES_AMT,0) +NAMOUNT
1180: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID
1181: AND SUPP_INV_TYPE = STATUS;

Line 1309: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,

1305: IF CHECK_SUPP_ASSESS_INV%NOTFOUND THEN
1306:
1307: v_statement_id := '37';
1308:
1309: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1310: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE,
1311: LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1312: EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT, SET_OF_BOOKS_ID,
1313: CUSTOMER_SITE, ORG_ID, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS

Line 1314: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

1310: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE,
1311: LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
1312: EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT, SET_OF_BOOKS_ID,
1313: CUSTOMER_SITE, ORG_ID, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1314: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1315: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1316: SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id,
1317: OLD_INVOICE_AMOUNT, NEW_INVOICE_AMOUNT, I.SET_OF_BOOKS_ID,
1318: I.BILL_TO_SITE_USE_ID, I.ORG_ID, FETCH_INV.BATCH_ID, 'N', 'N'

Line 1325: UPDATE JAI_AR_SUP_HDRS_ALL

1321: ELSIF CHECK_SUPP_ASSESS_INV%FOUND THEN
1322:
1323: v_statement_id := '38';
1324:
1325: UPDATE JAI_AR_SUP_HDRS_ALL
1326: SET EXIST_NET_SALES_AMT = nvl(EXIST_NET_SALES_AMT,0)+ OLD_INVOICE_AMOUNT,
1327: NEW_NET_SALES_AMT = nvl(NEW_NET_SALES_AMT,0) +NEW_INVOICE_AMOUNT
1328: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID
1329: AND SUPP_INV_TYPE = STATUS;

Line 1765: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,

1761:
1762: v_statement_id := '78';
1763:
1764:
1765: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1766: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE,
1767: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE,
1768: CREATED_BY, SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1769: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

Line 1769: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,

1765: INSERT INTO JAI_AR_SUP_HDRS_ALL(SUP_HDR_ID,
1766: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE,
1767: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE,
1768: CREATED_BY, SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1769: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1770: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1771: SYSDATE, fnd_global.user_id, NULL, SYSDATE,
1772: fnd_global.user_id, I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1773: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS

Line 1850: UPDATE JAI_AR_SUP_HDRS_ALL

1846: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID
1847: AND SUP_INV_TYPE = STATUS;
1848:
1849: v_statement_id := '88';
1850: UPDATE JAI_AR_SUP_HDRS_ALL
1851: SET EXIST_EXCISE_AMT = NVL(EXIST_EXCISE_AMT,0)+A.TAX_AMOUNT
1852: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID
1853: AND SUPP_INV_TYPE = STATUS;
1854:

Line 1864: UPDATE JAI_AR_SUP_HDRS_ALL

1860: AND SUP_INV_TYPE = STATUS;
1861:
1862: v_statement_id := '90';
1863:
1864: UPDATE JAI_AR_SUP_HDRS_ALL
1865: SET EXIST_OTHER_AMT = NVL(EXIST_OTHER_AMT,0)+A.TAX_AMOUNT
1866: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID
1867: AND SUPP_INV_TYPE = STATUS;
1868: END IF;

Line 1879: UPDATE JAI_AR_SUP_HDRS_ALL

1875: AND SUP_INV_TYPE = STATUS;
1876:
1877: v_statement_id := '92';
1878:
1879: UPDATE JAI_AR_SUP_HDRS_ALL
1880: SET NEW_EXCISE_AMT = NVL(NEW_EXCISE_AMT,0)+B.TAX_AMOUNT
1881: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID
1882: AND SUPP_INV_TYPE = STATUS;
1883:

Line 1894: UPDATE JAI_AR_SUP_HDRS_ALL

1890: AND SUP_INV_TYPE = STATUS;
1891:
1892: v_statement_id := '94';
1893:
1894: UPDATE JAI_AR_SUP_HDRS_ALL
1895: SET NEW_OTHER_AMT = NVL(NEW_OTHER_AMT,0)+B.TAX_AMOUNT
1896: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID
1897: AND SUPP_INV_TYPE = STATUS;
1898:

Line 1913: UPDATE JAI_AR_SUP_HDRS_ALL

1909: WHERE CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID;
1910:
1911: v_statement_id := '96';
1912:
1913: UPDATE JAI_AR_SUP_HDRS_ALL
1914: SET EXCISE_DIFF_AMT = NVL(NEW_EXCISE_AMT,0) - NVL(EXIST_EXCISE_AMT,0),
1915: OTHER_DIFF_AMT = NVL(NEW_OTHER_AMT,0) - NVL(EXIST_OTHER_AMT,0)
1916: WHERE CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID;
1917:

Line 1997: FROM JAI_AR_SUP_HDRS_ALL A,

1993: B.invoice_currency_code,
1994: B.primary_salesrep_id,
1995: B.term_id,
1996: C.organization_id
1997: FROM JAI_AR_SUP_HDRS_ALL A,
1998: RA_CUSTOMER_TRX_ALL B,
1999: JAI_AR_TRXS C
2000: where A.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
2001: AND A.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID

Line 2011: from JAI_AR_SUP_HDRS_ALL;

2007: customer_id,
2008: customer_site,
2009: supp_inv_type,
2010: org_id
2011: from JAI_AR_SUP_HDRS_ALL;
2012:
2013: cursor get_curr(id number,cid number,sid number) is
2014: select distinct invoice_currency_code,
2015: primary_salesrep_id,

Line 2034: from JAI_AR_SUP_HDRS_ALL b,

2030: a.description,
2031: a.unit_code, --2001/04/10 Anuradha Parthasarathy
2032: c.organization_id, --2001/05/10 Anuradha Parthasarathy,
2033: a.interface_line_attribute2
2034: from JAI_AR_SUP_HDRS_ALL b,
2035: JAI_AR_SUP_LINES a,
2036: JAI_AR_TRXS c
2037: where a.customer_trx_id = b.customer_trx_id
2038: and a.customer_trx_id = c.customer_trx_id

Line 2068: from JAI_AR_SUP_HDRS_ALL b,

2064: B.CUSTOMER_ID,
2065: B.supp_INV_TYPE ,
2066: a.INVENTORY_ITEM_ID,
2067: a.interface_line_attribute2
2068: from JAI_AR_SUP_HDRS_ALL b,
2069: JAI_AR_SUP_LINES a,
2070: RA_CUST_TRX_LINE_SALESREPS_ALL C
2071: where a.customer_trx_id = b.customer_trx_id
2072: and a.sup_inv_type = b.supp_inv_type

Line 2095: from JAI_AR_SUP_HDRS_ALL b,

2091: B.CUSTOMER_ID,
2092: B.supp_INV_TYPE ,
2093: INVENTORY_ITEM_ID,
2094: D.SALES_CREDIT_TYPE_ID
2095: from JAI_AR_SUP_HDRS_ALL b,
2096: JAI_AR_SUP_LINES a,
2097: RA_CUST_TRX_LINE_SALESREPS_ALL C,
2098: ra_salesreps_all d
2099: where a.customer_trx_id = b.customer_trx_id

Line 2214: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;

2210: IF CHSN_FOR_CNSLDT = 'N' OR CHSN_FOR_CNSLDT IS NULL THEN
2211: FOR SUPP_INV IN GET_SUPP_INV
2212: LOOP
2213: if supp_inv.supp_inv_type = 'CR' then
2214: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2215: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2216: elsif supp_inv.supp_inv_type = 'DB' then
2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

Line 2215: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2211: FOR SUPP_INV IN GET_SUPP_INV
2212: LOOP
2213: if supp_inv.supp_inv_type = 'CR' then
2214: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2215: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2216: elsif supp_inv.supp_inv_type = 'DB' then
2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2219: elsif supp_inv.supp_inv_type = 'SI' then

Line 2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;

2213: if supp_inv.supp_inv_type = 'CR' then
2214: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2215: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2216: elsif supp_inv.supp_inv_type = 'DB' then
2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2219: elsif supp_inv.supp_inv_type = 'SI' then
2220: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2221: end if ;

Line 2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2214: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2215: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2216: elsif supp_inv.supp_inv_type = 'DB' then
2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2219: elsif supp_inv.supp_inv_type = 'SI' then
2220: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2221: end if ;
2222: open get_address(supp_inv.bill_to_site_use_id);

Line 2220: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2216: elsif supp_inv.supp_inv_type = 'DB' then
2217: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2218: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2219: elsif supp_inv.supp_inv_type = 'SI' then
2220: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2221: end if ;
2222: open get_address(supp_inv.bill_to_site_use_id);
2223: fetch get_address into v_address;
2224: close get_address;

Line 2379: UPDATE JAI_AR_SUP_HDRS_ALL

2375: sysdate);
2376: END LOOP;
2377: END LOOP;
2378:
2379: UPDATE JAI_AR_SUP_HDRS_ALL
2380: SET SUPPLEMENTARY_NUM = V_SEQ,
2381: SUPP_INV_DATE = SYSDATE,
2382: SUPP_INV_RAISED_IND = 'Y',
2383: LAST_UPDATE_DATE = SYSDATE,

Line 2394: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;

2390: Elsif CHSN_FOR_CNSLDT = 'Y' THEN
2391: for cnsldt_header in get_cnsldt_header
2392: loop
2393: IF cnsldt_header.supp_inv_type = 'CR' then
2394: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2395: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2396: elsif cnsldt_header.supp_inv_type = 'DB' then
2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

Line 2395: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2391: for cnsldt_header in get_cnsldt_header
2392: loop
2393: IF cnsldt_header.supp_inv_type = 'CR' then
2394: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2395: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2396: elsif cnsldt_header.supp_inv_type = 'DB' then
2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2399: elsif cnsldt_header.supp_inv_type = 'SI' then

Line 2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;

2393: IF cnsldt_header.supp_inv_type = 'CR' then
2394: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2395: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2396: elsif cnsldt_header.supp_inv_type = 'DB' then
2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2399: elsif cnsldt_header.supp_inv_type = 'SI' then
2400: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2401: end if ;

Line 2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2394: --select JAI_AR_SUP_HDRS_ALL_S3.nextval into v_seq from dual;
2395: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2396: elsif cnsldt_header.supp_inv_type = 'DB' then
2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2399: elsif cnsldt_header.supp_inv_type = 'SI' then
2400: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2401: end if ;
2402:

Line 2400: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;

2396: elsif cnsldt_header.supp_inv_type = 'DB' then
2397: --select JAI_AR_SUP_HDRS_ALL_S2.nextval into v_seq from dual;
2398: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2399: elsif cnsldt_header.supp_inv_type = 'SI' then
2400: select JAI_AR_SUP_HDRS_ALL_S1.nextval into v_seq from dual;
2401: end if ;
2402:
2403: for inv_cnsldt in get_inv_cnsldt(cnsldt_header.set_of_books_id,cnsldt_header.customer_id,
2404: cnsldt_header.customer_site,cnsldt_header.supp_inv_type)

Line 2571: UPDATE JAI_AR_SUP_HDRS_ALL

2567: end loop;
2568: end loop;
2569: end loop;
2570:
2571: UPDATE JAI_AR_SUP_HDRS_ALL
2572: SET SUPPLEMENTARY_NUM = V_SEQ,
2573: SUPP_INV_DATE = SYSDATE,
2574: SUPP_INV_RAISED_IND = 'Y',
2575: LAST_UPDATE_DATE = SYSDATE,