DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_BUDGET_WF dependencies on WF_ENGINE

Line 303: -- call to wf_engine.Create_Process.

299: --
300: -- Also, if you want to use a different item type or process ,you must
301: -- change the value for the variable ItemType and the
302: -- change the value for the parameter "process" in the
303: -- call to wf_engine.Create_Process.
304: -- Make sure that you have a thorough understanding
305: -- of the Oracle Workflow product and how to use PL/SQL with Workflow.
306: --
307:

Line 680: wf_engine.CreateProcess( ItemType => ItemType,

676: -- 'PA Budget Approval Workflow'.
677: -- ------------------------------------------------------------------------------------
678: --dbms_output.put_line('Call for CreateProcess');
679:
680: wf_engine.CreateProcess( ItemType => ItemType,
681: ItemKey => ItemKey,
682: process => 'PRO_BASELINE_BUDGET' );
683:
684: --dbms_output.put_line('SetitemAttributes');

Line 687: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

683:
684: --dbms_output.put_line('SetitemAttributes');
685:
686:
687: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
688: itemkey => itemkey,
689: aname => 'PROJECT_ID',
690: avalue => p_project_id);
691: --

Line 692: wf_engine.SetItemAttrText ( itemtype => itemtype,

688: itemkey => itemkey,
689: aname => 'PROJECT_ID',
690: avalue => p_project_id);
691: --
692: wf_engine.SetItemAttrText ( itemtype => itemtype,
693: itemkey => itemkey,
694: aname => 'PM_PROJECT_REFERENCE',
695: avalue => l_pm_project_reference );
696:

Line 697: wf_engine.SetItemAttrText ( itemtype => itemtype,

693: itemkey => itemkey,
694: aname => 'PM_PROJECT_REFERENCE',
695: avalue => l_pm_project_reference );
696:
697: wf_engine.SetItemAttrText ( itemtype => itemtype,
698: itemkey => itemkey,
699: aname => 'PA_PROJECT_NUMBER',
700: avalue => l_pa_project_number );
701:

Line 702: wf_engine.SetItemAttrText ( itemtype => itemtype,

698: itemkey => itemkey,
699: aname => 'PA_PROJECT_NUMBER',
700: avalue => l_pa_project_number );
701:
702: wf_engine.SetItemAttrText ( itemtype => itemtype,
703: itemkey => itemkey,
704: aname => 'PROJECT_NAME',
705: avalue => l_project_name );
706:

Line 707: wf_engine.SetItemAttrText ( itemtype => itemtype,

703: itemkey => itemkey,
704: aname => 'PROJECT_NAME',
705: avalue => l_project_name );
706:
707: wf_engine.SetItemAttrText ( itemtype => itemtype,
708: itemkey => itemkey,
709: aname => 'PROJECT_DESCRIPTION',
710: avalue => l_description );
711:

Line 712: wf_engine.SetItemAttrText ( itemtype => itemtype,

708: itemkey => itemkey,
709: aname => 'PROJECT_DESCRIPTION',
710: avalue => l_description );
711:
712: wf_engine.SetItemAttrText ( itemtype => itemtype,
713: itemkey => itemkey,
714: aname => 'PROJECT_TYPE',
715: avalue => l_project_type );
716:

Line 717: wf_engine.SetItemAttrText ( itemtype => itemtype,

713: itemkey => itemkey,
714: aname => 'PROJECT_TYPE',
715: avalue => l_project_type );
716:
717: wf_engine.SetItemAttrText ( itemtype => itemtype,
718: itemkey => itemkey,
719: aname => 'PM_PROJECT_PRODUCT_CODE',
720: avalue => l_pm_project_product_code );
721:

Line 722: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

718: itemkey => itemkey,
719: aname => 'PM_PROJECT_PRODUCT_CODE',
720: avalue => l_pm_project_product_code );
721:
722: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
723: itemkey => itemkey,
724: aname => 'CARRYING_OUT_ORG_ID',
725: avalue => l_carrying_out_org_id);
726:

Line 727: wf_engine.SetItemAttrText ( itemtype => itemtype,

723: itemkey => itemkey,
724: aname => 'CARRYING_OUT_ORG_ID',
725: avalue => l_carrying_out_org_id);
726:
727: wf_engine.SetItemAttrText ( itemtype => itemtype,
728: itemkey => itemkey,
729: aname => 'CARRYING_OUT_ORG_NAME',
730: avalue => l_carrying_out_org_name);
731:

