APPS.QPR_PN_REQUEST_HDRS_PKG dependencies on QPR_PN_REQUEST_HDRS_B

Line 75: cursor C is select ROWID from QPR_PN_REQUEST_HDRS_B

71: X_LAST_UPDATE_DATE in DATE,
72: X_LAST_UPDATED_BY in NUMBER,
73: X_LAST_UPDATE_LOGIN in NUMBER
74: ) is
75: cursor C is select ROWID from QPR_PN_REQUEST_HDRS_B
76: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
77: ;
78: begin
79: insert into QPR_PN_REQUEST_HDRS_B (

Line 79: insert into QPR_PN_REQUEST_HDRS_B (

75: cursor C is select ROWID from QPR_PN_REQUEST_HDRS_B
76: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
77: ;
78: begin
79: insert into QPR_PN_REQUEST_HDRS_B (
80: SOURCE_REF_HDR_LONG_DESC,
81: --ORG_SHORT_DESC,
82: --ORG_LONG_DESC,
83: CUSTOMER_SHORT_DESC,

Line 394: from QPR_PN_REQUEST_HDRS_B

390: CURRENCY_LONG_DESC,
391: SOURCE_SHORT_DESC,
392: SOURCE_LONG_DESC,
393: SOURCE_REF_HDR_SHORT_DESC
394: from QPR_PN_REQUEST_HDRS_B
395: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID
396: for update of REQUEST_HEADER_ID nowait;
397: recinfo c%rowtype;
398:

Line 628: update QPR_PN_REQUEST_HDRS_B set

624: X_LAST_UPDATED_BY in NUMBER,
625: X_LAST_UPDATE_LOGIN in NUMBER
626: ) is
627: begin
628: update QPR_PN_REQUEST_HDRS_B set
629: SOURCE_REF_HDR_LONG_DESC = X_SOURCE_REF_HDR_LONG_DESC,
630: --ORG_SHORT_DESC = X_ORG_SHORT_DESC,
631: --ORG_LONG_DESC = X_ORG_LONG_DESC,
632: CUSTOMER_SHORT_DESC = X_CUSTOMER_SHORT_DESC,

Line 725: delete from QPR_PN_REQUEST_HDRS_B

721: if (sql%notfound) then
722: raise no_data_found;
723: end if;
724:
725: delete from QPR_PN_REQUEST_HDRS_B
726: where REQUEST_HEADER_ID = X_REQUEST_HEADER_ID;
727:
728: if (sql%notfound) then
729: raise no_data_found;

Line 739: from QPR_PN_REQUEST_HDRS_B B

735: begin
736: delete from QPR_PN_REQUEST_HDRS_TL T
737: where not exists
738: (select NULL
739: from QPR_PN_REQUEST_HDRS_B B
740: where B.REQUEST_HEADER_ID = T.REQUEST_HEADER_ID
741: );
742:
743: update QPR_PN_REQUEST_HDRS_TL T set (