DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_RELATE_VUHK dependencies on CN_ROLLUP_PVT

Line 50: l_srp cn_rollup_pvt.srp_group_rec_type;

46: l_end_date DATE;
47: l_group_name VARCHAR2(60);
48: l_action_link_id NUMBER;
49: l_roll_action_link_id NUMBER;
50: l_srp cn_rollup_pvt.srp_group_rec_type;
51: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
52: l_return_status VARCHAR2(30);
53: l_msg_count NUMBER;
54: l_msg_data VARCHAR2(256);

Line 51: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;

47: l_group_name VARCHAR2(60);
48: l_action_link_id NUMBER;
49: l_roll_action_link_id NUMBER;
50: l_srp cn_rollup_pvt.srp_group_rec_type;
51: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
52: l_return_status VARCHAR2(30);
53: l_msg_count NUMBER;
54: l_msg_data VARCHAR2(256);
55: l_api_name VARCHAR2(30) := 'update_res_group_relate_pre';

Line 162: cn_rollup_pvt.get_ancestor_salesrep

158:
159: l_srp.start_date := g_start_date_old;
160: l_srp.end_date := l_end_date;
161:
162: cn_rollup_pvt.get_ancestor_salesrep
163: ( p_api_version => 1.0,
164: p_init_msg_list => FND_API.G_false,
165: p_commit => FND_API.G_false,
166: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 240: cn_rollup_pvt.get_ancestor_salesrep

236:
237: l_srp.start_date := l_start_date;
238: l_srp.end_date := g_end_date_old;
239:
240: cn_rollup_pvt.get_ancestor_salesrep
241: ( p_api_version => 1.0,
242: p_init_msg_list => FND_API.G_false,
243: p_commit => FND_API.G_false,
244: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 345: l_srp cn_rollup_pvt.srp_group_rec_type;

341: l_end_date DATE;
342: l_group_name VARCHAR2(60);
343: l_action_link_id NUMBER;
344: p_action_link_id NUMBER;
345: l_srp cn_rollup_pvt.srp_group_rec_type;
346: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
347: l_return_status VARCHAR2(30);
348: l_msg_count NUMBER;
349: l_msg_data VARCHAR2(256);

Line 346: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;

342: l_group_name VARCHAR2(60);
343: l_action_link_id NUMBER;
344: p_action_link_id NUMBER;
345: l_srp cn_rollup_pvt.srp_group_rec_type;
346: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
347: l_return_status VARCHAR2(30);
348: l_msg_count NUMBER;
349: l_msg_data VARCHAR2(256);
350: l_group_id NUMBER;

Line 481: cn_rollup_pvt.get_ancestor_salesrep

477: l_srp.group_id := l_group_id;
478: l_srp.start_date := l_start_date;
479: l_srp.end_date := l_end_date;
480:
481: cn_rollup_pvt.get_ancestor_salesrep
482: ( p_api_version => 1.0,
483: p_init_msg_list => FND_API.G_false,
484: p_commit => FND_API.G_false,
485: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 571: l_srp cn_rollup_pvt.srp_group_rec_type;

567: l_end_date DATE;
568: l_group_name VARCHAR2(60);
569: l_action_link_id NUMBER;
570: p_action_link_id NUMBER;
571: l_srp cn_rollup_pvt.srp_group_rec_type;
572: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
573: l_return_status VARCHAR2(30);
574: l_msg_count NUMBER;
575: l_msg_data VARCHAR2(256);

Line 572: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;

568: l_group_name VARCHAR2(60);
569: l_action_link_id NUMBER;
570: p_action_link_id NUMBER;
571: l_srp cn_rollup_pvt.srp_group_rec_type;
572: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
573: l_return_status VARCHAR2(30);
574: l_msg_count NUMBER;
575: l_msg_data VARCHAR2(256);
576: l_dummy NUMBER;

Line 706: cn_rollup_pvt.get_ancestor_salesrep

702: l_srp.start_date := p_start_date_active;
703: l_srp.end_date := p_end_date_active;
704: l_srp.group_id := p_group_id;
705:
706: cn_rollup_pvt.get_ancestor_salesrep
707: ( p_api_version => 1.0,
708: p_init_msg_list => FND_API.G_false,
709: p_commit => FND_API.G_false,
710: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 793: l_srp cn_rollup_pvt.srp_group_rec_type;

789: l_start_date DATE;
790: l_end_date DATE;
791: l_action_link_id NUMBER;
792: p_action_link_id NUMBER;
793: l_srp cn_rollup_pvt.srp_group_rec_type;
794: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
795: l_return_status VARCHAR2(30);
796: l_msg_count NUMBER;
797: l_msg_data VARCHAR2(256);

Line 794: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;

790: l_end_date DATE;
791: l_action_link_id NUMBER;
792: p_action_link_id NUMBER;
793: l_srp cn_rollup_pvt.srp_group_rec_type;
794: l_srp_tbl cn_rollup_pvt.srp_group_tbl_type;
795: l_return_status VARCHAR2(30);
796: l_msg_count NUMBER;
797: l_msg_data VARCHAR2(256);
798: l_api_name VARCHAR2(30) := 'update_res_group_relate_post';

Line 880: cn_rollup_pvt.get_ancestor_salesrep

876:
877: l_srp.start_date := p_start_date_active;
878: l_srp.end_date := l_end_date;
879:
880: cn_rollup_pvt.get_ancestor_salesrep
881: ( p_api_version => 1.0,
882: p_init_msg_list => FND_API.G_false,
883: p_commit => FND_API.G_false,
884: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 943: cn_rollup_pvt.get_ancestor_salesrep

939:
940: l_srp.start_date := l_start_date;
941: l_srp.end_date := p_end_date_active;
942:
943: cn_rollup_pvt.get_ancestor_salesrep
944: ( p_api_version => 1.0,
945: p_init_msg_list => FND_API.G_false,
946: p_commit => FND_API.G_false,
947: p_validation_level => FND_API.G_VALID_LEVEL_FULL,