APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_ACTION_TIMES

Line 11226: PROCEDURE copy_oks_action_times(P_From_Chr_ID IN NUMBER

11222: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11223: -- or as part of component copy from UI (value = 'Y')
11224: --====================================================
11225:
11226: PROCEDURE copy_oks_action_times(P_From_Chr_ID IN NUMBER
11227: ,P_To_Chr_ID IN NUMBER
11228: ,P_Partial_Copy_YN IN VARCHAR2
11229: ,P_Lines_Count IN NUMBER DEFAULT 0
11230: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 11232: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_ACTION_TIMES';

11228: ,P_Partial_Copy_YN IN VARCHAR2
11229: ,P_Lines_Count IN NUMBER DEFAULT 0
11230: ,x_return_status OUT NOCOPY VARCHAR2) IS
11231:
11232: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_ACTION_TIMES';
11233: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
11234: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
11235:
11236: CURSOR GetOksATFull IS

Line 11258: OKS_ACTION_TIMES oksAT

11254: ,oksAT.PROGRAM_UPDATE_DATE AS oksAT_PROGRAM_UPDATE_DATE
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;

Line 11287: OKS_ACTION_TIMES oksAT

11283: ,oksAT.PROGRAM_UPDATE_DATE AS oksAT_PROGRAM_UPDATE_DATE
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

Line 11354: INSERT INTO OKS_ACTION_TIMES (

11350:
11351: End If;
11352:
11353: FORALL i IN OksATRecTab.OksAT_NewID.FIRST .. OksATRecTab.OksAT_NewID.LAST
11354: INSERT INTO OKS_ACTION_TIMES (
11355: ID
11356: ,COV_ACTION_TYPE_ID
11357: ,CLE_ID
11358: ,DNZ_CHR_ID

Line 11431: End copy_oks_action_times;

11427: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
11428: RAISE;
11429:
11430:
11431: End copy_oks_action_times;
11432:
11433: --------------------------------------------------------
11434: --===================================================
11435: -- copy_oks_k_sales_credits

Line 20034: --------------Copy of OKS_ACTION_TIMES-------------------------------

20030: RAISE G_EXCEPTION_HALT_VALIDATION;
20031: End If;
20032: End;
20033: ---------------------------------------------------------------------
20034: --------------Copy of OKS_ACTION_TIMES-------------------------------
20035: Begin
20036: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID
20037: ,P_To_Chr_ID => P_To_Chr_ID
20038: ,P_Partial_Copy_YN => 'N'

Line 20036: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID

20032: End;
20033: ---------------------------------------------------------------------
20034: --------------Copy of OKS_ACTION_TIMES-------------------------------
20035: Begin
20036: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID
20037: ,P_To_Chr_ID => P_To_Chr_ID
20038: ,P_Partial_Copy_YN => 'N'
20039: ,x_return_status => l_return_status);
20040:

Line 25493: --------------Copy of OKS_ACTION_TIMES-------------------------------

25489: RAISE G_EXCEPTION_HALT_VALIDATION;
25490: End If;
25491: End;
25492: ---------------------------------------------------------------------
25493: --------------Copy of OKS_ACTION_TIMES-------------------------------
25494: Begin
25495: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25496: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25497: FND_LOG.string(FND_LOG.level_statement

Line 25498: ,l_module_name||'.copy_oks_action_times'

25494: Begin
25495: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25496: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25497: FND_LOG.string(FND_LOG.level_statement
25498: ,l_module_name||'.copy_oks_action_times'
25499: ,'Before call to copy_oks_action_times'
25500: );
25501: END IF;
25502: END IF;

Line 25499: ,'Before call to copy_oks_action_times'

25495: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25496: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25497: FND_LOG.string(FND_LOG.level_statement
25498: ,l_module_name||'.copy_oks_action_times'
25499: ,'Before call to copy_oks_action_times'
25500: );
25501: END IF;
25502: END IF;
25503:

Line 25504: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID

25500: );
25501: END IF;
25502: END IF;
25503:
25504: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID
25505: ,P_To_Chr_ID => P_To_Chr_ID
25506: ,P_Partial_Copy_YN => 'Y'
25507: ,P_Lines_Count => P_Lines_Tbl.COUNT
25508: ,x_return_status => l_return_status);

Line 25513: ,l_module_name||'.copy_oks_action_times'

25509:
25510: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25511: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25512: FND_LOG.string(FND_LOG.level_statement
25513: ,l_module_name||'.copy_oks_action_times'
25514: ,'After call to copy_oks_action_times: x_return_status:'||l_return_status
25515: ||' '||SQLERRM
25516: );
25517: END IF;

Line 25514: ,'After call to copy_oks_action_times: x_return_status:'||l_return_status

25510: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25511: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25512: FND_LOG.string(FND_LOG.level_statement
25513: ,l_module_name||'.copy_oks_action_times'
25514: ,'After call to copy_oks_action_times: x_return_status:'||l_return_status
25515: ||' '||SQLERRM
25516: );
25517: END IF;
25518: END IF;