APPS.CS_CF_UPG_UTL_PKG dependencies on CS_CF_SOURCE_CXT_TARGETS

Line 1497: FROM CS_CF_SOURCE_CXT_TARGETS

1493:
1494: CURSOR target_count_resp (p_contextTypeId NUMBER, p_contextValue1 VARCHAR2, p_contextValue2 VARCHAR2)
1495: IS
1496: SELECT count(*)
1497: FROM CS_CF_SOURCE_CXT_TARGETS
1498: WHERE source_context_type_id = p_contextTypeId
1499: AND context_value1 = p_contextValue1
1500: AND context_value2 = p_contextValue2;
1501:

Line 1505: FROM CS_CF_SOURCE_CXT_TARGETS

1501:
1502: CURSOR target_count_appl (p_contextTypeId NUMBER, p_contextValue1 VARCHAR2)
1503: IS
1504: SELECT count(*)
1505: FROM CS_CF_SOURCE_CXT_TARGETS
1506: WHERE source_context_type_id = p_contextTypeId
1507: AND context_value1 = p_contextValue1;
1508:
1509: CURSOR target_count_global (p_contextTypeId NUMBER)

Line 1512: FROM CS_CF_SOURCE_CXT_TARGETS

1508:
1509: CURSOR target_count_global (p_contextTypeId NUMBER)
1510: IS
1511: SELECT count(*)
1512: FROM CS_CF_SOURCE_CXT_TARGETS
1513: WHERE source_context_type_id = p_contextTypeId;
1514:
1515: CURSOR target_values_global (p_contextTypeId NUMBER)
1516: IS

Line 1564: FROM CS_CF_SOURCE_CXT_TARGETS

1560: additional_info12,
1561: additional_info13,
1562: additional_info14,
1563: additional_info15
1564: FROM CS_CF_SOURCE_CXT_TARGETS
1565: WHERE source_context_type_id = p_contextTypeId;
1566:
1567: BEGIN
1568: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Called Inserting new target row for sourceCode: ' || p_sourceCode || ' contextType: ' || p_contextType);

Line 1646: SELECT cs_cf_source_cxt_targets_s.nextval

1642: END IF;
1643: END IF;
1644:
1645: IF (p_contextType <> 'GLOBAL' AND (l_count = 0)) THEN
1646: SELECT cs_cf_source_cxt_targets_s.nextval
1647: INTO l_source_context_target_id
1648: FROM dual;
1649:
1650: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Inserting new target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);

Line 1653: CS_CF_SOURCE_CXT_TARGETS_PKG.Insert_Row(

1649:
1650: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Inserting new target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);
1651: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );
1652:
1653: CS_CF_SOURCE_CXT_TARGETS_PKG.Insert_Row(
1654: X_ROWID => l_rowid,
1655: X_SOURCE_CONTEXT_TARGET_ID => l_source_context_target_id,
1656: X_SOURCE_CONTEXT_TYPE_ID => l_source_context_type_id,
1657: X_CONTEXT_VALUE1 => p_contextValue1,

Line 1719: CS_CF_SOURCE_CXT_TARGETS_PKG.UPDATE_ROW(

1715:
1716: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', 'Updating target row for sourceCode: ' || p_sourceCode || ' contextTargetId: ' || l_source_context_target_id);
1717: log_mesg(FND_LOG.LEVEL_STATEMENT,'CS_CF_UPG_UTL_PKG.Insert_New_Target', ' contextTypeId: ' || l_source_context_type_id || ' p_contextValue1: ' || p_contextValue1 || ' p_contextValue2: ' || p_contextValue2 );
1718:
1719: CS_CF_SOURCE_CXT_TARGETS_PKG.UPDATE_ROW(
1720: X_SOURCE_CONTEXT_TARGET_ID => u_source_context_target_id,
1721: X_SOURCE_CONTEXT_TYPE_ID => l_source_context_type_id,
1722: X_CONTEXT_VALUE1 => u_context_value1,
1723: X_CONTEXT_VALUE2 => u_context_value2,

Line 1841: -- cs_cf_source_cxt_targets table will get populated again

1837: -- not to clone a region if it already exists. For resp and appl,
1838: -- we will never get here because if any regions are cloned, we will
1839: -- exit out of their upgrade procedure.
1840: -- This is so that the cust target values column in the
1841: -- cs_cf_source_cxt_targets table will get populated again
1842: -- after the ldt is uploaded.
1843:
1844: IF ((p_checkRegion AND l_count = 0) OR NOT p_checkRegion) THEN
1845: