[Home] [Help]
77: where invoice_id = p_invoice_id;
78:
79: cursor c_get_st_hdr_id(p_stform_type varchar2, p_vendor_id number, p_vendor_site_id number, p_org_id number) is
80: select st_hdr_id
81: from JAI_CMN_STFORM_HDRS_ALL
82: where party_type_flag = 'V'
83: and party_id = p_vendor_id
84: and party_site_id = p_vendor_site_id
85: and form_type = p_stform_type
151: v_org_id ap_invoices_all.org_id%type;
152:
153: /*
154: Variable declaration changed by aiyer for the bug #3249375.
155: Changed the variable declaration from reference to ja_in_po_st_forms_hdr.form_issue_id to JAI_CMN_STFORM_HDRS_ALL.st_hdr_id.
156: This was required as the table ja_in_po_st_forms_hdr has been obsoleted.
157: */
158: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_id%type;
159: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
154: Variable declaration changed by aiyer for the bug #3249375.
155: Changed the variable declaration from reference to ja_in_po_st_forms_hdr.form_issue_id to JAI_CMN_STFORM_HDRS_ALL.st_hdr_id.
156: This was required as the table ja_in_po_st_forms_hdr has been obsoleted.
157: */
158: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_id%type;
159: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
160: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
161: v_po_num po_headers_all.segment1%type;
162: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
514: by localization are considered for this processing.
515:
516:
517: 2. 11-Nov-2003 Aiyer - Bug #3249375 File Version 617.1
518: Changed the variable declaration from reference to ja_in_po_st_forms_hdr.form_issue_id to JAI_CMN_STFORM_HDRS_ALL.st_hdr_id.
519: This was required as the table ja_in_po_st_forms_hdr has been obsoleted.
520: As this table does not exist in the database any more, post application of IN60105D1 patchset hence deleting
521: the reference .
522:
831:
832:
833: if v_st_hdr_id is null then
834:
835: --select JAI_CMN_STFORM_HDRS_ALL_S.nextval into v_st_hdr_id from dual;
836:
837: insert into JAI_CMN_STFORM_HDRS_ALL
838: (
839: st_hdr_id,
833: if v_st_hdr_id is null then
834:
835: --select JAI_CMN_STFORM_HDRS_ALL_S.nextval into v_st_hdr_id from dual;
836:
837: insert into JAI_CMN_STFORM_HDRS_ALL
838: (
839: st_hdr_id,
840: party_id,
841: party_site_id,
849: )
850: values
851: (
852: --v_st_hdr_id,
853: JAI_CMN_STFORM_HDRS_ALL_S.nextval,
854: v_vendor_id,
855: v_vendor_site_id,
856: v_stform_type,
857: v_org_id,
1299: p_org_id number
1300: )
1301: is
1302: select st_hdr_id
1303: from JAI_CMN_STFORM_HDRS_ALL
1304: where party_id = p_party_id
1305: and party_site_id = p_party_site_id
1306: and form_type = p_form_type
1307: and org_id = p_org_id
1328:
1329: cursor c_check_duplicate(p_delivery_id Number)
1330: is
1331: select 1
1332: from JAI_CMN_STFORM_HDRS_ALL hdr ,
1333: JAI_CMN_ST_FORM_DTLS dtl
1334: where hdr.st_hdr_id = dtl.st_hdr_id
1335: and dtl.invoice_id = p_delivery_id
1336: and hdr.party_type_flag = 'C';
1546: /*
1547: If the control comes here , it is assumed that the delivery which is being looped has st forms
1548: related taxes no check done here again.
1549: need to insert records into the st forms hdr and st forms detail tables.
1550: JAI_CMN_STFORM_HDRS_ALL
1551: JAI_CMN_ST_FORM_DTLS
1552: */
1553: fnd_file.put_line(FND_FILE.LOG,'1.1 Delivery : ' || st_forms_rec.delivery_id || ' not present in St form tables, hence processing.' );
1554:
1573:
1574:
1575: if v_hdr_record_exists is null then
1576:
1577: /* no record exists in the st forms hdr table (JAI_CMN_STFORM_HDRS_ALL) for the combination of
1578: party , party site , form_type , org_id and party type.
1579: */
1580:
1581:
1578: party , party site , form_type , org_id and party type.
1579: */
1580:
1581:
1582: INSERT INTO JAI_CMN_STFORM_HDRS_ALL(
1583: st_hdr_id ,
1584: party_id ,
1585: party_site_id ,
1586: form_type ,
1591: last_update_login ,
1592: org_id ,
1593: party_type_flag
1594: ) values (
1595: JAI_CMN_STFORM_HDRS_ALL_S.nextval ,
1596: st_forms_rec.customer_id ,
1597: st_forms_rec.customer_site_id ,
1598: tax_rec.stform_type ,
1599: sysdate ,
1603: fnd_global.login_id ,
1604: st_forms_rec.org_id ,
1605: 'C'
1606: ) RETURNING st_hdr_id INTO v_st_hdr_id;
1607: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_STFORM_HDRS_ALL table with header id '|| v_st_hdr_id);
1608: ELSE
1609:
1610: v_st_hdr_id := v_hdr_record_exists;
1611: fnd_file.put_line(FND_FILE.LOG,'header record found . Header id is : ' ||v_st_hdr_id);
1746: p_org_id number
1747: )
1748: is
1749: select st_hdr_id
1750: from JAI_CMN_STFORM_HDRS_ALL
1751: where party_id = p_party_id
1752: and party_site_id = p_party_site_id
1753: and form_type = p_form_type
1754: and org_id = p_org_id
1780:
1781: cursor c_check_duplicate(p_invoice_id Number, p_trx_number varchar2) /*Added trx_number parameter for bug # 9113108 */
1782: is
1783: select 1
1784: from JAI_CMN_STFORM_HDRS_ALL hdr ,
1785: JAI_CMN_ST_FORM_DTLS dtl
1786: where hdr.st_hdr_id = dtl.st_hdr_id
1787: and dtl.invoice_id = p_invoice_id
1788: and dtl.TRX_NUMBER = p_trx_number /*Added trx_number parameter for bug # 9113108 */
1807: trx.org_id = nvl(p_org_id,trx.org_id) AND
1808: NOT EXISTS
1809: (SELECT 1
1810: FROM JAI_CMN_ST_FORM_DTLS a ,
1811: JAI_CMN_STFORM_HDRS_ALL b
1812: WHERE b.party_id = nvl(p_party_id,b.party_id) AND
1813: b.party_site_id = nvl(p_party_site_id,b.party_site_id) AND
1814: b.party_type_flag = 'C' AND
1815: a.st_hdr_id = b.st_hdr_id AND
2035: /*
2036: If the control comes here , it is assumed that the invoice which is being looped has st forms related taxes
2037: no check done here again.
2038: need to insert records into the st forms hdr and st forms detail tables.
2039: JAI_CMN_STFORM_HDRS_ALL
2040: JAI_CMN_ST_FORM_DTLS
2041: */
2042: fnd_file.put_line(FND_FILE.LOG,'1.1 Invoice : '||st_forms_rec.document_type||':' || st_forms_rec.customer_trx_id || ' not present in St form tables, hence processing.' );
2043:
2064:
2065:
2066: if v_hdr_record_exists is null then
2067:
2068: /* no record exists in the st forms hdr table (JAI_CMN_STFORM_HDRS_ALL) for the combination of
2069: party , party site , form_type , org_id and party type.
2070: */
2071:
2072: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_STFORM_HDRS_ALL table');
2068: /* no record exists in the st forms hdr table (JAI_CMN_STFORM_HDRS_ALL) for the combination of
2069: party , party site , form_type , org_id and party type.
2070: */
2071:
2072: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_STFORM_HDRS_ALL table');
2073: INSERT INTO JAI_CMN_STFORM_HDRS_ALL(
2074: st_hdr_id ,
2075: party_id ,
2076: party_site_id ,
2069: party , party site , form_type , org_id and party type.
2070: */
2071:
2072: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_STFORM_HDRS_ALL table');
2073: INSERT INTO JAI_CMN_STFORM_HDRS_ALL(
2074: st_hdr_id ,
2075: party_id ,
2076: party_site_id ,
2077: form_type ,
2082: last_update_login ,
2083: org_id ,
2084: party_type_flag
2085: ) values (
2086: JAI_CMN_STFORM_HDRS_ALL_S.nextval ,
2087: st_forms_rec.customer_id ,
2088: st_forms_rec.customer_site_id ,
2089: tax_rec.stform_type ,
2090: sysdate ,