DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on JAI_CMN_STFORM_HDRS_ALL_S

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

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;

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

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

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:

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

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,

Line 853: JAI_CMN_STFORM_HDRS_ALL_S.nextval,

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,

Line 1595: JAI_CMN_STFORM_HDRS_ALL_S.nextval ,

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 ,

Line 2086: JAI_CMN_STFORM_HDRS_ALL_S.nextval ,

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 ,