APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_CMN_STFORM_HDRS_ALL_S

Line 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.

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;

Line 142: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_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;

Line 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.

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:

Line 695: --select JAI_CMN_STFORM_HDRS_ALL_S.nextval into v_st_hdr_id from dual;

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,

Line 713: JAI_CMN_STFORM_HDRS_ALL_S.nextval,

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,

Line 1450: JAI_CMN_STFORM_HDRS_ALL_S.nextval ,

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 ,

Line 1939: JAI_CMN_STFORM_HDRS_ALL_S.nextval ,

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 ,