Line 732: wf_engine.SetItemAttrText ( itemtype => itemtype,

728: itemkey => itemkey,
729: aname => 'CARRYING_OUT_ORG_NAME',
730: avalue => l_carrying_out_org_name);
731:
732: wf_engine.SetItemAttrText ( itemtype => itemtype,
733: itemkey => itemkey,
734: aname => 'PROJECT_TYPE_CLASS_CODE',
735: avalue => l_project_type_class_code);
736:

Line 737: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

733: itemkey => itemkey,
734: aname => 'PROJECT_TYPE_CLASS_CODE',
735: avalue => l_project_type_class_code);
736:
737: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
738: itemkey => itemkey,
739: aname => 'WORKFLOW_STARTED_BY_ID',
740: avalue => l_workflow_started_by_id);
741:

Line 742: wf_engine.SetItemAttrText ( itemtype => itemtype,

738: itemkey => itemkey,
739: aname => 'WORKFLOW_STARTED_BY_ID',
740: avalue => l_workflow_started_by_id);
741:
742: wf_engine.SetItemAttrText ( itemtype => itemtype,
743: itemkey => itemkey,
744: aname => 'WORKFLOW_STARTED_BY_NAME',
745: avalue => l_user_name);
746:

Line 747: wf_engine.SetItemAttrText ( itemtype => itemtype,

743: itemkey => itemkey,
744: aname => 'WORKFLOW_STARTED_BY_NAME',
745: avalue => l_user_name);
746:
747: wf_engine.SetItemAttrText ( itemtype => itemtype,
748: itemkey => itemkey,
749: aname => 'WORKFLOW_STARTED_BY_FULL_NAME',
750: avalue => l_full_name);
751:

Line 753: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

749: aname => 'WORKFLOW_STARTED_BY_FULL_NAME',
750: avalue => l_full_name);
751:
752:
753: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
754: itemkey => itemkey,
755: aname => 'RESPONSIBILITY_ID',
756: avalue => l_resp_id);
757:

Line 758: wf_engine.SetItemAttrText ( itemtype => itemtype,

754: itemkey => itemkey,
755: aname => 'RESPONSIBILITY_ID',
756: avalue => l_resp_id);
757:
758: wf_engine.SetItemAttrText ( itemtype => itemtype,
759: itemkey => itemkey,
760: aname => 'BUDGET_TYPE_CODE',
761: avalue => l_budget_type_code);
762:

Line 763: wf_engine.SetItemAttrText ( itemtype => itemtype,

759: itemkey => itemkey,
760: aname => 'BUDGET_TYPE_CODE',
761: avalue => l_budget_type_code);
762:
763: wf_engine.SetItemAttrText ( itemtype => itemtype,
764: itemkey => itemkey,
765: aname => 'BUDGET_TYPE',
766: avalue => l_budget_type);
767:

Line 768: wf_engine.SetItemAttrText ( itemtype => itemtype,

764: itemkey => itemkey,
765: aname => 'BUDGET_TYPE',
766: avalue => l_budget_type);
767:
768: wf_engine.SetItemAttrText ( itemtype => itemtype,
769: itemkey => itemkey,
770: aname => 'PM_BUDGET_REFERENCE',
771: avalue => l_pm_budget_reference);
772:

Line 773: wf_engine.SetItemAttrText ( itemtype => itemtype,

769: itemkey => itemkey,
770: aname => 'PM_BUDGET_REFERENCE',
771: avalue => l_pm_budget_reference);
772:
773: wf_engine.SetItemAttrText ( itemtype => itemtype,
774: itemkey => itemkey,
775: aname => 'BUDGET_DESCRIPTION',
776: avalue => l_budget_description);
777:

Line 778: wf_engine.SetItemAttrText ( itemtype => itemtype,

774: itemkey => itemkey,
775: aname => 'BUDGET_DESCRIPTION',
776: avalue => l_budget_description);
777:
778: wf_engine.SetItemAttrText ( itemtype => itemtype,
779: itemkey => itemkey,
780: aname => 'CHANGE_REASON_CODE',
781: avalue => l_budget_change_reason_code);
782:

