DBA Data[Home] [Help]

APPS.CN_CALC_SUBMISSION_PUB dependencies on JTF_USR_HKS

Line 1053: l_OAI_array JTF_USR_HKS.OAI_data_array_type;

1049: l_interval_type_id NUMBER;
1050: l_hierarchy_flag VARCHAR2(1);
1051:
1052: l_p_calc_submission_rec calc_submission_rec_type;
1053: l_OAI_array JTF_USR_HKS.OAI_data_array_type;
1054:
1055: l_salesreps_id_tbl salesrep_id_tbl_type;
1056: l_bonus_pe_id_tbl plan_element_id_tbl_type;
1057: l_user_id NUMBER;

Line 1137: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

1133:
1134: l_p_calc_submission_rec.org_id := g_org_id;
1135:
1136:
1137: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
1138: 'CREATE_CALC_SUBMISSION', 'B', 'C' ) then
1139:
1140: CN_CALC_SUBMISSION_CUHK.create_calc_submission_pre
1141: ( p_api_version => p_api_version,

Line 1158: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

1154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1155: end if;
1156: end if;
1157:
1158: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
1159: 'CREATE_CALC_SUBMISSION', 'B', 'V' ) then
1160: cn_calc_submission_VUHK.create_calc_submission_pre
1161: ( p_api_version => p_api_version,
1162: p_init_msg_list => p_init_msg_list,

Line 1399: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

1395: -- End of API body.
1396:
1397: /* Post processing */
1398: -- dbms_output.put_line('calling post processing API');
1399: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
1400: 'CREATE_CALC_SUBMISSION', 'A', 'V' ) then
1401: cn_calc_submission_VUHK.create_calc_submission_post
1402: ( p_api_version => p_api_version,
1403: p_init_msg_list => p_init_msg_list,

Line 1419: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

1415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1416: end if;
1417: end if;
1418:
1419: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
1420: 'CREATE_CALC_SUBMISSION', 'A', 'C' ) then
1421:
1422: CN_CALC_SUBMISSION_CUHK.create_calc_submission_post
1423: ( p_api_version => p_api_version,

Line 1441: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

1437: end if;
1438: end if;
1439:
1440: -- Following code is for message generation
1441: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
1442: 'CREATE_CALC_SUBMISSION', 'M', 'M' ) then
1443:
1444: IF ( CN_CALC_SUBMISSION_CUHK.ok_to_generate_msg
1445: ( p_calc_submission_rec => l_p_calc_submission_rec )

Line 1448: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

1444: IF ( CN_CALC_SUBMISSION_CUHK.ok_to_generate_msg
1445: ( p_calc_submission_rec => l_p_calc_submission_rec )
1446: ) THEN
1447:
1448: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1449: JTF_USR_HKS.Load_Bind_Data( l_bind_data_id, 'CALC_SUB_BATCH_ID',
1450: l_calc_sub_batch_id, 'S', 'N' );
1451:
1452: JTF_USR_HKS.generate_message( p_prod_code => 'CN',

Line 1449: JTF_USR_HKS.Load_Bind_Data( l_bind_data_id, 'CALC_SUB_BATCH_ID',

1445: ( p_calc_submission_rec => l_p_calc_submission_rec )
1446: ) THEN
1447:
1448: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1449: JTF_USR_HKS.Load_Bind_Data( l_bind_data_id, 'CALC_SUB_BATCH_ID',
1450: l_calc_sub_batch_id, 'S', 'N' );
1451:
1452: JTF_USR_HKS.generate_message( p_prod_code => 'CN',
1453: p_bus_obj_code => 'CALC_SUB',

Line 1452: JTF_USR_HKS.generate_message( p_prod_code => 'CN',

1448: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1449: JTF_USR_HKS.Load_Bind_Data( l_bind_data_id, 'CALC_SUB_BATCH_ID',
1450: l_calc_sub_batch_id, 'S', 'N' );
1451:
1452: JTF_USR_HKS.generate_message( p_prod_code => 'CN',
1453: p_bus_obj_code => 'CALC_SUB',
1454: p_bus_obj_name => 'CALC_SUBMISSION',
1455: p_action_code => 'I', -- Insert
1456: p_bind_data_id => l_bind_data_id,

Line 1633: l_OAI_array JTF_USR_HKS.OAI_data_array_type;

1629: l_interval_type_id NUMBER;
1630: l_hierarchy_flag VARCHAR2(1);
1631:
1632: l_p_calc_submission_rec calc_submission_rec_type;
1633: l_OAI_array JTF_USR_HKS.OAI_data_array_type;
1634:
1635: l_salesreps_id_tbl salesrep_id_tbl_type;
1636: l_bonus_pe_id_tbl plan_element_id_tbl_type;
1637: l_user_id NUMBER;

Line 1761: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

1757: l_p_calc_submission_rec := p_calc_submission_rec_new;
1758: l_p_calc_submission_rec.org_id := g_org_id;
1759:
1760: --dbms_output.put_line('Going into pre processing ');
1761: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
1762: 'CREATE_CALC_SUBMISSION', 'B', 'C' ) then
1763:
1764: CN_CALC_SUBMISSION_CUHK.create_calc_submission_pre
1765: ( p_api_version => p_api_version,

Line 1782: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

1778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1779: end if;
1780: end if;
1781:
1782: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
1783: 'CREATE_CALC_SUBMISSION', 'B', 'V' ) then
1784: cn_calc_submission_VUHK.create_calc_submission_pre
1785: ( p_api_version => p_api_version,
1786: p_init_msg_list => p_init_msg_list,

Line 2313: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

2309: -- End of API body.
2310:
2311: /* Post processing */
2312: --dbms_output.put_line('calling post processing API x_loading_status is ' || x_loading_status);
2313: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
2314: 'CREATE_CALC_SUBMISSION', 'A', 'V' ) then
2315: cn_calc_submission_VUHK.create_calc_submission_post
2316: ( p_api_version => p_api_version,
2317: p_init_msg_list => p_init_msg_list,

Line 2335: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

2331: end if;
2332:
2333: --dbms_output.put_line('vertical post processing API x_loading_status is ' || x_loading_status);
2334:
2335: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
2336: 'CREATE_CALC_SUBMISSION', 'A', 'C' ) then
2337:
2338: CN_CALC_SUBMISSION_CUHK.create_calc_submission_post
2339: ( p_api_version => p_api_version,

Line 2357: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',

2353: end if;
2354: end if;
2355:
2356: -- Following code is for message generation
2357: if JTF_USR_HKS.Ok_to_Execute( 'CN_CALC_SUBMISSION_PUB',
2358: 'CREATE_CALC_SUBMISSION', 'M', 'M' ) then
2359:
2360: IF ( CN_CALC_SUBMISSION_CUHK.ok_to_generate_msg
2361: ( p_calc_submission_rec => l_p_calc_submission_rec )

Line 2364: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

2360: IF ( CN_CALC_SUBMISSION_CUHK.ok_to_generate_msg
2361: ( p_calc_submission_rec => l_p_calc_submission_rec )
2362: ) THEN
2363:
2364: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
2365: JTF_USR_HKS.Load_Bind_Data( l_bind_data_id, 'CALC_SUB_BATCH_ID',
2366: l_calc_sub_batch_id, 'S', 'N' );
2367:
2368: JTF_USR_HKS.generate_message( p_prod_code => 'CN',

Line 2365: JTF_USR_HKS.Load_Bind_Data( l_bind_data_id, 'CALC_SUB_BATCH_ID',

2361: ( p_calc_submission_rec => l_p_calc_submission_rec )
2362: ) THEN
2363:
2364: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
2365: JTF_USR_HKS.Load_Bind_Data( l_bind_data_id, 'CALC_SUB_BATCH_ID',
2366: l_calc_sub_batch_id, 'S', 'N' );
2367:
2368: JTF_USR_HKS.generate_message( p_prod_code => 'CN',
2369: p_bus_obj_code => 'CALC_SUB',

Line 2368: JTF_USR_HKS.generate_message( p_prod_code => 'CN',

2364: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
2365: JTF_USR_HKS.Load_Bind_Data( l_bind_data_id, 'CALC_SUB_BATCH_ID',
2366: l_calc_sub_batch_id, 'S', 'N' );
2367:
2368: JTF_USR_HKS.generate_message( p_prod_code => 'CN',
2369: p_bus_obj_code => 'CALC_SUB',
2370: p_bus_obj_name => 'CALC_SUBMISSION',
2371: p_action_code => 'U', -- update
2372: p_bind_data_id => l_bind_data_id,