eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_DC_OBJECTS_PVT dependencies on ZPB_DC_OBJECTS

Line 1: PACKAGE BODY ZPB_DC_OBJECTS_PVT AS

1: PACKAGE BODY ZPB_DC_OBJECTS_PVT AS
2: /* $Header: ZPBDCGTB.pls 120.10 2008/01/24 09:57:46 maniskum ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ZPB_DC_OBJECTS_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ZPB_DC_OBJECTS_PVT';

1: PACKAGE BODY ZPB_DC_OBJECTS_PVT AS
2: /* $Header: ZPBDCGTB.pls 120.10 2008/01/24 09:57:46 maniskum ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ZPB_DC_OBJECTS_PVT';
5:
6:
7: /*---------------------------Private Procedure-----------------------------*/
8: /*=========================================================================+

Line 64: from ZPB_DC_OBJECTS A,

60: -- Get the Business Area ID for the object in question
61: --
62: select B.BUSINESS_AREA_ID, A.TEMPLATE_ID
63: into l_business_area_id , l_template_id
64: from ZPB_DC_OBJECTS A,
65: ZPB_ANALYSIS_CYCLES B
66: where A.OBJECT_ID = p_object_id
67: and A.AC_INSTANCE_ID = B.ANALYSIS_CYCLE_ID;
68:

Line 70: from ZPB_DC_OBJECTS

66: where A.OBJECT_ID = p_object_id
67: and A.AC_INSTANCE_ID = B.ANALYSIS_CYCLE_ID;
68:
69: select OBJECT_ID into l_master_object_id
70: from ZPB_DC_OBJECTS
71: where TEMPLATE_ID = l_template_id
72: and OBJECT_TYPE = 'M';
73:
74:

Line 321: FROM ZPB_DC_OBJECTS

317: DEADLINE_DATE ,
318: APPROVAL_REQUIRED_FLAG ,
319: ENABLE_TARGET_FLAG ,
320: CREATE_INSTANCE_MEASURES_FLAG
321: FROM ZPB_DC_OBJECTS
322: WHERE TEMPLATE_ID = p_template_id
323: AND OBJECT_TYPE = 'M';
324: BEGIN
325: -- Populate the layout and properties to all ws for this template

Line 329: UPDATE ZPB_DC_OBJECTS

325: -- Populate the layout and properties to all ws for this template
326: FOR l_dist_template_row_rec IN dist_template_csr
327: LOOP
328: IF (p_overwrite_cust = 'OVERWRITE') THEN
329: UPDATE ZPB_DC_OBJECTS
330: SET TEMPLATE_NAME = l_dist_template_row_rec.template_name,
331: DISTRIBUTION_DATE = SYSDATE,
332: DATAENTRY_OBJ_PATH = l_dist_template_row_rec.dataentry_obj_path,
333: DATAENTRY_OBJ_NAME = l_dist_template_row_rec.dataentry_obj_name,

Line 401: l_template_type zpb_dc_objects.object_type%TYPE;

397: p_business_area_id IN NUMBER,
398: p_multiple_submissions_flag IN VARCHAR2
399: )
400: IS
401: l_template_type zpb_dc_objects.object_type%TYPE;
402: l_status zpb_dc_objects.status%TYPE;
403: l_approver_type zpb_dc_objects.approver_type%TYPE;
404: l_instance_flag VARCHAR2(20);
405: l_copy_target_data_flag VARCHAR2(1);

Line 402: l_status zpb_dc_objects.status%TYPE;

398: p_multiple_submissions_flag IN VARCHAR2
399: )
400: IS
401: l_template_type zpb_dc_objects.object_type%TYPE;
402: l_status zpb_dc_objects.status%TYPE;
403: l_approver_type zpb_dc_objects.approver_type%TYPE;
404: l_instance_flag VARCHAR2(20);
405: l_copy_target_data_flag VARCHAR2(1);
406:

Line 403: l_approver_type zpb_dc_objects.approver_type%TYPE;

399: )
400: IS
401: l_template_type zpb_dc_objects.object_type%TYPE;
402: l_status zpb_dc_objects.status%TYPE;
403: l_approver_type zpb_dc_objects.approver_type%TYPE;
404: l_instance_flag VARCHAR2(20);
405: l_copy_target_data_flag VARCHAR2(1);
406:
407: --PRAGMA autonomous_transaction;

Line 421: UPDATE ZPB_DC_OBJECTS

417:
418: -- Update 'M' template with changes in 'E' for manual dist --
419: IF (p_distribute_type = 'MANUAL' and p_object_type = 'E') THEN
420:
421: UPDATE ZPB_DC_OBJECTS
422: SET TEMPLATE_NAME = p_template_name,
423: DESCRIPTION = p_description,
424: DATAENTRY_OBJ_PATH = p_dataentry_obj_path,
425: -- These 2 lines are commented out because they are already updated

Line 450: UPDATE ZPB_DC_OBJECTS

446: END IF;
447:
448: IF (p_object_type <> 'W') THEN
449: -- Ater the distribution, the status of templates changes --
450: UPDATE ZPB_DC_OBJECTS
451: SET STATUS = 'DISTRIBUTED',
452: DISTRIBUTION_DATE = SYSDATE,
453: LAST_UPDATED_BY = fnd_global.USER_ID,
454: LAST_UPDATE_DATE = SYSDATE,

Line 467: FOR c1 in (SELECT 1 from zpb_dc_objects WHERE object_id = p_object_id

463: l_instance_flag := 'Y';
464: ELSE
465: l_instance_flag := 'N';
466: END IF;
467: FOR c1 in (SELECT 1 from zpb_dc_objects WHERE object_id = p_object_id
468: and create_instance_measures_flag = 'Y')
469: LOOP
470: l_instance_flag := 'Y';
471: END LOOP;

Line 487: INSERT INTO ZPB_DC_OBJECTS (

483: Populate_Distributors(
484: p_object_id => p_object_id,
485: p_distributor_user_id => p_distributor_user_id,
486: p_approver_type => l_approver_type);
487: INSERT INTO ZPB_DC_OBJECTS (
488: OBJECT_ID ,
489: TEMPLATE_ID ,
490: AC_TEMPLATE_ID ,
491: ANALYSIS_CYCLE_ID ,

Line 584: UPDATE ZPB_DC_OBJECTS

580: LAST_UPDATE_DATE = SYSDATE,
581: CREATED_BY = fnd_global.user_id,
582: CREATION_DATE = SYSDATE
583: WHERE object_id = p_object_id;
584: UPDATE ZPB_DC_OBJECTS
585: SET DISTRIBUTOR_USER_ID = p_distributor_user_id,
586: DISTRIBUTION_DATE = SYSDATE,
587: -- data overwrite or not
588: DEADLINE_DATE = p_deadline_date,

Line 677: | then creates 3 records in ZPB_DC_OBJECTS - one as the

673: | PROCEDURE Generate_Template
674: |
675: | DESCRIPTION
676: | Procedure retrieves parameters defined in Generate Template Task,
677: | then creates 3 records in ZPB_DC_OBJECTS - one as the
678: | read-only master version, one as an editable template v
679: | for controller to edit layout and other template properties and data
680: | and one for controller to edit worksheet data and target plus layout.
681: | Procedure also creates an empty record for instruction text as well.

Line 707: l_template_id zpb_dc_objects.template_id%TYPE;

703:
704: l_param_name zpb_task_parameters.name%TYPE;
705: l_param_value zpb_task_parameters.value%TYPE;
706: l_instance_name zpb_analysis_cycle_instances.instance_description%TYPE;
707: l_template_id zpb_dc_objects.template_id%TYPE;
708: l_ac_template_id zpb_dc_objects.ac_template_id%TYPE;
709: l_object_m_id zpb_dc_objects.object_id%TYPE;
710: l_object_e_id zpb_dc_objects.object_id%TYPE;
711: l_object_c_id zpb_dc_objects.object_id%TYPE;

Line 708: l_ac_template_id zpb_dc_objects.ac_template_id%TYPE;

704: l_param_name zpb_task_parameters.name%TYPE;
705: l_param_value zpb_task_parameters.value%TYPE;
706: l_instance_name zpb_analysis_cycle_instances.instance_description%TYPE;
707: l_template_id zpb_dc_objects.template_id%TYPE;
708: l_ac_template_id zpb_dc_objects.ac_template_id%TYPE;
709: l_object_m_id zpb_dc_objects.object_id%TYPE;
710: l_object_e_id zpb_dc_objects.object_id%TYPE;
711: l_object_c_id zpb_dc_objects.object_id%TYPE;
712: l_template_name zpb_dc_objects.template_name%TYPE;

Line 709: l_object_m_id zpb_dc_objects.object_id%TYPE;

705: l_param_value zpb_task_parameters.value%TYPE;
706: l_instance_name zpb_analysis_cycle_instances.instance_description%TYPE;
707: l_template_id zpb_dc_objects.template_id%TYPE;
708: l_ac_template_id zpb_dc_objects.ac_template_id%TYPE;
709: l_object_m_id zpb_dc_objects.object_id%TYPE;
710: l_object_e_id zpb_dc_objects.object_id%TYPE;
711: l_object_c_id zpb_dc_objects.object_id%TYPE;
712: l_template_name zpb_dc_objects.template_name%TYPE;
713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;

Line 710: l_object_e_id zpb_dc_objects.object_id%TYPE;

706: l_instance_name zpb_analysis_cycle_instances.instance_description%TYPE;
707: l_template_id zpb_dc_objects.template_id%TYPE;
708: l_ac_template_id zpb_dc_objects.ac_template_id%TYPE;
709: l_object_m_id zpb_dc_objects.object_id%TYPE;
710: l_object_e_id zpb_dc_objects.object_id%TYPE;
711: l_object_c_id zpb_dc_objects.object_id%TYPE;
712: l_template_name zpb_dc_objects.template_name%TYPE;
713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;
714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;

Line 711: l_object_c_id zpb_dc_objects.object_id%TYPE;

707: l_template_id zpb_dc_objects.template_id%TYPE;
708: l_ac_template_id zpb_dc_objects.ac_template_id%TYPE;
709: l_object_m_id zpb_dc_objects.object_id%TYPE;
710: l_object_e_id zpb_dc_objects.object_id%TYPE;
711: l_object_c_id zpb_dc_objects.object_id%TYPE;
712: l_template_name zpb_dc_objects.template_name%TYPE;
713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;
714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;
715: l_target_path zpb_dc_objects.target_obj_path%TYPE;

Line 712: l_template_name zpb_dc_objects.template_name%TYPE;

708: l_ac_template_id zpb_dc_objects.ac_template_id%TYPE;
709: l_object_m_id zpb_dc_objects.object_id%TYPE;
710: l_object_e_id zpb_dc_objects.object_id%TYPE;
711: l_object_c_id zpb_dc_objects.object_id%TYPE;
712: l_template_name zpb_dc_objects.template_name%TYPE;
713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;
714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;
715: l_target_path zpb_dc_objects.target_obj_path%TYPE;
716: l_target_name zpb_dc_objects.target_obj_name%TYPE;

Line 713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;

709: l_object_m_id zpb_dc_objects.object_id%TYPE;
710: l_object_e_id zpb_dc_objects.object_id%TYPE;
711: l_object_c_id zpb_dc_objects.object_id%TYPE;
712: l_template_name zpb_dc_objects.template_name%TYPE;
713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;
714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;
715: l_target_path zpb_dc_objects.target_obj_path%TYPE;
716: l_target_name zpb_dc_objects.target_obj_name%TYPE;
717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;

Line 714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;

710: l_object_e_id zpb_dc_objects.object_id%TYPE;
711: l_object_c_id zpb_dc_objects.object_id%TYPE;
712: l_template_name zpb_dc_objects.template_name%TYPE;
713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;
714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;
715: l_target_path zpb_dc_objects.target_obj_path%TYPE;
716: l_target_name zpb_dc_objects.target_obj_name%TYPE;
717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;
718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;

Line 715: l_target_path zpb_dc_objects.target_obj_path%TYPE;

711: l_object_c_id zpb_dc_objects.object_id%TYPE;
712: l_template_name zpb_dc_objects.template_name%TYPE;
713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;
714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;
715: l_target_path zpb_dc_objects.target_obj_path%TYPE;
716: l_target_name zpb_dc_objects.target_obj_name%TYPE;
717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;
718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;
719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;

Line 716: l_target_name zpb_dc_objects.target_obj_name%TYPE;

712: l_template_name zpb_dc_objects.template_name%TYPE;
713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;
714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;
715: l_target_path zpb_dc_objects.target_obj_path%TYPE;
716: l_target_name zpb_dc_objects.target_obj_name%TYPE;
717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;
718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;
719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;
720: l_dist_method zpb_dc_objects.distribution_method%TYPE;

Line 717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;

713: l_dataentry_path zpb_dc_objects.dataentry_obj_path%TYPE;
714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;
715: l_target_path zpb_dc_objects.target_obj_path%TYPE;
716: l_target_name zpb_dc_objects.target_obj_name%TYPE;
717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;
718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;
719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;
720: l_dist_method zpb_dc_objects.distribution_method%TYPE;
721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;

Line 718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;

714: l_dataentry_name zpb_dc_objects.dataentry_obj_name%TYPE;
715: l_target_path zpb_dc_objects.target_obj_path%TYPE;
716: l_target_name zpb_dc_objects.target_obj_name%TYPE;
717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;
718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;
719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;
720: l_dist_method zpb_dc_objects.distribution_method%TYPE;
721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;
722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;

Line 719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;

715: l_target_path zpb_dc_objects.target_obj_path%TYPE;
716: l_target_name zpb_dc_objects.target_obj_name%TYPE;
717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;
718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;
719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;
720: l_dist_method zpb_dc_objects.distribution_method%TYPE;
721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;
722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;
723: l_review_complete_flag zpb_dc_objects.review_complete_flag%TYPE;

Line 720: l_dist_method zpb_dc_objects.distribution_method%TYPE;

716: l_target_name zpb_dc_objects.target_obj_name%TYPE;
717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;
718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;
719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;
720: l_dist_method zpb_dc_objects.distribution_method%TYPE;
721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;
722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;
723: l_review_complete_flag zpb_dc_objects.review_complete_flag%TYPE;
724: l_enable_target_flag zpb_dc_objects.enable_target_flag%TYPE;

Line 721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;

717: l_use_last_reviewed zpb_dc_objects.use_last_reviewed%TYPE;
718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;
719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;
720: l_dist_method zpb_dc_objects.distribution_method%TYPE;
721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;
722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;
723: l_review_complete_flag zpb_dc_objects.review_complete_flag%TYPE;
724: l_enable_target_flag zpb_dc_objects.enable_target_flag%TYPE;
725: l_copy_target_data_flag zpb_dc_objects.copy_target_data_flag%TYPE;

Line 722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;

718: l_dist_dim zpb_dc_objects.distribution_dimension%TYPE;
719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;
720: l_dist_method zpb_dc_objects.distribution_method%TYPE;
721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;
722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;
723: l_review_complete_flag zpb_dc_objects.review_complete_flag%TYPE;
724: l_enable_target_flag zpb_dc_objects.enable_target_flag%TYPE;
725: l_copy_target_data_flag zpb_dc_objects.copy_target_data_flag%TYPE;
726: l_status zpb_dc_objects.status%TYPE;

Line 723: l_review_complete_flag zpb_dc_objects.review_complete_flag%TYPE;

719: l_dist_hier zpb_dc_objects.distribution_hierarchy%TYPE;
720: l_dist_method zpb_dc_objects.distribution_method%TYPE;
721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;
722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;
723: l_review_complete_flag zpb_dc_objects.review_complete_flag%TYPE;
724: l_enable_target_flag zpb_dc_objects.enable_target_flag%TYPE;
725: l_copy_target_data_flag zpb_dc_objects.copy_target_data_flag%TYPE;
726: l_status zpb_dc_objects.status%TYPE;
727: l_short_instr_text zpb_dc_instruction_text.short_text%TYPE;

Line 724: l_enable_target_flag zpb_dc_objects.enable_target_flag%TYPE;

720: l_dist_method zpb_dc_objects.distribution_method%TYPE;
721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;
722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;
723: l_review_complete_flag zpb_dc_objects.review_complete_flag%TYPE;
724: l_enable_target_flag zpb_dc_objects.enable_target_flag%TYPE;
725: l_copy_target_data_flag zpb_dc_objects.copy_target_data_flag%TYPE;
726: l_status zpb_dc_objects.status%TYPE;
727: l_short_instr_text zpb_dc_instruction_text.short_text%TYPE;
728: l_viewType zpb_dc_objects.view_type%TYPE;

Line 725: l_copy_target_data_flag zpb_dc_objects.copy_target_data_flag%TYPE;

721: l_approval_req_flag zpb_dc_objects.approval_required_flag%TYPE;
722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;
723: l_review_complete_flag zpb_dc_objects.review_complete_flag%TYPE;
724: l_enable_target_flag zpb_dc_objects.enable_target_flag%TYPE;
725: l_copy_target_data_flag zpb_dc_objects.copy_target_data_flag%TYPE;
726: l_status zpb_dc_objects.status%TYPE;
727: l_short_instr_text zpb_dc_instruction_text.short_text%TYPE;
728: l_viewType zpb_dc_objects.view_type%TYPE;
729: l_currency_flag zpb_dc_objects.currency_flag%TYPE;

Line 726: l_status zpb_dc_objects.status%TYPE;

722: l_wait_review_flag zpb_dc_objects.wait_for_review_flag%TYPE;
723: l_review_complete_flag zpb_dc_objects.review_complete_flag%TYPE;
724: l_enable_target_flag zpb_dc_objects.enable_target_flag%TYPE;
725: l_copy_target_data_flag zpb_dc_objects.copy_target_data_flag%TYPE;
726: l_status zpb_dc_objects.status%TYPE;
727: l_short_instr_text zpb_dc_instruction_text.short_text%TYPE;
728: l_viewType zpb_dc_objects.view_type%TYPE;
729: l_currency_flag zpb_dc_objects.currency_flag%TYPE;
730: l_bus_area_id zpb_dc_objects.business_area_id%TYPE;

Line 728: l_viewType zpb_dc_objects.view_type%TYPE;

724: l_enable_target_flag zpb_dc_objects.enable_target_flag%TYPE;
725: l_copy_target_data_flag zpb_dc_objects.copy_target_data_flag%TYPE;
726: l_status zpb_dc_objects.status%TYPE;
727: l_short_instr_text zpb_dc_instruction_text.short_text%TYPE;
728: l_viewType zpb_dc_objects.view_type%TYPE;
729: l_currency_flag zpb_dc_objects.currency_flag%TYPE;
730: l_bus_area_id zpb_dc_objects.business_area_id%TYPE;
731: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
732:

Line 729: l_currency_flag zpb_dc_objects.currency_flag%TYPE;

725: l_copy_target_data_flag zpb_dc_objects.copy_target_data_flag%TYPE;
726: l_status zpb_dc_objects.status%TYPE;
727: l_short_instr_text zpb_dc_instruction_text.short_text%TYPE;
728: l_viewType zpb_dc_objects.view_type%TYPE;
729: l_currency_flag zpb_dc_objects.currency_flag%TYPE;
730: l_bus_area_id zpb_dc_objects.business_area_id%TYPE;
731: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
732:
733: l_ac_count NUMBER;

Line 730: l_bus_area_id zpb_dc_objects.business_area_id%TYPE;

726: l_status zpb_dc_objects.status%TYPE;
727: l_short_instr_text zpb_dc_instruction_text.short_text%TYPE;
728: l_viewType zpb_dc_objects.view_type%TYPE;
729: l_currency_flag zpb_dc_objects.currency_flag%TYPE;
730: l_bus_area_id zpb_dc_objects.business_area_id%TYPE;
731: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
732:
733: l_ac_count NUMBER;
734: l_view_value VARCHAR2(100);

Line 731: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;

727: l_short_instr_text zpb_dc_instruction_text.short_text%TYPE;
728: l_viewType zpb_dc_objects.view_type%TYPE;
729: l_currency_flag zpb_dc_objects.currency_flag%TYPE;
730: l_bus_area_id zpb_dc_objects.business_area_id%TYPE;
731: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
732:
733: l_ac_count NUMBER;
734: l_view_value VARCHAR2(100);
735: l_currency_param_id NUMBER;

Line 905: FROM zpb_dc_objects

901: /* Only when a bp already has a template does 'user last
902: reviewed' hold true */
903: /* SELECT count(*)
904: INTO l_ac_count
905: FROM zpb_dc_objects
906: WHERE analysis_cycle_id = p_ac_id
907: AND ac_template_id = l_ac_template_id;*/
908:
909: /* IF (l_ac_count <> 0) THEN

Line 912: FROM zpb_dc_objects

908:
909: /* IF (l_ac_count <> 0) THEN
910: SELECT max(ac_instance_id)
911: INTO l_last_ac_id
912: FROM zpb_dc_objects
913: WHERE analysis_cycle_id = p_ac_id
914: AND ac_template_id = l_ac_template_id;*/
915:
916: /* IF (l_ac_count <> 0) THEN*/

