APPS.QP_LIST_HEADERS_PKG dependencies on QP_LIST_HEADERS_B

Line 68: cursor C is select ROWID from QP_LIST_HEADERS_B

64: X_VIEW_FLAG in VARCHAR2 DEFAULT NULL,
65: X_UPDATE_FLAG in VARCHAR2 DEFAULT NULL
66: ) is
67: l_rowid VARCHAR2(240);
68: cursor C is select ROWID from QP_LIST_HEADERS_B
69: where LIST_HEADER_ID = X_LIST_HEADER_ID
70: ;
71: begin
72: insert into QP_LIST_HEADERS_B (

Line 72: insert into QP_LIST_HEADERS_B (

68: cursor C is select ROWID from QP_LIST_HEADERS_B
69: where LIST_HEADER_ID = X_LIST_HEADER_ID
70: ;
71: begin
72: insert into QP_LIST_HEADERS_B (
73: LIST_SOURCE_CODE,
74: ORIG_SYSTEM_HEADER_REF,
75: GLOBAL_FLAG,
76: ORIG_ORG_ID,

Line 338: from QP_LIST_HEADERS_B

334: ATTRIBUTE12,
335: ATTRIBUTE13,
336: ATTRIBUTE14,
337: ATTRIBUTE15
338: from QP_LIST_HEADERS_B
339: where LIST_HEADER_ID = X_LIST_HEADER_ID
340: for update of LIST_HEADER_ID nowait;
341: recinfo c%rowtype;
342:

Line 541: update QP_LIST_HEADERS_B set

537: X_VIEW_FLAG in VARCHAR2 DEFAULT NULL,
538: X_UPDATE_FLAG in VARCHAR2 DEFAULT NULL
539: ) is
540: begin
541: update QP_LIST_HEADERS_B set
542: LIST_SOURCE_CODE = X_LIST_SOURCE_CODE,
543: ORIG_SYSTEM_HEADER_REF = X_ORIG_SYSTEM_HEADER_REF,
544: GLOBAL_FLAG = X_GLOBAL_FLAG,
545: ORIG_ORG_ID = X_ORIG_ORG_ID,

Line 625: delete from QP_LIST_HEADERS_B

621: if (sql%notfound) then
622: raise no_data_found;
623: end if;
624:
625: delete from QP_LIST_HEADERS_B
626: where LIST_HEADER_ID = X_LIST_HEADER_ID;
627:
628: if (sql%notfound) then
629: raise no_data_found;

Line 639: from QP_LIST_HEADERS_B B

635: begin
636: delete from QP_LIST_HEADERS_TL T
637: where not exists
638: (select NULL
639: from QP_LIST_HEADERS_B B
640: where B.LIST_HEADER_ID = T.LIST_HEADER_ID
641: );
642:
643: update QP_LIST_HEADERS_TL T set (