DBA Data[Home] [Help]

APPS.QP_CON_UTIL dependencies on QP_PRC_CONTEXTS_B

Line 814: UPDATE QP_PRC_CONTEXTS_b

810: )
811: IS
812: BEGIN
813:
814: UPDATE QP_PRC_CONTEXTS_b
815: SET ATTRIBUTE1 = p_CON_rec.attribute1
816: , ATTRIBUTE10 = p_CON_rec.attribute10
817: , ATTRIBUTE11 = p_CON_rec.attribute11
818: , ATTRIBUTE12 = p_CON_rec.attribute12

Line 914: INSERT INTO QP_PRC_CONTEXTS_b

910: oe_debug_pub.add('last_update_date=' || p_CON_rec.last_update_date);
911: oe_debug_pub.add('last_updated_by=' || p_CON_rec.last_updated_by);
912: */
913:
914: INSERT INTO QP_PRC_CONTEXTS_b
915: ( ATTRIBUTE1
916: , ATTRIBUTE10
917: , ATTRIBUTE11
918: , ATTRIBUTE12

Line 1051: l_qp_prc_contexts_rec qp_prc_contexts_b%rowtype;

1047: PROCEDURE Delete_Row
1048: ( p_prc_context_id IN NUMBER
1049: )
1050: IS
1051: l_qp_prc_contexts_rec qp_prc_contexts_b%rowtype;
1052: BEGIN
1053: select *
1054: into l_qp_prc_contexts_rec
1055: from qp_prc_contexts_b

Line 1055: from qp_prc_contexts_b

1051: l_qp_prc_contexts_rec qp_prc_contexts_b%rowtype;
1052: BEGIN
1053: select *
1054: into l_qp_prc_contexts_rec
1055: from qp_prc_contexts_b
1056: where prc_context_id = p_prc_context_id;
1057: --
1058: DELETE FROM QP_PRC_CONTEXTS_tl
1059: WHERE PRC_CONTEXT_ID = p_prc_context_id ;

Line 1060: DELETE FROM QP_PRC_CONTEXTS_b

1056: where prc_context_id = p_prc_context_id;
1057: --
1058: DELETE FROM QP_PRC_CONTEXTS_tl
1059: WHERE PRC_CONTEXT_ID = p_prc_context_id ;
1060: DELETE FROM QP_PRC_CONTEXTS_b
1061: WHERE PRC_CONTEXT_ID = p_prc_context_id ;
1062:
1063: -- Added by Abhijit. Create Pricing Contexts in Flex field
1064: --