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 119: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;

115:
116: lv_called_release VARCHAR2(10);
117: lv_called_po VARCHAR2(10);
118:
119: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;
120: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;
121: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;
122: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
123:

Line 120: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;

116: lv_called_release VARCHAR2(10);
117: lv_called_po VARCHAR2(10);
118:
119: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;
120: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;
121: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;
122: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
123:
124: cursor c_check_57f4_exists is

Line 121: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;

117: lv_called_po VARCHAR2(10);
118:
119: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;
120: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;
121: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;
122: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
123:
124: cursor c_check_57f4_exists is
125: select 1

Line 122: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;

118:
119: lv_src_release JAI_PO_OSP_HDRS.SOURCE%type;
120: lv_src_po_release JAI_PO_OSP_HDRS.SOURCE%type;
121: lv_src_po JAI_PO_OSP_HDRS.SOURCE%type;
122: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
123:
124: cursor c_check_57f4_exists is
125: select 1
126: from JAI_PO_OSP_HDRS hdr , JAI_PO_OSP_LINES lines

Line 126: from JAI_PO_OSP_HDRS hdr , JAI_PO_OSP_LINES lines

122: lv_src_pur_ord JAI_PO_OSP_HDRS.SOURCE%type;
123:
124: cursor c_check_57f4_exists is
125: select 1
126: from JAI_PO_OSP_HDRS hdr , JAI_PO_OSP_LINES lines
127: where hdr.form_id = lines.form_id
128: AND hdr.po_header_id = p_po_header_id
129: AND (
130: ( p_called_from = lv_called_po --'PO' /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 148: SELECT JAI_PO_OSP_HDRS_S.NEXTVAL

144: AND organization_id = cp_org_id;
145:
146: --******************FETCHING FORM ID FROM SEQUENCE************
147: CURSOR c_form_id IS
148: SELECT JAI_PO_OSP_HDRS_S.NEXTVAL
149: FROM dual;
150:
151: --******************FETCHING LINE ID FROM SEQUENCE************
152: CURSOR c_line_id IS

Line 163: FROM JAI_PO_OSP_HDRS

159: WHERE organization_id = cp_org_id;
160: --******************CHECK IF 57F4 HEADER EXISTS***************** VNK
161: CURSOR c_header_exists(cp_org_id NUMBER, cp_loc_id NUMBER) IS
162: SELECT count(*)
163: FROM JAI_PO_OSP_HDRS
164: WHERE ( po_header_id = p_po_header_id and p_called_from = 'PO')
165: OR ( oth_doc_id = p_po_release_id and p_called_from = 'RELEASE')
166: AND organization_id = cp_org_id
167: AND location_id = cp_loc_id

Line 172: FROM JAI_PO_OSP_HDRS

168: AND nvl(cancel_flag,'N') = 'N';/*5699863*/
169: --******************FETCH HEADER ID***************** VNK
170: CURSOR c_header_id(cp_org_id NUMBER, cp_loc_id NUMBER) IS
171: SELECT form_id
172: FROM JAI_PO_OSP_HDRS
173: WHERE ( po_header_id = p_po_header_id and p_called_from = 'PO')
174: OR ( oth_doc_id = p_po_release_id and p_called_from = 'RELEASE')
175: AND organization_id = cp_org_id
176: AND location_id = cp_loc_id;

Line 442: insert into JAI_PO_OSP_HDRS

438: fetch c_get_item_details into r_get_po_item_details ;
439: close c_get_item_details;
440:
441: /*
442: insert into JAI_PO_OSP_HDRS
443: */
444: if ln_header_ins_flag = 1 then
445:
446: lv_src_release := 'RELEASE' ;

Line 451: INSERT INTO JAI_PO_OSP_HDRS (

447: lv_src_po_release := 'PO RELEASE';
448: lv_src_po := 'PO';
449: lv_src_pur_ord := 'PURCHASE ORDER';
450:
451: INSERT INTO JAI_PO_OSP_HDRS (
452: FORM_ID,
453: PO_HEADER_ID,
454: VENDOR_ID,
455: VENDOR_SITE_ID,

Line 693: (p_form_id JAI_PO_OSP_HDRS.form_id%type)

689: /*------------------------------------------------------------------------------------------------------------*/
690:
691: /* Start - Added by csahoo for bug#5699863 */
692: procedure cancel_osp
693: (p_form_id JAI_PO_OSP_HDRS.form_id%type)
694: is
695: lv_rtv_source VARCHAR2(30) := 'RETURN TO VENDOR';
696:
697:

Line 700: from JAI_PO_OSP_HDRS hdr, JAI_PO_OSP_LINES dtl

696:
697:
698: cursor c_57f4_lines is
699: select hdr.primary_flag, hdr.primary_form_id, dtl.despatch_qty, dtl.po_line_id, dtl.item_id
700: from JAI_PO_OSP_HDRS hdr, JAI_PO_OSP_LINES dtl
701: where hdr.form_id = dtl.form_id
702: and hdr.form_id = p_form_id;
703:
704: begin

Line 706: UPDATE JAI_PO_OSP_HDRS

702: and hdr.form_id = p_form_id;
703:
704: begin
705: /* cancel the OSP Challan */
706: UPDATE JAI_PO_OSP_HDRS
707: SET cancel_flag = 'Y'
708: ,last_update_date = sysdate
709: ,last_updated_by = fnd_global.user_id
710: ,last_update_login= fnd_global.login_id

Line 823: v_primary_form_id JAI_PO_OSP_HDRS.primary_form_id%TYPE;

819: FROM po_headers_all
820: WHERE po_header_id = cp_header_id;
821:
822: -- cbabu for Bug# 2746952
823: v_primary_form_id JAI_PO_OSP_HDRS.primary_form_id%TYPE;
824: CURSOR c_primary_form_id( p_po_header_id IN NUMBER, p_oth_doc_id IN NUMBER) IS
825: SELECT form_id
826: FROM JAI_PO_OSP_HDRS
827: WHERE po_header_id = p_po_header_id

Line 826: FROM JAI_PO_OSP_HDRS

822: -- cbabu for Bug# 2746952
823: v_primary_form_id JAI_PO_OSP_HDRS.primary_form_id%TYPE;
824: CURSOR c_primary_form_id( p_po_header_id IN NUMBER, p_oth_doc_id IN NUMBER) IS
825: SELECT form_id
826: FROM JAI_PO_OSP_HDRS
827: WHERE po_header_id = p_po_header_id
828: AND primary_flag = 'Y'
829: AND issue_approved = 'Y'
830: -- AND receipt_approved = 'N' Sriram - bug# 3303027

Line 876: lv_source JAI_PO_OSP_HDRS.source%type ;

872: v_to_uom_code VARCHAR2(25); -- ssumaith - 3644848
873:
874: lv_statement_id VARCHAR2(4);
875:
876: lv_source JAI_PO_OSP_HDRS.source%type ;
877: BEGIN
878: /*----------------------------------------------------------------------------------------------------------------- -
879: FILENAME: ja_in_create_rcv_57F4_trg.sql CHANGE HISTORY:
880: S.No DD-MON-YYYY Author and Details

Line 1009: INSERT INTO JAI_PO_OSP_HDRS (

1005:
1006: lv_statement_id := '12';
1007:
1008: lv_source := 'RETURN TO VENDOR' ;
1009: INSERT INTO JAI_PO_OSP_HDRS (
1010: FORM_ID,
1011: OTH_DOC_ID,
1012: PO_HEADER_ID,
1013: VENDOR_ID,

Line 1029: JAI_PO_OSP_HDRS_S.nextval,

1025: CREATED_BY,
1026: LAST_UPDATE_LOGIN,
1027: PRIMARY_FORM_ID -- cbabu for Bug# 2746952
1028: ) VALUES (
1029: JAI_PO_OSP_HDRS_S.nextval,
1030: v_po_release_id,
1031: v_po_header,
1032: v_vendor,
1033: v_vendor_site,

Line 1158: FROM JAI_PO_OSP_HDRS

1154:
1155: --**********TO GET COUNT OF EXISTING 57F4'S**********
1156: CURSOR c_count_primary_57f4 IS
1157: SELECT count(1)
1158: FROM JAI_PO_OSP_HDRS
1159: WHERE
1160: -- nvl(receipt_approved,'N') != 'Y' AND - sriram - bug# 3303027
1161: cancel_flag = 'N'
1162: AND trunc(issue_date) + NVL(process_time,0) >= trunc(sysdate) -- NVL Condition added by sriram - bug# 3021456

Line 1173: FROM JAI_PO_OSP_HDRS

1169:
1170: --**********TO GET THE FORM ID**********
1171: CURSOR c_get_primary_form_id IS
1172: SELECT form_id
1173: FROM JAI_PO_OSP_HDRS
1174: WHERE
1175: --nvl(receipt_approved,'N') != 'Y' AND - sriram - bug# 3303027
1176: cancel_flag = 'N'
1177: AND trunc(issue_date) + NVL(process_time,0) >= trunc(sysdate)

Line 1603: FROM JAI_PO_OSP_HDRS

1599:
1600: FOR each_form IN
1601: (
1602: SELECT '1' seq, form_id, source, form_id*v_match_type order_by
1603: FROM JAI_PO_OSP_HDRS
1604: WHERE form_id = v_primary_form_id
1605:
1606: UNION
1607:

Line 1609: FROM JAI_PO_OSP_HDRS

1605:
1606: UNION
1607:
1608: SELECT '2' seq, form_id, source, form_id*v_match_type order_by
1609: FROM JAI_PO_OSP_HDRS
1610: WHERE primary_form_id = v_primary_form_id
1611: AND NVL(receipt_approved,'N') <> 'Y'
1612: AND issue_approved = 'Y'
1613: ORDER BY order_by

Line 1800: UPDATE JAI_PO_OSP_HDRS

1796: ELSE
1797: v_creation_date := p_creation_date;
1798: END IF;
1799:
1800: UPDATE JAI_PO_OSP_HDRS
1801: SET CR_REG_ENTRY_DATE = v_creation_date
1802: WHERE form_id = vFormId_ToBeUpdWithRegDate;
1803:
1804: END IF;