APPS.QPR_LOAD_MEAS_DATA dependencies on QPR_PN_INT_HEADERS_S

Line 30: g_quote_hdr_sd QPR_PN_INT_HEADERS.SOURCE_REF_HEADER_SHORT_DESC%TYPE;

26:
27: g_t_src_lines QPR_SRC_QTN_LINE_TYPE;
28: g_r_ins_deal QPR_DEAL_LINE_TYPE;
29: g_r_upd_deal QPR_DEAL_LINE_TYPE;
30: g_quote_hdr_sd QPR_PN_INT_HEADERS.SOURCE_REF_HEADER_SHORT_DESC%TYPE;
31: g_source_id number;
32:
33: num_meas_cname CONSTANT varchar2(30) := 'MEASURE#_NUMBER';
34: char_meas_cname CONSTANT varchar2(30) := 'MEASURE#_CHAR';

Line 863: values(qpr_pn_int_headers_s.nextval,

859: MEASURE10_CHAR,
860: REQUEST_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
861: LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
862: PROGRAM_APPLICATION_ID,PROGRAM_ID)
863: values(qpr_pn_int_headers_s.nextval,
864: g_instance_id,
865: r_hdr.SOURCE_REF_HEADER_ID,
866: r_hdr.SOURCE_REF_HEADER_SHORT_DESC,
867: r_hdr.SOURCE_REF_HEADER_LONG_DESC,

Line 905: update qpr_pn_int_headers set

901: log_debug('PN_INT_HEADER_ID:' || l_req_int_hdr_id);
902: else
903: if s_status <> 'P' then
904: log_debug('Updating deal interface header...');
905: update qpr_pn_int_headers set
906: INSTANCE_ID = g_instance_id,
907: SOURCE_REF_HEADER_SHORT_DESC = r_hdr.SOURCE_REF_HEADER_SHORT_DESC,
908: SOURCE_REF_HEADER_LONG_DESC = r_hdr.SOURCE_REF_HEADER_LONG_DESC,
909: CUSTOMER_ID = r_hdr.CUSTOMER_ID,