APPS.JAI_PO_OSP_PKG dependencies on JAI_PO_OSP_HDRS_S

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