Line 783: wf_engine.SetItemAttrText ( itemtype => itemtype,

779: itemkey => itemkey,
780: aname => 'CHANGE_REASON_CODE',
781: avalue => l_budget_change_reason_code);
782:
783: wf_engine.SetItemAttrText ( itemtype => itemtype,
784: itemkey => itemkey,
785: aname => 'BUDGET_ENTRY_METHOD',
786: avalue => l_budget_entry_method);
787:

Line 788: wf_engine.SetItemAttrText ( itemtype => itemtype,

784: itemkey => itemkey,
785: aname => 'BUDGET_ENTRY_METHOD',
786: avalue => l_budget_entry_method);
787:
788: wf_engine.SetItemAttrText ( itemtype => itemtype,
789: itemkey => itemkey,
790: aname => 'BUDGET_ENTRY_METHOD_CODE',
791: avalue => l_budget_entry_method_code);
792:

Line 793: wf_engine.SetItemAttrText ( itemtype => itemtype,

789: itemkey => itemkey,
790: aname => 'BUDGET_ENTRY_METHOD_CODE',
791: avalue => l_budget_entry_method_code);
792:
793: wf_engine.SetItemAttrText ( itemtype => itemtype,
794: itemkey => itemkey,
795: aname => 'PM_BUDGET_PRODUCT_CODE',
796: avalue => l_pm_budget_product_code);
797:

Line 798: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

794: itemkey => itemkey,
795: aname => 'PM_BUDGET_PRODUCT_CODE',
796: avalue => l_pm_budget_product_code);
797:
798: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
799: itemkey => itemkey,
800: aname => 'TOTAL_LABOR_HOURS',
801: avalue => l_total_labor_hours);
802:

Line 803: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

799: itemkey => itemkey,
800: aname => 'TOTAL_LABOR_HOURS',
801: avalue => l_total_labor_hours);
802:
803: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
804: itemkey => itemkey,
805: aname => 'TOTAL_RAW_COST',
806: avalue => l_total_raw_cost);
807:

Line 808: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

804: itemkey => itemkey,
805: aname => 'TOTAL_RAW_COST',
806: avalue => l_total_raw_cost);
807:
808: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
809: itemkey => itemkey,
810: aname => 'TOTAL_BURDENED_COST',
811: avalue => l_total_burdened_cost);
812:

Line 813: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

809: itemkey => itemkey,
810: aname => 'TOTAL_BURDENED_COST',
811: avalue => l_total_burdened_cost);
812:
813: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
814: itemkey => itemkey,
815: aname => 'TOTAL_REVENUE',
816: avalue => l_total_revenue);
817:

Line 818: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

814: itemkey => itemkey,
815: aname => 'TOTAL_REVENUE',
816: avalue => l_total_revenue);
817:
818: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
819: itemkey => itemkey,
820: aname => 'RESOURCE_LIST_ID',
821: avalue => l_resource_list_id);
822:

Line 823: wf_engine.SetItemAttrText ( itemtype => itemtype,

819: itemkey => itemkey,
820: aname => 'RESOURCE_LIST_ID',
821: avalue => l_resource_list_id);
822:
823: wf_engine.SetItemAttrText ( itemtype => itemtype,
824: itemkey => itemkey,
825: aname => 'RESOURCE_LIST_NAME',
826: avalue => l_resource_list_name);
827:

Line 828: wf_engine.SetItemAttrText ( itemtype => itemtype,

824: itemkey => itemkey,
825: aname => 'RESOURCE_LIST_NAME',
826: avalue => l_resource_list_name);
827:
828: wf_engine.SetItemAttrText ( itemtype => itemtype,
829: itemkey => itemkey,
830: aname => 'RESOURCE_LIST_DESCRIPTION',
831: avalue => l_resource_list_description);
832:

Line 833: wf_engine.SetItemAttrText ( itemtype => itemtype,

829: itemkey => itemkey,
830: aname => 'RESOURCE_LIST_DESCRIPTION',
831: avalue => l_resource_list_description);
832:
833: wf_engine.SetItemAttrText ( itemtype => itemtype,
834: itemkey => itemkey,
835: aname => 'MARK_AS_ORIGINAL',
836: avalue => l_mark_as_original);
837:

