APPS.QP_MODIFIER_UPGRADE_UTIL_PVT dependencies on QP_LIST_HEADERS_B

Line 66: INSERT INTO QP_LIST_HEADERS_B (

62: ELSE
63: v_seq_num := p_seq_num + 1;
64: END IF;
65:
66: INSERT INTO QP_LIST_HEADERS_B (
67: LIST_HEADER_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
68: LAST_UPDATE_LOGIN, LIST_TYPE_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE,
69: AUTOMATIC_FLAG,DISCOUNT_LINES_FLAG, CURRENCY_CODE,ASK_FOR_FLAG,
70: SOURCE_SYSTEM_CODE, ACTIVE_FLAG,GSA_INDICATOR,CONTEXT,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,

Line 75: QP_LIST_HEADERS_B_S.nextval,p_creation_date, p_created_by,p_last_update_date,p_last_updated_by,

71: ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,
72: ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15)
73:
74: VALUES(
75: QP_LIST_HEADERS_B_S.nextval,p_creation_date, p_created_by,p_last_update_date,p_last_updated_by,
76: p_last_update_login,p_list_type_code,p_start_date_effective,p_end_date_effective,
77: p_automatic_flag,p_discount_lines_flag,p_currency_code,p_ask_for_flag,
78: p_source_system_code,p_active_flag,p_gsa_indicator,p_context,p_attribute1,p_attribute2,p_attribute3,p_attribute4,
79: p_attribute5,p_attribute6,p_attribute7,p_attribute8,p_attribute9,p_attribute10,

Line 83: SELECT QP_LIST_HEADERS_B_S.currval

79: p_attribute5,p_attribute6,p_attribute7,p_attribute8,p_attribute9,p_attribute10,
80: p_attribute11,p_attribute12,p_attribute13,p_attribute14,p_attribute15);
81:
82: -- Store the current list header id
83: SELECT QP_LIST_HEADERS_B_S.currval
84: INTO x_list_header_id
85: FROM DUAL;
86:
87: --x_list_header_id := v_seq_num;

Line 227: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id)

223: p_attribute7, p_attribute8,p_attribute9,p_attribute10, p_attribute11,p_attribute12, p_attribute13,
224: p_attribute14, p_attribute15
225: --ENH Upgrade BOAPI for orig_sys...ref RAVI
226: ,to_char(v_list_line_seq)
227: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id)
228: );
229:
230: -- Store the new list line id
231:

Line 333: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id)

329: p_attribute14,p_attribute15
330: --ENH Upgrade BOAPI for orig_sys...ref RAVI
331: ,to_char(QP_QUALIFIERS_S.currval)
332: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
333: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=p_list_header_id)
334: );
335: EXCEPTION
336: WHEN OTHERS THEN
337: err_msg := SQLERRM;