APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_ACTION_TIMES

Line 11181: PROCEDURE copy_oks_action_times(P_From_Chr_ID IN NUMBER

11177: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11178: -- or as part of component copy from UI (value = 'Y')
11179: --====================================================
11180:
11181: PROCEDURE copy_oks_action_times(P_From_Chr_ID IN NUMBER
11182: ,P_To_Chr_ID IN NUMBER
11183: ,P_Partial_Copy_YN IN VARCHAR2
11184: ,P_Lines_Count IN NUMBER DEFAULT 0
11185: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

11183: ,P_Partial_Copy_YN IN VARCHAR2
11184: ,P_Lines_Count IN NUMBER DEFAULT 0
11185: ,x_return_status OUT NOCOPY VARCHAR2) IS
11186:
11187: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_ACTION_TIMES';
11188: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
11189: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
11190:
11191: CURSOR GetOksATFull IS

Line 11213: OKS_ACTION_TIMES oksAT

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

Line 11242: OKS_ACTION_TIMES oksAT

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

Line 11309: INSERT INTO OKS_ACTION_TIMES (

11305:
11306: End If;
11307:
11308: FORALL i IN OksATRecTab.OksAT_NewID.FIRST .. OksATRecTab.OksAT_NewID.LAST
11309: INSERT INTO OKS_ACTION_TIMES (
11310: ID
11311: ,COV_ACTION_TYPE_ID
11312: ,CLE_ID
11313: ,DNZ_CHR_ID

Line 11386: End copy_oks_action_times;

11382: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
11383: RAISE;
11384:
11385:
11386: End copy_oks_action_times;
11387:
11388: --------------------------------------------------------
11389: --===================================================
11390: -- copy_oks_k_sales_credits

Line 19887: --------------Copy of OKS_ACTION_TIMES-------------------------------

19883: RAISE G_EXCEPTION_HALT_VALIDATION;
19884: End If;
19885: End;
19886: ---------------------------------------------------------------------
19887: --------------Copy of OKS_ACTION_TIMES-------------------------------
19888: Begin
19889: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID
19890: ,P_To_Chr_ID => P_To_Chr_ID
19891: ,P_Partial_Copy_YN => 'N'

Line 19889: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID

19885: End;
19886: ---------------------------------------------------------------------
19887: --------------Copy of OKS_ACTION_TIMES-------------------------------
19888: Begin
19889: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID
19890: ,P_To_Chr_ID => P_To_Chr_ID
19891: ,P_Partial_Copy_YN => 'N'
19892: ,x_return_status => l_return_status);
19893:

Line 25298: --------------Copy of OKS_ACTION_TIMES-------------------------------

25294: RAISE G_EXCEPTION_HALT_VALIDATION;
25295: End If;
25296: End;
25297: ---------------------------------------------------------------------
25298: --------------Copy of OKS_ACTION_TIMES-------------------------------
25299: Begin
25300: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25301: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25302: FND_LOG.string(FND_LOG.level_statement

Line 25303: ,l_module_name||'.copy_oks_action_times'

25299: Begin
25300: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25301: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25302: FND_LOG.string(FND_LOG.level_statement
25303: ,l_module_name||'.copy_oks_action_times'
25304: ,'Before call to copy_oks_action_times'
25305: );
25306: END IF;
25307: END IF;

Line 25304: ,'Before call to copy_oks_action_times'

25300: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25301: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25302: FND_LOG.string(FND_LOG.level_statement
25303: ,l_module_name||'.copy_oks_action_times'
25304: ,'Before call to copy_oks_action_times'
25305: );
25306: END IF;
25307: END IF;
25308:

Line 25309: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID

25305: );
25306: END IF;
25307: END IF;
25308:
25309: copy_oks_action_times(P_From_Chr_ID => P_From_Chr_ID
25310: ,P_To_Chr_ID => P_To_Chr_ID
25311: ,P_Partial_Copy_YN => 'Y'
25312: ,P_Lines_Count => P_Lines_Tbl.COUNT
25313: ,x_return_status => l_return_status);

Line 25318: ,l_module_name||'.copy_oks_action_times'

25314:
25315: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25316: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25317: FND_LOG.string(FND_LOG.level_statement
25318: ,l_module_name||'.copy_oks_action_times'
25319: ,'After call to copy_oks_action_times: x_return_status:'||l_return_status
25320: ||' '||SQLERRM
25321: );
25322: END IF;

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

25315: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25316: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25317: FND_LOG.string(FND_LOG.level_statement
25318: ,l_module_name||'.copy_oks_action_times'
25319: ,'After call to copy_oks_action_times: x_return_status:'||l_return_status
25320: ||' '||SQLERRM
25321: );
25322: END IF;
25323: END IF;