Line 838: wf_engine.SetItemAttrText (itemtype => itemtype,

834: itemkey => itemkey,
835: aname => 'MARK_AS_ORIGINAL',
836: avalue => l_mark_as_original);
837:
838: wf_engine.SetItemAttrText (itemtype => itemtype,
839: itemkey => itemkey,
840: aname => 'WF_STARTED_DATE',
841: avalue => l_wf_started_date);
842:

Line 844: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

840: aname => 'WF_STARTED_DATE',
841: avalue => l_wf_started_date);
842:
843:
844: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
845: itemkey => itemkey,
846: aname => 'DRAFT_VERSION_ID',
847: avalue => p_draft_version_id);
848:

Line 853: wf_engine.SetItemAttrText (itemtype => itemtype,

849:
850:
851: -- Budget Integration Attributes ------------------------------------------
852:
853: wf_engine.SetItemAttrText (itemtype => itemtype,
854: itemkey => itemkey,
855: aname => 'FCK_REQ_FLAG',
856: avalue => p_fck_req_flag);
857:

Line 858: wf_engine.SetItemAttrText (itemtype => itemtype,

854: itemkey => itemkey,
855: aname => 'FCK_REQ_FLAG',
856: avalue => p_fck_req_flag);
857:
858: wf_engine.SetItemAttrText (itemtype => itemtype,
859: itemkey => itemkey,
860: aname => 'BGT_INTG_FLAG',
861: avalue => p_bgt_intg_flag);
862:

Line 869: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

865:
866:
867:
868:
869: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
870: itemkey => itemkey,
871: aname => 'FIN_PLAN_TYPE_ID',
872: avalue => l_fin_plan_type_id);
873:

Line 874: wf_engine.SetItemAttrText ( itemtype => itemtype,

870: itemkey => itemkey,
871: aname => 'FIN_PLAN_TYPE_ID',
872: avalue => l_fin_plan_type_id);
873:
874: wf_engine.SetItemAttrText ( itemtype => itemtype,
875: itemkey => itemkey,
876: aname => 'VERSION_TYPE',
877: avalue => l_version_type);
878:

Line 879: wf_engine.SetItemAttrText ( itemtype => itemtype,

875: itemkey => itemkey,
876: aname => 'VERSION_TYPE',
877: avalue => l_version_type);
878:
879: wf_engine.SetItemAttrText ( itemtype => itemtype,
880: itemkey => itemkey,
881: aname => 'FIN_PLAN_TYPE_NAME',
882: avalue => l_fin_plan_type_name);
883:

Line 884: wf_engine.SetItemAttrText ( itemtype => itemtype,

880: itemkey => itemkey,
881: aname => 'FIN_PLAN_TYPE_NAME',
882: avalue => l_fin_plan_type_name);
883:
884: wf_engine.SetItemAttrText ( itemtype => itemtype,
885: itemkey => itemkey,
886: aname => 'FIN_PLAN_LEVEL',
887: avalue => l_fin_plan_level);
888:

Line 889: wf_engine.SetItemAttrText ( itemtype => itemtype,

885: itemkey => itemkey,
886: aname => 'FIN_PLAN_LEVEL',
887: avalue => l_fin_plan_level);
888:
889: wf_engine.SetItemAttrText ( itemtype => itemtype,
890: itemkey => itemkey,
891: aname => 'FIN_PLAN_TIME_PHASE',
892: avalue => l_fin_plan_time_phase);
893:

Line 907: wf_engine.SetItemAttrText( itemtype

903: ||'&'||'paTemplateFlag='||l_template_flag
904: ||'&'||'paCallingPage=paBudgetWF'
905: ||'&'||'addBreadCrumb=Y';
906:
907: wf_engine.SetItemAttrText( itemtype
908: , itemkey
909: , 'FINANCIAL_PLAN_URL'
910: , l_url
911: );

Line 919: wf_engine.StartProcess( itemtype => itemtype,

915:
916:
917:
918:
919: wf_engine.StartProcess( itemtype => itemtype,
920: itemkey => itemkey );
921:
922:
923: --dbms_output.put_line('AFTER Call for StartProcess');