APPS.JAI_PO_OSP_PKG dependencies on JAI_PO_OSP_HDRS_S

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 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 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 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,