DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_ACTION_TIME_TYPES

Line 11047: PROCEDURE copy_oks_action_time_types(P_From_Chr_ID IN NUMBER

11043: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11044: -- or as part of component copy from UI (value = 'Y')
11045: --====================================================
11046:
11047: PROCEDURE copy_oks_action_time_types(P_From_Chr_ID IN NUMBER
11048: ,P_To_Chr_ID IN NUMBER
11049: ,P_Partial_Copy_YN IN VARCHAR2
11050: ,P_Lines_Count IN NUMBER DEFAULT 0
11051: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

11049: ,P_Partial_Copy_YN IN VARCHAR2
11050: ,P_Lines_Count IN NUMBER DEFAULT 0
11051: ,x_return_status OUT NOCOPY VARCHAR2) IS
11052:
11053: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_ACTION_TIME_TYPES';
11054: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
11055: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
11056:
11057: CURSOR GetOksATTFull IS

Line 11074: OKS_ACTION_TIME_TYPES oksATT

11070: ,oksATT.ID AS oksATT_ORIG_SYSTEM_ID1--*
11071: ,NULL AS oksATT_ORIG_SYSTEM_SOURCE_CODE--*
11072: ,'COPY' AS oksATT_ORIG_SYSTEM_REFERENCE1--*
11073: FROM
11074: OKS_ACTION_TIME_TYPES oksATT
11075: ,OKC_K_LINES_B okcB
11076: WHERE oksATT.CLE_ID = okcB.ORIG_SYSTEM_ID1
11077: AND okcB.DNZ_CHR_ID = P_To_Chr_ID
11078: AND oksATT.DNZ_CHR_ID = P_From_Chr_ID;

Line 11097: OKS_ACTION_TIME_TYPES oksATT

11093: ,oksATT.ID AS oksATT_ORIG_SYSTEM_ID1--*
11094: ,NULL AS oksATT_ORIG_SYSTEM_SOURCE_CODE--*
11095: ,'COPY' AS oksATT_ORIG_SYSTEM_REFERENCE1--*
11096: FROM
11097: OKS_ACTION_TIME_TYPES oksATT
11098: ,OKC_K_LINES_B_TEMP okcBT
11099: WHERE oksATT.CLE_ID = okcBT.ORIG_SYSTEM_ID1
11100: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID
11101: AND oksATT.DNZ_CHR_ID = P_From_Chr_ID;

Line 11149: INSERT INTO OKS_ACTION_TIME_TYPES(

11145:
11146: End If;
11147:
11148: FORALL i IN OksATTRecTab.OksATT_NewID.FIRST .. OksATTRecTab.OksATT_NewID.LAST
11149: INSERT INTO OKS_ACTION_TIME_TYPES(
11150: ID
11151: ,CLE_ID
11152: ,DNZ_CHR_ID
11153: ,ACTION_TYPE_CODE

Line 11215: End copy_oks_action_time_types;

11211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11212: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
11213: RAISE;
11214:
11215: End copy_oks_action_time_types;
11216:
11217: -----------------------------------------------------
11218: --===================================================
11219: -- copy_oks_pm_action_times

Line 11259: ,OKS_ACTION_TIME_TYPES oksATT

11255: ,oksAT.REQUEST_ID AS oksAT_REQUEST_ID
11256: ,1 AS oksAT_OBJECT_VERSION_NUMBER
11257: FROM
11258: OKS_ACTION_TIMES oksAT
11259: ,OKS_ACTION_TIME_TYPES oksATT
11260: WHERE oksAT.COV_ACTION_TYPE_ID = oksATT.ORIG_SYSTEM_ID1
11261: AND oksATT.DNZ_CHR_ID = P_To_Chr_ID
11262: AND oksAT.DNZ_CHR_ID = P_From_Chr_ID;
11263:

Line 11288: ,OKS_ACTION_TIME_TYPES oksATT

11284: ,oksAT.REQUEST_ID AS oksAT_REQUEST_ID
11285: ,1 AS oksAT_OBJECT_VERSION_NUMBER
11286: FROM
11287: OKS_ACTION_TIMES oksAT
11288: ,OKS_ACTION_TIME_TYPES oksATT
11289: ,OKC_K_LINES_B_TEMP okcBT
11290: WHERE oksAT.COV_ACTION_TYPE_ID = oksATT.ORIG_SYSTEM_ID1
11291: AND oksATT.DNZ_CHR_ID = okcBT.DNZ_CHR_ID
11292: AND oksATT.CLE_ID = okcBT.ID

Line 20022: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------

20018:
20019:
20020: --=====================Start of Action Times copy for Lines====================
20021:
20022: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------
20023: Begin
20024: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID
20025: ,P_To_Chr_ID => P_To_Chr_ID
20026: ,P_Partial_Copy_YN => 'N'

Line 20024: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID

20020: --=====================Start of Action Times copy for Lines====================
20021:
20022: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------
20023: Begin
20024: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID
20025: ,P_To_Chr_ID => P_To_Chr_ID
20026: ,P_Partial_Copy_YN => 'N'
20027: ,x_return_status => l_return_status);
20028:

Line 25460: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------

25456:
25457: --=====================Start of Action Times copy for Lines====================
25458:
25459: IF (P_Lines_Tbl.COUNT > 0) then
25460: --------------Copy of OKS_ACTION_TIME_TYPES-------------------------
25461: Begin
25462: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25463: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25464: FND_LOG.string(FND_LOG.level_statement

Line 25465: ,l_module_name||'.copy_oks_action_time_types'

25461: Begin
25462: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25463: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25464: FND_LOG.string(FND_LOG.level_statement
25465: ,l_module_name||'.copy_oks_action_time_types'
25466: ,'Before call to copy_oks_action_time_types'
25467: );
25468: END IF;
25469: END IF;

Line 25466: ,'Before call to copy_oks_action_time_types'

25462: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25463: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25464: FND_LOG.string(FND_LOG.level_statement
25465: ,l_module_name||'.copy_oks_action_time_types'
25466: ,'Before call to copy_oks_action_time_types'
25467: );
25468: END IF;
25469: END IF;
25470:

Line 25472: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID

25468: END IF;
25469: END IF;
25470:
25471:
25472: copy_oks_action_time_types(P_From_Chr_ID => P_From_Chr_ID
25473: ,P_To_Chr_ID => P_To_Chr_ID
25474: ,P_Partial_Copy_YN => 'Y'
25475: ,P_Lines_Count => P_Lines_Tbl.COUNT
25476: ,x_return_status => l_return_status);

Line 25481: ,l_module_name||'.copy_oks_action_time_types'

25477:
25478: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25479: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25480: FND_LOG.string(FND_LOG.level_statement
25481: ,l_module_name||'.copy_oks_action_time_types'
25482: ,'After call to copy_oks_action_time_types: x_return_status:'||l_return_status
25483: ||' '||SQLERRM
25484: );
25485: END IF;

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

25478: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25479: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25480: FND_LOG.string(FND_LOG.level_statement
25481: ,l_module_name||'.copy_oks_action_time_types'
25482: ,'After call to copy_oks_action_time_types: x_return_status:'||l_return_status
25483: ||' '||SQLERRM
25484: );
25485: END IF;
25486: END IF;