Line 949: FROM zpb_dc_objects

945:
946: /* IF (l_count_changed_dim = 0)THEN
947: SELECT dataentry_obj_name, target_obj_name
948: INTO l_dataentry_name, l_target_name
949: FROM zpb_dc_objects
950: WHERE object_type = 'M'
951: AND ac_template_id = l_ac_template_id
952: AND ac_instance_id IN
953: (SELECT max(ac_instance_id)

Line 954: FROM zpb_dc_objects

950: WHERE object_type = 'M'
951: AND ac_template_id = l_ac_template_id
952: AND ac_instance_id IN
953: (SELECT max(ac_instance_id)
954: FROM zpb_dc_objects
955: WHERE analysis_cycle_id = p_ac_id
956: AND ac_template_id = l_ac_template_id);
957: END IF;
958: END IF;

Line 965: FROM zpb_dc_objects

961:
962: IF (l_count_changed_dim = 0)THEN
963: -- ensure there is a master records to copy from
964: SELECT count(*) INTO l_master_exists
965: FROM zpb_dc_objects
966: WHERE object_type = 'M'
967: AND ac_template_id = l_ac_template_id
968: AND analysis_cycle_id = l_last_ac_id;
969:

Line 974: FROM zpb_dc_objects

970: IF (l_master_exists > 0)THEN
971: SELECT
972: dataentry_obj_path,dataentry_obj_name,target_obj_path,target_obj_name
973: INTO l_dataentry_path,l_dataentry_name,l_target_path,l_target_name
974: FROM zpb_dc_objects
975: WHERE object_type = 'M'
976: AND ac_template_id = l_ac_template_id
977: AND analysis_cycle_id = l_last_ac_id;
978: END IF;

Line 991: INSERT INTO ZPB_DC_OBJECTS (

987:
988: l_short_instr_text := '';
989: /* Insert a record for the Master Template,
990: this template is updated when distribute and submit, the changes from E template*/
991: INSERT INTO ZPB_DC_OBJECTS (
992: OBJECT_ID,
993: TEMPLATE_ID,
994: AC_TEMPLATE_ID,
995: ANALYSIS_CYCLE_ID,

Line 1099: INSERT INTO ZPB_DC_OBJECTS (

1095:
1096: /* Generate an editable version of the template.
1097: controller make changes then distribute. so the changes be copied
1098: to M template when distribute*/
1099: INSERT INTO ZPB_DC_OBJECTS (
1100: OBJECT_ID,
1101: TEMPLATE_ID,
1102: AC_TEMPLATE_ID,
1103: ANALYSIS_CYCLE_ID,

Line 1208: INSERT INTO ZPB_DC_OBJECTS (

1204:
1205:
1206: /* Generate a controller worksheet, need to set measures flag
1207: for him to work on his own ws */
1208: INSERT INTO ZPB_DC_OBJECTS (
1209: OBJECT_ID,
1210: TEMPLATE_ID,
1211: AC_TEMPLATE_ID,
1212: ANALYSIS_CYCLE_ID,

Line 1425: l_approver_type zpb_dc_objects.approver_type%TYPE;

1421: l_distributor_user_id NUMBER;
1422: l_param_name zpb_task_parameters.name%TYPE;
1423: l_param_value zpb_task_parameters.value%TYPE;
1424: l_recipient_type zpb_task_parameters.value%TYPE;
1425: l_approver_type zpb_dc_objects.approver_type%TYPE;
1426: l_object_type zpb_dc_objects.object_type%TYPE;
1427: l_wait_for_review VARCHAR2(1);
1428: l_review_complete_flag VARCHAR2(1);
1429: l_deadline_date DATE;

Line 1426: l_object_type zpb_dc_objects.object_type%TYPE;

1422: l_param_name zpb_task_parameters.name%TYPE;
1423: l_param_value zpb_task_parameters.value%TYPE;
1424: l_recipient_type zpb_task_parameters.value%TYPE;
1425: l_approver_type zpb_dc_objects.approver_type%TYPE;
1426: l_object_type zpb_dc_objects.object_type%TYPE;
1427: l_wait_for_review VARCHAR2(1);
1428: l_review_complete_flag VARCHAR2(1);
1429: l_deadline_date DATE;
1430: l_deadline_type VARCHAR2(10);

Line 1482: FROM ZPB_DC_OBJECTS

1478: CURRENCY_FLAG,
1479: VIEW_TYPE,
1480: BUSINESS_AREA_ID,
1481: MULTIPLE_SUBMISSIONS_FLAG
1482: FROM ZPB_DC_OBJECTS
1483: WHERE TEMPLATE_ID = p_template_id
1484: AND OBJECT_TYPE = 'M';
1485:
1486: -- Get all the specified users from the task param table

Line 1496: FROM ZPB_DC_OBJECTS

1492:
1493: -- Check whether a specific user was distributed to
1494: CURSOR check_exist_csr IS
1495: SELECT count(*)
1496: FROM ZPB_DC_OBJECTS
1497: WHERE TEMPLATE_ID = p_template_id
1498: AND OBJECT_USER_ID = l_user_id;
1499:
1500: BEGIN

Line 1571: FROM zpb_dc_objects

1567:
1568: -- Call the following api to get the clob of user ids comma separated
1569: SELECT object_id, object_user_id, wait_for_review_flag, review_complete_flag
1570: INTO l_object_id, l_object_user_id, l_wait_for_review, l_review_complete_flag
1571: FROM zpb_dc_objects
1572: WHERE template_id = p_template_id
1573: AND object_type = 'M';
1574:
1575: /* Only the controller can distribute ws automatically

Line 1915: l_object_type zpb_dc_objects.object_type%TYPE;

1911: l_template_id NUMBER;
1912: l_object_id NUMBER;
1913: l_object_user_id NUMBER;
1914: l_deadline_date DATE;
1915: l_object_type zpb_dc_objects.object_type%TYPE;
1916: l_template_name zpb_dc_objects.template_name%TYPE;
1917: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;
1918: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;
1919: l_data_obj_path zpb_dc_objects.dataentry_obj_path%TYPE;

Line 1916: l_template_name zpb_dc_objects.template_name%TYPE;

1912: l_object_id NUMBER;
1913: l_object_user_id NUMBER;
1914: l_deadline_date DATE;
1915: l_object_type zpb_dc_objects.object_type%TYPE;
1916: l_template_name zpb_dc_objects.template_name%TYPE;
1917: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;
1918: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;
1919: l_data_obj_path zpb_dc_objects.dataentry_obj_path%TYPE;
1920: l_target_obj_path zpb_dc_objects.target_obj_path%TYPE;

Line 1917: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;

1913: l_object_user_id NUMBER;
1914: l_deadline_date DATE;
1915: l_object_type zpb_dc_objects.object_type%TYPE;
1916: l_template_name zpb_dc_objects.template_name%TYPE;
1917: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;
1918: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;
1919: l_data_obj_path zpb_dc_objects.dataentry_obj_path%TYPE;
1920: l_target_obj_path zpb_dc_objects.target_obj_path%TYPE;
1921: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;

Line 1918: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;

1914: l_deadline_date DATE;
1915: l_object_type zpb_dc_objects.object_type%TYPE;
1916: l_template_name zpb_dc_objects.template_name%TYPE;
1917: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;
1918: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;
1919: l_data_obj_path zpb_dc_objects.dataentry_obj_path%TYPE;
1920: l_target_obj_path zpb_dc_objects.target_obj_path%TYPE;
1921: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
1922: l_user_id NUMBER;

Line 1919: l_data_obj_path zpb_dc_objects.dataentry_obj_path%TYPE;

1915: l_object_type zpb_dc_objects.object_type%TYPE;
1916: l_template_name zpb_dc_objects.template_name%TYPE;
1917: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;
1918: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;
1919: l_data_obj_path zpb_dc_objects.dataentry_obj_path%TYPE;
1920: l_target_obj_path zpb_dc_objects.target_obj_path%TYPE;
1921: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
1922: l_user_id NUMBER;
1923: l_user zpb_task_parameters.value%TYPE;

Line 1920: l_target_obj_path zpb_dc_objects.target_obj_path%TYPE;

1916: l_template_name zpb_dc_objects.template_name%TYPE;
1917: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;
1918: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;
1919: l_data_obj_path zpb_dc_objects.dataentry_obj_path%TYPE;
1920: l_target_obj_path zpb_dc_objects.target_obj_path%TYPE;
1921: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
1922: l_user_id NUMBER;
1923: l_user zpb_task_parameters.value%TYPE;
1924: l_insert_type VARCHAR2(10);

Line 1921: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;

1917: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;
1918: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;
1919: l_data_obj_path zpb_dc_objects.dataentry_obj_path%TYPE;
1920: l_target_obj_path zpb_dc_objects.target_obj_path%TYPE;
1921: l_multiple_submissions_flag zpb_dc_objects.multiple_submissions_flag%TYPE;
1922: l_user_id NUMBER;
1923: l_user zpb_task_parameters.value%TYPE;
1924: l_insert_type VARCHAR2(10);
1925: l_distribute_type VARCHAR2(10);

Line 1946: FROM zpb_dc_objects

1942: CURSOR template_info_csr IS
1943: SELECT template_id,
1944: object_user_id,
1945: object_type
1946: FROM zpb_dc_objects
1947: WHERE object_id = p_object_id;
1948:
1949: -- Analyst distributes his ws in cascade distribution
1950: CURSOR dist_worksheet_csr IS

Line 1975: FROM ZPB_DC_OBJECTS

1971: CURRENCY_FLAG,
1972: VIEW_TYPE,
1973: BUSINESS_AREA_ID,
1974: MULTIPLE_SUBMISSIONS_FLAG
1975: FROM ZPB_DC_OBJECTS
1976: WHERE TEMPLATE_ID = l_template_id
1977: AND OBJECT_TYPE = 'M';
1978:
1979: -- Get all the specified users from the task param table

Line 1988: FROM ZPB_DC_OBJECTS

1984:
1985: -- Check whether a specific user was distributed to
1986: CURSOR check_exist_csr IS
1987: SELECT count(*)
1988: FROM ZPB_DC_OBJECTS
1989: WHERE TEMPLATE_ID = l_template_id
1990: AND OBJECT_USER_ID = l_user_id;
1991:
1992: BEGIN

Line 2099: FROM ZPB_DC_OBJECTS

2095: ELSIF (l_count > 0) THEN -- distributed before
2096: l_insert_type := 'Update';
2097: SELECT object_id
2098: INTO l_object_id
2099: FROM ZPB_DC_OBJECTS
2100: WHERE TEMPLATE_ID = l_template_id
2101: AND OBJECT_USER_ID = l_user_id;
2102: END IF; -- count = or > 0
2103:

Line 2189: FROM ZPB_DC_OBJECTS

2185: ELSIF (l_count > 0) THEN
2186: l_insert_type := 'Update';
2187: SELECT object_id
2188: INTO l_object_id
2189: FROM ZPB_DC_OBJECTS
2190: WHERE TEMPLATE_ID = l_template_id
2191: AND OBJECT_USER_ID = l_user_id;
2192:
2193: END IF; -- l_count

Line 2314: FROM zpb_dc_objects obj, fnd_user fnd

2310: l_rolename VARCHAR2(320);
2311:
2312: CURSOR template_user_csr IS
2313: SELECT fnd.user_name
2314: FROM zpb_dc_objects obj, fnd_user fnd
2315: WHERE obj.template_id = p_template_id
2316: AND obj.object_user_id = fnd.user_id
2317: AND obj.object_type in ('W');
2318: --

Line 2420: l_object_type zpb_dc_objects.object_type%TYPE;

2416: IS
2417: l_api_name CONSTANT VARCHAR2(30) := 'Set_Ws_Recipient';
2418:
2419: l_param_value zpb_task_parameters.value%TYPE;
2420: l_object_type zpb_dc_objects.object_type%TYPE;
2421: l_exp_days NUMBER;
2422: l_user VARCHAR2(4000);
2423: l_upper_user VARCHAR2(100);
2424: l_charDate VARCHAR2(20);

Line 2507: FROM zpb_dc_objects

2503: l_role_has_users := 'N';
2504:
2505: SELECT object_id, object_user_id
2506: INTO l_object_id, l_object_user_id
2507: FROM zpb_dc_objects
2508: WHERE template_id = p_template_id
2509: AND object_type = 'M';
2510:
2511: IF l_param_value = 'SPECIFIC_USERS' THEN

Line 2593: FROM zpb_dc_objects

2589:
2590: -- Populate resp key based on object type and object id/user id
2591: SELECT object_type, object_id, object_user_id
2592: INTO l_object_type, l_object_id, l_object_user_id
2593: FROM zpb_dc_objects
2594: WHERE object_id = p_object_id;
2595:
2596: IF (l_object_type = 'E') THEN
2597: l_resp_key := 'ZPB_CONTROLLER_RESP';

Line 2737: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;

2733: l_return_status VARCHAR2(1);
2734: l_msg_count NUMBER;
2735: l_msg_data VARCHAR2(2000);
2736:
2737: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;
2738: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;
2739:
2740:
2741: BEGIN

Line 2738: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;

2734: l_msg_count NUMBER;
2735: l_msg_data VARCHAR2(2000);
2736:
2737: l_data_obj_name zpb_dc_objects.dataentry_obj_name%TYPE;
2738: l_target_obj_name zpb_dc_objects.target_obj_name%TYPE;
2739:
2740:
2741: BEGIN
2742:

Line 2779: FROM ZPB_DC_OBJECTS

2775: TARGET_OBJ_NAME ,
2776: INSTRUCTION_TEXT_ID ,
2777: DESCRIPTION ,
2778: DEADLINE_DATE
2779: FROM ZPB_DC_OBJECTS
2780: WHERE TEMPLATE_ID = p_template_id
2781: AND OBJECT_TYPE = 'M')
2782: LOOP
2783: UPDATE ZPB_DC_OBJECTS

Line 2783: UPDATE ZPB_DC_OBJECTS

2779: FROM ZPB_DC_OBJECTS
2780: WHERE TEMPLATE_ID = p_template_id
2781: AND OBJECT_TYPE = 'M')
2782: LOOP
2783: UPDATE ZPB_DC_OBJECTS
2784: SET TEMPLATE_NAME = e_rec.template_name,
2785: DESCRIPTION = e_rec.description,
2786: DATAENTRY_OBJ_PATH = e_rec.dataentry_obj_path,
2787: DATAENTRY_OBJ_NAME = e_rec.dataentry_obj_name,

Line 2802: UPDATE ZPB_DC_OBJECTS

2798: WHERE TEMPLATE_ID = p_template_id
2799: AND OBJECT_TYPE = 'C';
2800: END LOOP;
2801:
2802: UPDATE ZPB_DC_OBJECTS
2803: SET REVIEW_COMPLETE_FLAG = 'Y',
2804: STATUS = 'REVIEW_COMPLETED',
2805: LAST_UPDATED_BY = fnd_global.USER_ID,
2806: LAST_UPDATE_DATE = SYSDATE,

Line 2897: UPDATE zpb_dc_objects

2893: -- Initialize the parameters
2894:
2895: -- API Body
2896:
2897: UPDATE zpb_dc_objects
2898: SET delete_instance_measures_flag = 'Y'
2899: WHERE ac_instance_id = p_analysis_cycle_instance_id;
2900:
2901: IF FND_API.To_Boolean ( p_commit ) THEN

Line 3014: FROM zpb_dc_objects

3010: -- API Body
3011:
3012: SELECT object_user_id
3013: INTO l_object_user_id
3014: FROM zpb_dc_objects
3015: WHERE object_id = p_object_id;
3016:
3017: l_recipient_type := 'ALL_RPT';
3018:

Line 3165: UPDATE zpb_dc_objects

3161:
3162: -- Initialize the parameters
3163:
3164: -- API Body
3165: UPDATE zpb_dc_objects
3166: SET copy_source_type_flag = 'Y',
3167: create_solve_program_flag = 'Y',
3168: LAST_UPDATED_BY = fnd_global.USER_ID,
3169: LAST_UPDATE_DATE = SYSDATE,

Line 3218: UPDATE ZPB_DC_OBJECTS SET view_type = p_view_type,

3214: BEGIN
3215:
3216: SAVEPOINT Update_Template_View_Type;
3217:
3218: UPDATE ZPB_DC_OBJECTS SET view_type = p_view_type,
3219: create_solve_program_flag = 'Y' where
3220: template_id = p_template_id and (object_type = 'M' or object_type = 'E' or object_type = 'C');
3221:
3222: p_result_out := 'S';

Line 3246: SELECT object_type INTO s_object_type FROM zpb_dc_objects where

3242: BEGIN
3243:
3244: SAVEPOINT Update_Worksheet_View_Type;
3245:
3246: SELECT object_type INTO s_object_type FROM zpb_dc_objects where
3247: object_id = p_object_id;
3248:
3249: --Check if it is a Controller's Worksheet, If it is then we need to update
3250: --the records of type 'M' and 'E' also

Line 3254: UPDATE zpb_dc_objects SET view_type = p_view_type,

3250: --the records of type 'M' and 'E' also
3251: IF s_object_type = 'C' THEN
3252: Update_Template_View_Type(p_template_id,p_view_type,p_result_out);
3253: ELSE
3254: UPDATE zpb_dc_objects SET view_type = p_view_type,
3255: create_solve_program_flag = 'Y' where
3256: template_id = p_template_id and object_id = p_object_id;
3257: END IF;
3258:

Line 3269: END ZPB_DC_OBJECTS_PVT;

3265: p_result_out := 'E';
3266:
3267: END Update_Worksheet_View_Type;
3268:
3269: END ZPB_DC_OBJECTS_PVT;