eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PO_OSP_PKG dependencies on JAI_PO_OSP_HDRS

Line 19: insert into JAI_PO_OSP_HDRS, with value as sysdate.

15: Ramananda for bug#4428980. Removal of SQL LITERALs is done
16:
17: 10-MAR-2009 bug 8303018 vumaasha
18: Included the issue_date column in the insert statement
19: insert into JAI_PO_OSP_HDRS, with value as sysdate.
20: 23-SEP-2011 12977826 by anupgupt
21: description: APPROVE 57F(4) DISPATCH FOPRM NOT ALLOWING
22: TO CREATE 57F(4) CHALLAN IF 1ST CHALL
23: fix: corrected cursor query c_header_exists where

Line 177: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;

173:
174: lv_called_release VARCHAR2(10);
175: lv_called_po VARCHAR2(10);
176:
177: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;
178: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;
179: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;
180: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
181:

Line 178: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;

174: lv_called_release VARCHAR2(10);
175: lv_called_po VARCHAR2(10);
176:
177: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;
178: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;
179: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;
180: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
181:
182: cursor c_check_57f4_exists is

Line 179: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;

175: lv_called_po VARCHAR2(10);
176:
177: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;
178: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;
179: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;
180: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
181:
182: cursor c_check_57f4_exists is
183: select 1

Line 180: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;

176:
177: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;
178: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;
179: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;
180: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
181:
182: cursor c_check_57f4_exists is
183: select 1
184: from JAI_PO_OSP_HDRS hdr , JAI_PO_OSP_LINES lines

Line 184: from JAI_PO_OSP_HDRS hdr , JAI_PO_OSP_LINES lines

