DBA Data[Home] [Help]

APPS.CS_CF_UPG_PKG dependencies on CS_CF_SOURCE_CXT_TARGETS

Line 1625: -- Now enter the rows in the cs_cf_source_cxt_targets table

1621:
1622: l_newUpdateViewExists := TRUE;
1623: END IF;
1624:
1625: -- Now enter the rows in the cs_cf_source_cxt_targets table
1626: -- for this responsibility
1627:
1628: IF (l_newIdentifyProblemExists ) THEN
1629: CS_CF_UPG_UTL_PKG.Insert_New_Target(

Line 2987: -- Now enter the rows in the cs_cf_source_cxt_targets table

2983:
2984: l_newUpdateViewExists := TRUE;
2985: END IF;
2986:
2987: -- Now enter the rows in the cs_cf_source_cxt_targets table
2988: -- for this responsibility
2989:
2990: IF (l_newIdentifyProblemExists ) THEN
2991: CS_CF_UPG_UTL_PKG.Insert_New_Target(

Line 4218: -- Now enter the rows in the cs_cf_source_cxt_targets table

4214:
4215: l_newUpdateViewExists := TRUE;
4216: END IF;
4217:
4218: -- Now enter the rows in the cs_cf_source_cxt_targets table
4219: -- for this responsibility
4220:
4221: IF (l_newIdentifyProblemExists ) THEN
4222: CS_CF_UPG_UTL_PKG.Insert_New_Target(

Line 4718: FROM cs_cf_source_cxt_targets

4714: l_count2 NUMBER := 0;
4715:
4716: CURSOR l_cur(p_source_context_type_id IN VARCHAR2) IS
4717: SELECT last_updated_by
4718: FROM cs_cf_source_cxt_targets
4719: WHERE source_context_type_id = p_source_context_type_id;
4720:
4721: CURSOR l_cur2(p_source_context_type_id IN VARCHAR2) IS
4722: SELECT count(*)

Line 4723: FROM cs_cf_source_cxt_targets

4719: WHERE source_context_type_id = p_source_context_type_id;
4720:
4721: CURSOR l_cur2(p_source_context_type_id IN VARCHAR2) IS
4722: SELECT count(*)
4723: FROM cs_cf_source_cxt_targets
4724: WHERE source_context_type_id = p_source_context_type_id;
4725:
4726: BEGIN
4727:

Line 4753: UPDATE cs_cf_source_cxt_targets

4749: -- mkcyee 02/26/2004 - only update the entry is it has not
4750: -- been customized
4751: IF (l_last_updated_by in (-1,1,2) AND l_count2 > 0) THEN
4752:
4753: UPDATE cs_cf_source_cxt_targets
4754: SET cust_target_value1 = '10'
4755: WHERE source_context_type_id = l_source_context_type_id;
4756:
4757: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Do_Flow_Upgrades_For_Global', 'Updating global entry in cs_cf_source_cxt_targets to use 11510 default flow. l_source_context_type_id:' || l_source_context_type_id);

Line 4757: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Do_Flow_Upgrades_For_Global', 'Updating global entry in cs_cf_source_cxt_targets to use 11510 default flow. l_source_context_type_id:' || l_source_context_type_id);

4753: UPDATE cs_cf_source_cxt_targets
4754: SET cust_target_value1 = '10'
4755: WHERE source_context_type_id = l_source_context_type_id;
4756:
4757: CS_CF_UPG_UTL_PKG.log_mesg(FND_LOG.LEVEL_STATEMENT, 'CS_CF_UPG_PKG.Do_Flow_Upgrades_For_Global', 'Updating global entry in cs_cf_source_cxt_targets to use 11510 default flow. l_source_context_type_id:' || l_source_context_type_id);
4758: END IF;
4759:
4760: END IF;
4761: l_examineKBOption := FALSE;