APPS.JAI_CMN_ST_FORMS_PKG dependencies on DUAL

Line 136: FROM dual

132: where invoice_id = p_invoice_id
133: and nvl(match_status_flag, 'N') <> 'A';*/
134: --commented the above and added the below by Sanjikum for Bug#4929400
135: SELECT 'Y'
136: FROM dual
137: WHERE exists (select '1'
138: from ap_invoice_distributions_all
139: where invoice_id = p_invoice_id
140: and nvl(match_status_flag, 'N') <> 'A');

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 938: /* select JAI_CMN_ST_FORM_DTLS_S.nextval into v_st_dtl_id from dual; */

934: end if;
935:
936: end if;
937: -- End 5763527
938: /* select JAI_CMN_ST_FORM_DTLS_S.nextval into v_st_dtl_id from dual; */
939:
940: v_rcv_transaction_id := null;
941:
942:

Line 2003: Also the code SELECT .nextval INTO FROM DUAL is modified to populate during INSERT

1999:
2000: 2. 13/02/2004 Vijay Shankar for bug # 3441533, FileVersion: 618.1
2001: v_hdr_record_exists variable which is used to check whether header is inserted or not is retaining its value
2002: in the loop. This is fixed by assigning NULL at the start of the loop so that it wont retain its value.
2003: Also the code SELECT .nextval INTO FROM DUAL is modified to populate during INSERT
2004: Statement. Usage of v_success variable is removed
2005:
2006: 3. 18/11/2008 JMEENA for bug#4932256 (FP 4913641)
2007: Issue: Debit Notes and Credit Notes are not considered for AR ST Forms tracking in AR