DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_ACTION_TIME_TYPES

Line 11002: PROCEDURE copy_oks_action_time_types(P_From_Chr_ID IN NUMBER

10998: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
10999: -- or as part of component copy from UI (value = 'Y')
11000: --====================================================
11001:
11002: PROCEDURE copy_oks_action_time_types(P_From_Chr_ID IN NUMBER
11003: ,P_To_Chr_ID IN NUMBER
11004: ,P_Partial_Copy_YN IN VARCHAR2
11005: ,P_Lines_Count IN NUMBER DEFAULT 0
11006: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 11008: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_ACTION_TIME_TYPES';

11004: ,P_Partial_Copy_YN IN VARCHAR2
11005: ,P_Lines_Count IN NUMBER DEFAULT 0
11006: ,x_return_status OUT NOCOPY VARCHAR2) IS
11007:
11008: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_ACTION_TIME_TYPES';
11009: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
11010: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
11011:
11012: CURSOR GetOksATTFull IS

Line 11029: OKS_ACTION_TIME_TYPES oksATT

11025: ,oksATT.ID AS oksATT_ORIG_SYSTEM_ID1--*
11026: ,NULL AS oksATT_ORIG_SYSTEM_SOURCE_CODE--*
11027: ,'COPY' AS oksATT_ORIG_SYSTEM_REFERENCE1--*
11028: FROM
11029: OKS_ACTION_TIME_TYPES oksATT
11030: ,OKC_K_LINES_B okcB
11031: WHERE oksATT.CLE_ID = okcB.ORIG_SYSTEM_ID1
11032: AND okcB.DNZ_CHR_ID = P_To_Chr_ID
11033: AND oksATT.DNZ_CHR_ID = P_From_Chr_ID;

Line 11052: OKS_ACTION_TIME_TYPES oksATT

11048: ,oksATT.ID AS oksATT_ORIG_SYSTEM_ID1--*
11049: ,NULL AS oksATT_ORIG_SYSTEM_SOURCE_CODE--*
11050: ,'COPY' AS oksATT_ORIG_SYSTEM_REFERENCE1--*
11051: FROM
11052: OKS_ACTION_TIME_TYPES oksATT
11053: ,OKC_K_LINES_B_TEMP okcBT
11054: WHERE oksATT.CLE_ID = okcBT.ORIG_SYSTEM_ID1
11055: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID
11056: AND oksATT.DNZ_CHR_ID = P_From_Chr_ID;

Line 11104: INSERT INTO OKS_ACTION_TIME_TYPES(

11100:
11101: End If;
11102:
11103: FORALL i IN OksATTRecTab.OksATT_NewID.FIRST .. OksATTRecTab.OksATT_NewID.LAST
11104: INSERT INTO OKS_ACTION_TIME_TYPES(
11105: ID
11106: ,CLE_ID
11107: ,DNZ_CHR_ID
11108: ,ACTION_TYPE_CODE

Line 11170: End copy_oks_action_time_types;

11166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11167: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
11168: RAISE;
11169:
11170: End copy_oks_action_time_types;
11171:
11172: -----------------------------------------------------
11173: --===================================================
11174: -- copy_oks_pm_action_times

Line 11214: ,OKS_ACTION_TIME_TYPES oksATT

11210: ,oksAT.REQUEST_ID AS oksAT_REQUEST_ID
11211: ,1 AS oksAT_OBJECT_VERSION_NUMBER
11212: FROM
11213: OKS_ACTION_TIMES oksAT
11214: ,OKS_ACTION_TIME_TYPES oksATT
11215: WHERE oksAT.COV_ACTION_TYPE_ID = oksATT.ORIG_SYSTEM_ID1
11216: AND oksATT.DNZ_CHR_ID = P_To_Chr_ID
11217: AND oksAT.DNZ_CHR_ID = P_From_Chr_ID;
11218:

Line 11243: ,OKS_ACTION_TIME_TYPES oksATT

11239: ,oksAT.REQUEST_ID AS oksAT_REQUEST_ID
11240: ,1 AS oksAT_OBJECT_VERSION_NUMBER
11241: FROM
11242: OKS_ACTION_TIMES oksAT
11243: ,OKS_ACTION_TIME_TYPES oksATT
11244: ,OKC_K_LINES_B_TEMP okcBT
11245: WHERE oksAT.COV_ACTION_TYPE_ID = oksATT.ORIG_SYSTEM_ID1
11246: AND oksATT.DNZ_CHR_ID = okcBT.DNZ_CHR_ID
11247: AND oksATT.CLE_ID = okcBT.ID

Line 19875: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------

19871:
19872:
19873: --=====================Start of Action Times copy for Lines====================
19874:
19875: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------
19876: Begin
19877: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID
19878: ,P_To_Chr_ID => P_To_Chr_ID
19879: ,P_Partial_Copy_YN => 'N'

Line 19877: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID

19873: --=====================Start of Action Times copy for Lines====================
19874:
19875: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------
19876: Begin
19877: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID
19878: ,P_To_Chr_ID => P_To_Chr_ID
19879: ,P_Partial_Copy_YN => 'N'
19880: ,x_return_status => l_return_status);
19881:

Line 25265: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------

25261:
25262: --=====================Start of Action Times copy for Lines====================
25263:
25264: IF (P_Lines_Tbl.COUNT > 0) then
25265: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------
25266: Begin
25267: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25268: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25269: FND_LOG.string(FND_LOG.level_statement

Line 25270: ,l_module_name||'.copy_oks_action_time_types'

25266: Begin
25267: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25268: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25269: FND_LOG.string(FND_LOG.level_statement
25270: ,l_module_name||'.copy_oks_action_time_types'
25271: ,'Before call to copy_oks_action_time_types'
25272: );
25273: END IF;
25274: END IF;

Line 25271: ,'Before call to copy_oks_action_time_types'

25267: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25268: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25269: FND_LOG.string(FND_LOG.level_statement
25270: ,l_module_name||'.copy_oks_action_time_types'
25271: ,'Before call to copy_oks_action_time_types'
25272: );
25273: END IF;
25274: END IF;
25275:

Line 25277: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID

25273: END IF;
25274: END IF;
25275:
25276:
25277: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID
25278: ,P_To_Chr_ID => P_To_Chr_ID
25279: ,P_Partial_Copy_YN => 'Y'
25280: ,P_Lines_Count => P_Lines_Tbl.COUNT
25281: ,x_return_status => l_return_status);

Line 25286: ,l_module_name||'.copy_oks_action_time_types'

25282:
25283: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25284: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25285: FND_LOG.string(FND_LOG.level_statement
25286: ,l_module_name||'.copy_oks_action_time_types'
25287: ,'After call to copy_oks_action_time_types: x_return_status:'||l_return_status
25288: ||' '||SQLERRM
25289: );
25290: END IF;

Line 25287: ,'After call to copy_oks_action_time_types: x_return_status:'||l_return_status

25283: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25284: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25285: FND_LOG.string(FND_LOG.level_statement
25286: ,l_module_name||'.copy_oks_action_time_types'
25287: ,'After call to copy_oks_action_time_types: x_return_status:'||l_return_status
25288: ||' '||SQLERRM
25289: );
25290: END IF;
25291: END IF;