DBA Data[Home] [Help]

APPS.QP_CON_UTIL dependencies on QP_PRC_CONTEXTS_TL

Line 846: update qp_prc_contexts_tl

842: , PROGRAM_UPDATE_DATE = p_CON_rec.program_update_date
843: , SEEDED_FLAG = p_CON_rec.seeded_flag
844: WHERE PRC_CONTEXT_ID = p_CON_rec.prc_context_id ;
845:
846: update qp_prc_contexts_tl
847: set created_by = p_con_rec.created_by
848: , creation_date = p_con_rec.creation_date
849: , last_updated_by = p_con_rec.last_updated_by
850: , last_update_date = p_con_rec.last_update_date

Line 977: INSERT INTO qp_prc_contexts_tl

973: , p_CON_rec.program_update_date
974: , p_CON_rec.seeded_flag
975: );
976:
977: INSERT INTO qp_prc_contexts_tl
978: ( CREATED_BY
979: , CREATION_DATE
980: , LAST_UPDATED_BY
981: , LAST_UPDATE_DATE

Line 1007: from qp_prc_contexts_tl T

1003: from FND_LANGUAGES L
1004: where L.INSTALLED_FLAG in ('I', 'B')
1005: and not exists
1006: ( select NULL
1007: from qp_prc_contexts_tl T
1008: where T.prc_context_id = p_CON_rec.prc_context_id
1009: and T.LANGUAGE = L.LANGUAGE_CODE );
1010:
1011: -- Abhijit : Add Pricing Attribute type Context to flexfield.

Line 1058: DELETE FROM QP_PRC_CONTEXTS_tl

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 ;
1060: DELETE FROM QP_PRC_CONTEXTS_b
1061: WHERE PRC_CONTEXT_ID = p_prc_context_id ;
1062: