[Home] [Help]
61: where invoice_id = p_invoice_id;
62:
63: cursor c_get_st_hdr_id(p_stform_type varchar2, p_vendor_id number, p_vendor_site_id number, p_org_id number) is
64: select st_hdr_id
65: from JAI_CMN_STFORM_HDRS_ALL
66: where party_type_flag = 'V'
67: and party_id = p_vendor_id
68: and party_site_id = p_vendor_site_id
69: and form_type = p_stform_type
135: v_org_id ap_invoices_all.org_id%type;
136:
137: /*
138: Variable declaration changed by aiyer for the bug #3249375.
139: 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.
140: This was required as the table ja_in_po_st_forms_hdr has been obsoleted.
141: */
142: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_id%type;
143: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
138: Variable declaration changed by aiyer for the bug #3249375.
139: 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.
140: This was required as the table ja_in_po_st_forms_hdr has been obsoleted.
141: */
142: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_id%type;
143: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
144: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
145: v_po_num po_headers_all.segment1%type;
146: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
409: by localization are considered for this processing.
410:
411:
412: 2. 11-Nov-2003 Aiyer - Bug #3249375 File Version 617.1
413: 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.
414: This was required as the table ja_in_po_st_forms_hdr has been obsoleted.
415: As this table does not exist in the database any more, post application of IN60105D1 patchset hence deleting
416: the reference .
417:
691:
692:
693: if v_st_hdr_id is null then
694:
695: --select JAI_CMN_STFORM_HDRS_ALL_S.nextval into v_st_hdr_id from dual;
696:
697: insert into JAI_CMN_STFORM_HDRS_ALL
698: (
699: st_hdr_id,
693: if v_st_hdr_id is null then
694:
695: --select JAI_CMN_STFORM_HDRS_ALL_S.nextval into v_st_hdr_id from dual;
696:
697: insert into JAI_CMN_STFORM_HDRS_ALL
698: (
699: st_hdr_id,
700: party_id,
701: party_site_id,
709: )
710: values
711: (
712: --v_st_hdr_id,
713: JAI_CMN_STFORM_HDRS_ALL_S.nextval,
714: v_vendor_id,
715: v_vendor_site_id,
716: v_stform_type,
717: v_org_id,
1159: p_org_id number
1160: )
1161: is
1162: select st_hdr_id
1163: from JAI_CMN_STFORM_HDRS_ALL
1164: where party_id = p_party_id
1165: and party_site_id = p_party_site_id
1166: and form_type = p_form_type
1167: and org_id = p_org_id
1188:
1189: cursor c_check_duplicate(p_delivery_id Number)
1190: is
1191: select 1
1192: from JAI_CMN_STFORM_HDRS_ALL hdr ,
1193: JAI_CMN_ST_FORM_DTLS dtl
1194: where hdr.st_hdr_id = dtl.st_hdr_id
1195: and dtl.invoice_id = p_delivery_id
1196: and hdr.party_type_flag = 'C';
1401: /*
1402: If the control comes here , it is assumed that the delivery which is being looped has st forms
1403: related taxes no check done here again.
1404: need to insert records into the st forms hdr and st forms detail tables.
1405: JAI_CMN_STFORM_HDRS_ALL
1406: JAI_CMN_ST_FORM_DTLS
1407: */
1408: fnd_file.put_line(FND_FILE.LOG,'1.1 Delivery : ' || st_forms_rec.delivery_id || ' not present in St form tables, hence processing.' );
1409:
1428:
1429:
1430: if v_hdr_record_exists is null then
1431:
1432: /* no record exists in the st forms hdr table (JAI_CMN_STFORM_HDRS_ALL) for the combination of
1433: party , party site , form_type , org_id and party type.
1434: */
1435:
1436:
1433: party , party site , form_type , org_id and party type.
1434: */
1435:
1436:
1437: INSERT INTO JAI_CMN_STFORM_HDRS_ALL(
1438: st_hdr_id ,
1439: party_id ,
1440: party_site_id ,
1441: form_type ,
1446: last_update_login ,
1447: org_id ,
1448: party_type_flag
1449: ) values (
1450: JAI_CMN_STFORM_HDRS_ALL_S.nextval ,
1451: st_forms_rec.customer_id ,
1452: st_forms_rec.customer_site_id ,
1453: tax_rec.stform_type ,
1454: sysdate ,
1458: fnd_global.login_id ,
1459: st_forms_rec.org_id ,
1460: 'C'
1461: ) RETURNING st_hdr_id INTO v_st_hdr_id;
1462: fnd_file.put_line(FND_FILE.LOG,' inserting into JAI_CMN_STFORM_HDRS_ALL table with header id '|| v_st_hdr_id);
1463: ELSE
1464:
1465: v_st_hdr_id := v_hdr_record_exists;
1466: fnd_file.put_line(FND_FILE.LOG,'header record found . Header id is : ' ||v_st_hdr_id);
1601: p_org_id number
1602: )
1603: is
1604: select st_hdr_id
1605: from JAI_CMN_STFORM_HDRS_ALL
1606: where party_id = p_party_id
1607: and party_site_id = p_party_site_id
1608: and form_type = p_form_type
1609: and org_id = p_org_id
1635:
1636: cursor c_check_duplicate(p_invoice_id Number)
1637: is
1638: select 1
1639: from JAI_CMN_STFORM_HDRS_ALL hdr ,
1640: JAI_CMN_ST_FORM_DTLS dtl
1641: where hdr.st_hdr_id = dtl.st_hdr_id
1642: and dtl.invoice_id = p_invoice_id
1643: and hdr.party_type_flag = 'C';
1661: trx.org_id = nvl(p_org_id,trx.org_id) AND
1662: NOT EXISTS
1663: (SELECT 1
1664: FROM JAI_CMN_ST_FORM_DTLS a ,
1665: JAI_CMN_STFORM_HDRS_ALL b
1666: WHERE b.party_id = nvl(p_party_id,b.party_id) AND
1667: b.party_site_id = nvl(p_party_site_id,b.party_site_id) AND
1668: b.party_type_flag = 'C' AND
1669: a.st_hdr_id = b.st_hdr_id AND
1888: /*
1889: If the control comes here , it is assumed that the invoice which is being looped has st forms related taxes
1890: no check done here again.
1891: need to insert records into the st forms hdr and st forms detail tables.
1892: JAI_CMN_STFORM_HDRS_ALL
1893: JAI_CMN_ST_FORM_DTLS
1894: */
1895: 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.' );
1896:
1917:
1918:
1919: if v_hdr_record_exists is null then
1920:
1921: /* no record exists in the st forms hdr table (JAI_CMN_STFORM_HDRS_ALL) for the combination of
1922: party , party site , form_type , org_id and party type.
1923: */
1924:
1925: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_STFORM_HDRS_ALL table');
1921: /* no record exists in the st forms hdr table (JAI_CMN_STFORM_HDRS_ALL) for the combination of
1922: party , party site , form_type , org_id and party type.
1923: */
1924:
1925: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_STFORM_HDRS_ALL table');
1926: INSERT INTO JAI_CMN_STFORM_HDRS_ALL(
1927: st_hdr_id ,
1928: party_id ,
1929: party_site_id ,
1922: party , party site , form_type , org_id and party type.
1923: */
1924:
1925: fnd_file.put_line(FND_FILE.LOG,'before inserting into JAI_CMN_STFORM_HDRS_ALL table');
1926: INSERT INTO JAI_CMN_STFORM_HDRS_ALL(
1927: st_hdr_id ,
1928: party_id ,
1929: party_site_id ,
1930: form_type ,
1935: last_update_login ,
1936: org_id ,
1937: party_type_flag
1938: ) values (
1939: JAI_CMN_STFORM_HDRS_ALL_S.nextval ,
1940: st_forms_rec.customer_id ,
1941: st_forms_rec.customer_site_id ,
1942: tax_rec.stform_type ,
1943: sysdate ,