180: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
181:
182: cursor c_check_57f4_exists is
183: select 1
184: from JAI_PO_OSP_HDRS hdr , JAI_PO_OSP_LINES lines
185: where hdr.form_id = lines.form_id
186: AND hdr.po_header_id = p_po_header_id
187: AND (
188: ( p_called_from = lv_called_po --'PO' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 206: SELECT JAI_PO_OSP_HDRS_S.NEXTVAL

202: AND organization_id = cp_org_id;
203:
204: --******************FETCHING FORM ID FROM SEQUENCE************
205: CURSOR c_form_id IS
206: SELECT JAI_PO_OSP_HDRS_S.NEXTVAL
207: FROM dual;
208:
209: --******************FETCHING LINE ID FROM SEQUENCE************
210: CURSOR c_line_id IS

Line 221: FROM JAI_PO_OSP_HDRS

217: WHERE organization_id = cp_org_id;
218: --******************CHECK IF 57F4 HEADER EXISTS***************** VNK
219: CURSOR c_header_exists(cp_org_id NUMBER, cp_loc_id NUMBER) IS
220: SELECT count(*)
221: FROM JAI_PO_OSP_HDRS
222: WHERE (( po_header_id = p_po_header_id and p_called_from = 'PO')
223: OR ( oth_doc_id = p_po_release_id and p_called_from = 'RELEASE')) -- for bug#12977826 by anupgupt
224: AND organization_id = cp_org_id
225: AND location_id = cp_loc_id

Line 230: FROM JAI_PO_OSP_HDRS

226: AND nvl(cancel_flag,'N') = 'N';/*5699863*/
227: --******************FETCH HEADER ID***************** VNK
228: CURSOR c_header_id(cp_org_id NUMBER, cp_loc_id NUMBER) IS
229: SELECT form_id
230: FROM JAI_PO_OSP_HDRS
231: WHERE (( po_header_id = p_po_header_id and p_called_from = 'PO')
232: OR ( oth_doc_id = p_po_release_id and p_called_from = 'RELEASE')) -- added for bug #13541366
233: AND organization_id = cp_org_id
234: AND location_id = cp_loc_id

Line 538: insert into JAI_PO_OSP_HDRS

534: fetch c_get_item_details into r_get_po_item_details ;
535: close c_get_item_details;
536:
537: /*
538: insert into JAI_PO_OSP_HDRS
539: */
540: if ln_header_ins_flag = 1 then
541:
542: lv_src_release := 'RELEASE' ;

Line 547: INSERT INTO JAI_PO_OSP_HDRS (

543: lv_src_po_release := 'PO RELEASE';
544: lv_src_po := 'PO';
545: lv_src_pur_ord := 'PURCHASE ORDER';
546:
547: INSERT INTO JAI_PO_OSP_HDRS (
548: FORM_ID,
549: PO_HEADER_ID,
550: VENDOR_ID,
551: VENDOR_SITE_ID,

Line 804: (p_form_id JAI_PO_OSP_HDRS.form_id%type)

800: /*------------------------------------------------------------------------------------------------------------*/
801:
802: /* Start - Added by csahoo for bug#5699863 */
803: procedure cancel_osp
804: (p_form_id JAI_PO_OSP_HDRS.form_id%type)
805: is
806: lv_rtv_source VARCHAR2(30) := 'RETURN TO VENDOR';
807:
808:

Line 811: from JAI_PO_OSP_HDRS hdr, JAI_PO_OSP_LINES dtl

807:
808:
809: cursor c_57f4_lines is
810: select hdr.primary_flag, hdr.primary_form_id, dtl.despatch_qty, dtl.po_line_id, dtl.item_id, dtl.form_id, hdr.form_number -- added from number for 13541366
811: from JAI_PO_OSP_HDRS hdr, JAI_PO_OSP_LINES dtl
812: where hdr.form_id = dtl.form_id
813: and hdr.form_id = p_form_id;
814:
815: begin

Line 817: UPDATE JAI_PO_OSP_HDRS

813: and hdr.form_id = p_form_id;
814:
815: begin
816: /* cancel the OSP Challan */
817: UPDATE JAI_PO_OSP_HDRS
818: SET cancel_flag = 'Y'
819: ,last_update_date = sysdate
820: ,last_updated_by = fnd_global.user_id
821: ,last_update_login= fnd_global.login_id

Line 944: v_primary_form_id JAI_PO_OSP_HDRS.primary_form_id%TYPE;

940: FROM po_headers_all
941: WHERE po_header_id = cp_header_id;
942:
943: -- cbabu for Bug# 2746952
944: v_primary_form_id JAI_PO_OSP_HDRS.primary_form_id%TYPE;
945: CURSOR c_primary_form_id( p_po_header_id IN NUMBER, p_oth_doc_id IN NUMBER) IS
946: SELECT form_id
947: FROM JAI_PO_OSP_HDRS
948: WHERE po_header_id = p_po_header_id

Line 947: FROM JAI_PO_OSP_HDRS

943: -- cbabu for Bug# 2746952
944: v_primary_form_id JAI_PO_OSP_HDRS.primary_form_id%TYPE;
945: CURSOR c_primary_form_id( p_po_header_id IN NUMBER, p_oth_doc_id IN NUMBER) IS
946: SELECT form_id
947: FROM JAI_PO_OSP_HDRS
948: WHERE po_header_id = p_po_header_id
949: AND primary_flag = 'Y'
950: AND issue_approved = 'Y'
951: -- AND receipt_approved = 'N' Sriram - bug# 3303027

Line 997: lv_source JAI_PO_OSP_HDRS.source%type ;

993: v_to_uom_code VARCHAR2(25); -- ssumaith - 3644848
994:
995: lv_statement_id VARCHAR2(4);
996:
997: lv_source JAI_PO_OSP_HDRS.source%type ;
998: BEGIN
999: /*----------------------------------------------------------------------------------------------------------------- -
1000: FILENAME: ja_in_create_rcv_57F4_trg.sql CHANGE HISTORY:
1001: S.No DD-MON-YYYY Author and Details

Line 1130: INSERT INTO JAI_PO_OSP_HDRS (

1126:
1127: lv_statement_id := '12';
1128:
1129: lv_source := 'RETURN TO VENDOR' ;
1130: INSERT INTO JAI_PO_OSP_HDRS (
1131: FORM_ID,
1132: OTH_DOC_ID,
1133: PO_HEADER_ID,
1134: VENDOR_ID,

Line 1150: JAI_PO_OSP_HDRS_S.nextval,

1146: CREATED_BY,
1147: LAST_UPDATE_LOGIN,
1148: PRIMARY_FORM_ID -- cbabu for Bug# 2746952
1149: ) VALUES (
1150: JAI_PO_OSP_HDRS_S.nextval,
1151: v_po_release_id,
1152: v_po_header,
1153: v_vendor,
1154: v_vendor_site,

Line 1281: FROM JAI_PO_OSP_HDRS

1277:
1278: --**********TO GET COUNT OF EXISTING 57F4'S**********
1279: CURSOR c_count_primary_57f4 IS
1280: SELECT count(1)
1281: FROM JAI_PO_OSP_HDRS
1282: WHERE
1283: -- nvl(receipt_approved,'N') != 'Y' AND - sriram - bug# 3303027
1284: cancel_flag = 'N'
1285: AND trunc(issue_date) + NVL(process_time,0) >= trunc(sysdate) -- NVL Condition added by sriram - bug# 3021456

Line 1296: FROM JAI_PO_OSP_HDRS

1292:
1293: --**********TO GET THE FORM ID**********
1294: CURSOR c_get_primary_form_id IS
1295: SELECT form_id
1296: FROM JAI_PO_OSP_HDRS
1297: WHERE
1298: --nvl(receipt_approved,'N') != 'Y' AND - sriram - bug# 3303027
1299: cancel_flag = 'N'
1300: AND trunc(issue_date) + NVL(process_time,0) >= trunc(sysdate)

Line 1787: FROM JAI_PO_OSP_HDRS

1783:
1784: FOR each_form IN
1785: (
1786: SELECT '1' seq, form_id, source, form_id*v_match_type order_by
1787: FROM JAI_PO_OSP_HDRS
1788: WHERE form_id = v_primary_form_id
1789:
1790: UNION
1791:

Line 1793: FROM JAI_PO_OSP_HDRS

1789:
1790: UNION
1791:
1792: SELECT '2' seq, form_id, source, form_id*v_match_type order_by
1793: FROM JAI_PO_OSP_HDRS
1794: WHERE primary_form_id = v_primary_form_id
1795: AND NVL(receipt_approved,'N') <> 'Y'
1796: AND issue_approved = 'Y'
1797: ORDER BY order_by

Line 2091: UPDATE JAI_PO_OSP_HDRS

2087: ELSE
2088: v_creation_date := p_creation_date;
2089: END IF;
2090:
2091: UPDATE JAI_PO_OSP_HDRS
2092: SET CR_REG_ENTRY_DATE = v_creation_date
2093: WHERE form_id = vFormId_ToBeUpdWithRegDate;
2094:
2095: END IF;