DBA Data[Home] [Help]

APPS.ZPB_DC_WF dependencies on WF_EVENT

Line 646: l_event_t wf_event_t;

642: l_char_date VARCHAR2(30);
643: --
644: l_item_type VARCHAR2(100) ;
645: l_item_key VARCHAR2(240) ;
646: l_event_t wf_event_t;
647: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
648: --
649: BEGIN
650:

Line 690: wf_event.AddParameterToList(

686: '_' || l_char_date;
687:
688: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;
689:
690: wf_event.AddParameterToList(
691: p_name => 'DC_OBJECT_ID',
692: p_value => p_object_id,
693: p_parameterlist=> l_parameter_list);
694:

Line 695: wf_event.AddParameterToList(

691: p_name => 'DC_OBJECT_ID',
692: p_value => p_object_id,
693: p_parameterlist=> l_parameter_list);
694:
695: wf_event.AddParameterToList(
696: p_name => 'DC_RECIPIENT_TYPE',
697: p_value => p_recipient_type,
698: p_parameterlist=> l_parameter_list);
699:

Line 700: wf_event.AddParameterToList(

696: p_name => 'DC_RECIPIENT_TYPE',
697: p_value => p_recipient_type,
698: p_parameterlist=> l_parameter_list);
699:
700: wf_event.AddParameterToList(
701: p_name => 'DC_DIST_LIST_ID',
702: p_value => p_dist_list_id,
703: p_parameterlist=> l_parameter_list);
704:

Line 705: wf_event.AddParameterToList(

701: p_name => 'DC_DIST_LIST_ID',
702: p_value => p_dist_list_id,
703: p_parameterlist=> l_parameter_list);
704:
705: wf_event.AddParameterToList(
706: p_name => 'DC_APPROVER_TYPE',
707: p_value => p_approver_type,
708: p_parameterlist=> l_parameter_list);
709:

Line 710: wf_event.AddParameterToList(

706: p_name => 'DC_APPROVER_TYPE',
707: p_value => p_approver_type,
708: p_parameterlist=> l_parameter_list);
709:
710: wf_event.AddParameterToList(
711: p_name => 'DC_DEADLINE_DATE',
712: p_value => p_deadline_date,
713: p_parameterlist=> l_parameter_list);
714:

Line 715: wf_event.AddParameterToList(

711: p_name => 'DC_DEADLINE_DATE',
712: p_value => p_deadline_date,
713: p_parameterlist=> l_parameter_list);
714:
715: wf_event.AddParameterToList(
716: p_name => 'DC_OVERWRITE_CUST',
717: p_value => p_overwrite_cust,
718: p_parameterlist=> l_parameter_list);
719:

Line 720: wf_event.AddParameterToList(

716: p_name => 'DC_OVERWRITE_CUST',
717: p_value => p_overwrite_cust,
718: p_parameterlist=> l_parameter_list);
719:
720: wf_event.AddParameterToList(
721: p_name => 'DC_OVERWRITE_DATA',
722: p_value => p_overwrite_data,
723: p_parameterlist=> l_parameter_list);
724:

Line 725: wf_event.AddParameterToList(

721: p_name => 'DC_OVERWRITE_DATA',
722: p_value => p_overwrite_data,
723: p_parameterlist=> l_parameter_list);
724:
725: wf_event.AddParameterToList(
726: p_name => 'DC_DISTRIBUTION_MESSAGE',
727: p_value => p_distribution_message,
728: p_parameterlist=> l_parameter_list);
729:

Line 733: wf_event.AddParameterToList(p_name=>'FND_USER_ID',

729:
730: -- set fnd values so workflow process can use this values
731: -- since they can now be run in deferred mode
732:
733: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
734: p_value=> fnd_global.user_id,
735: p_parameterlist=>l_parameter_list);
736:
737:

Line 738: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

734: p_value=> fnd_global.user_id,
735: p_parameterlist=>l_parameter_list);
736:
737:
738: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
739: p_value=> fnd_global.resp_appl_id,
740: p_parameterlist=>l_parameter_list);
741:
742: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',

Line 742: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',

738: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
739: p_value=> fnd_global.resp_appl_id,
740: p_parameterlist=>l_parameter_list);
741:
742: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
743: p_value=> fnd_global.resp_id,
744: p_parameterlist=>l_parameter_list);
745:
746: -- wf debugging

Line 749: wf_event.raise(p_event_name => 'oracle.apps.zpb.dc.worksheet.distribute',

745:
746: -- wf debugging
747: wf_log_pkg.wf_debug_flag := TRUE;
748: -- raise the event
749: wf_event.raise(p_event_name => 'oracle.apps.zpb.dc.worksheet.distribute',
750: p_event_key => l_item_key,
751: p_parameters => l_parameter_list);
752:
753: l_parameter_list.delete;

Line 1405: l_event_t wf_event_t;

1401: l_approval_required_flag VARCHAR2(1);
1402: --
1403: l_item_type VARCHAR2(100);
1404: l_item_key VARCHAR2(240) ;
1405: l_event_t wf_event_t;
1406: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1407: --
1408: BEGIN
1409:

Line 1529: wf_event.AddParameterToList(

1525:
1526:
1527: FND_FILE.Put_Line ( FND_FILE.LOG, 'WF key ' || l_item_key ) ;
1528:
1529: wf_event.AddParameterToList(
1530: p_name => 'DC_OBJECT_ID',
1531: p_value => p_object_id,
1532: p_parameterlist=> l_parameter_list);
1533:

Line 1534: wf_event.AddParameterToList(

1530: p_name => 'DC_OBJECT_ID',
1531: p_value => p_object_id,
1532: p_parameterlist=> l_parameter_list);
1533:
1534: wf_event.AddParameterToList(
1535: p_name => 'DC_TEMPLATE_ID',
1536: p_value => l_template_id,
1537: p_parameterlist=> l_parameter_list);
1538:

Line 1539: wf_event.AddParameterToList(

1535: p_name => 'DC_TEMPLATE_ID',
1536: p_value => l_template_id,
1537: p_parameterlist=> l_parameter_list);
1538:
1539: wf_event.AddParameterToList(
1540: p_name => 'DC_OBJECT_TYPE',
1541: p_value => l_object_type,
1542: p_parameterlist=> l_parameter_list);
1543:

Line 1544: wf_event.AddParameterToList(

1540: p_name => 'DC_OBJECT_TYPE',
1541: p_value => l_object_type,
1542: p_parameterlist=> l_parameter_list);
1543:
1544: wf_event.AddParameterToList(
1545: p_name => 'DC_SUBMISSION_MESSAGE',
1546: p_value => p_submission_message,
1547: p_parameterlist=> l_parameter_list);
1548:

Line 1552: wf_event.AddParameterToList(p_name=>'FND_USER_ID',

1548:
1549: -- set fnd values so workflow process can use this values
1550: -- since they can now be run in deferred mode
1551:
1552: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
1553: p_value=> fnd_global.user_id,
1554: p_parameterlist=>l_parameter_list);
1555:
1556: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

Line 1556: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

1552: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
1553: p_value=> fnd_global.user_id,
1554: p_parameterlist=>l_parameter_list);
1555:
1556: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
1557: p_value=> fnd_global.resp_appl_id,
1558: p_parameterlist=>l_parameter_list);
1559:
1560: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',

Line 1560: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',

1556: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
1557: p_value=> fnd_global.resp_appl_id,
1558: p_parameterlist=>l_parameter_list);
1559:
1560: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
1561: p_value=> fnd_global.resp_id,
1562: p_parameterlist=>l_parameter_list);
1563:
1564: -- wf debugging

Line 1568: wf_event.raise(p_event_name => 'oracle.apps.zpb.dc.worksheet.submit',

1564: -- wf debugging
1565: wf_log_pkg.wf_debug_flag := TRUE;
1566:
1567: -- raise the event
1568: wf_event.raise(p_event_name => 'oracle.apps.zpb.dc.worksheet.submit',
1569: p_event_key => l_item_key,
1570: p_parameters => l_parameter_list);
1571:
1572: l_parameter_list.delete;

Line 2461: l_event_t wf_event_t;

2457:
2458: --
2459: l_item_type VARCHAR2(100) ;
2460: l_item_key VARCHAR2(240) ;
2461: l_event_t wf_event_t;
2462: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
2463: --
2464: BEGIN
2465:

Line 2526: wf_event.AddParameterToList(

2522: l_subtr_rolename := 'ZPB_APP_SUBTR'|| to_char(p_object_id) || '-' || l_char_date;
2523: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);
2524: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);
2525:
2526: wf_event.AddParameterToList(
2527: p_name => '#FROM_ROLE',
2528: p_value => l_from_name,
2529: p_parameterlist=> l_parameter_list);
2530:

Line 2531: wf_event.AddParameterToList(

2527: p_name => '#FROM_ROLE',
2528: p_value => l_from_name,
2529: p_parameterlist=> l_parameter_list);
2530:
2531: wf_event.AddParameterToList(
2532: p_name => 'DC_APPROVER_FOR_MSG',
2533: p_value => l_approver_for_msg,
2534: p_parameterlist=> l_parameter_list);
2535:

Line 2537: wf_event.AddParameterToList(

2533: p_value => l_approver_for_msg,
2534: p_parameterlist=> l_parameter_list);
2535:
2536: l_subtr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_subtr_rolename, l_submitter);
2537: wf_event.AddParameterToList(
2538: p_name => 'DC_SUBMITTER',
2539: p_value => l_subtr_rolename,
2540: p_parameterlist=> l_parameter_list);
2541:

Line 2542: wf_event.AddParameterToList(

2538: p_name => 'DC_SUBMITTER',
2539: p_value => l_subtr_rolename,
2540: p_parameterlist=> l_parameter_list);
2541:
2542: wf_event.AddParameterToList(
2543: p_name => 'DC_TEMPLATE_NAME',
2544: p_value => l_template_name,
2545: p_parameterlist=> l_parameter_list);
2546:

Line 2547: wf_event.AddParameterToList(

2543: p_name => 'DC_TEMPLATE_NAME',
2544: p_value => l_template_name,
2545: p_parameterlist=> l_parameter_list);
2546:
2547: wf_event.AddParameterToList(
2548: p_name => 'DC_APPROVAL_MESSAGE',
2549: p_value => p_approval_message,
2550: p_parameterlist=> l_parameter_list);
2551:

Line 2556: wf_event.AddParameterToList(p_name=>'FND_USER_ID',

2552: -- set fnd values so workflow process can use this values
2553: -- since they can now be run in deferred mode
2554: -- working:fnd_global.apps_initialize(1005258,57124,210);
2555:
2556: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2557: p_value=> fnd_global.user_id,
2558: p_parameterlist=>l_parameter_list);
2559:
2560: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

Line 2560: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

2556: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2557: p_value=> fnd_global.user_id,
2558: p_parameterlist=>l_parameter_list);
2559:
2560: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
2561: p_value=> fnd_global.resp_appl_id,
2562: p_parameterlist=>l_parameter_list);
2563:
2564: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',

Line 2564: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',

2560: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
2561: p_value=> fnd_global.resp_appl_id,
2562: p_parameterlist=>l_parameter_list);
2563:
2564: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
2565: p_value=> fnd_global.resp_id,
2566: p_parameterlist=>l_parameter_list);
2567:
2568: -- wf debugging

Line 2571: wf_event.raise(p_event_name => 'oracle.apps.zpb.dc.worksheet.approve',

2567:
2568: -- wf debugging
2569: wf_log_pkg.wf_debug_flag := TRUE;
2570: -- raise the event
2571: wf_event.raise(p_event_name => 'oracle.apps.zpb.dc.worksheet.approve',
2572: p_event_key => l_item_key,
2573: p_parameters => l_parameter_list);
2574:
2575: l_parameter_list.delete;

Line 2667: l_event_t wf_event_t;

2663: l_subtr_rolename VARCHAR2(320);
2664: --
2665: l_item_type VARCHAR2(100) ;
2666: l_item_key VARCHAR2(240) ;
2667: l_event_t wf_event_t;
2668: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
2669: --
2670: BEGIN
2671:

Line 2737: wf_event.AddParameterToList(

2733: l_subtr_rolename := 'ZPB_REJ_SUBTR'|| to_char(p_object_id) || '-' || l_char_date;
2734: zpb_wf_ntf.SetRole(l_appr_rolename, l_exp_days);
2735: zpb_wf_ntf.SetRole(l_subtr_rolename, l_exp_days);
2736:
2737: wf_event.AddParameterToList(
2738: p_name => '#FROM_ROLE',
2739: p_value => l_from_name,
2740: p_parameterlist=> l_parameter_list);
2741:

Line 2742: wf_event.AddParameterToList(

2738: p_name => '#FROM_ROLE',
2739: p_value => l_from_name,
2740: p_parameterlist=> l_parameter_list);
2741:
2742: wf_event.AddParameterToList(
2743: p_name => 'DC_APPROVER_FOR_MSG',
2744: p_value => l_approver_for_msg,
2745: p_parameterlist=> l_parameter_list);
2746:

Line 2748: wf_event.AddParameterToList(

2744: p_value => l_approver_for_msg,
2745: p_parameterlist=> l_parameter_list);
2746:
2747: l_subtr_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_subtr_rolename, l_submitter);
2748: wf_event.AddParameterToList(
2749: p_name => 'DC_SUBMITTER',
2750: p_value => l_subtr_rolename,
2751: p_parameterlist=> l_parameter_list);
2752:

Line 2753: wf_event.AddParameterToList(

2749: p_name => 'DC_SUBMITTER',
2750: p_value => l_subtr_rolename,
2751: p_parameterlist=> l_parameter_list);
2752:
2753: wf_event.AddParameterToList(
2754: p_name => 'DC_TEMPLATE_NAME',
2755: p_value => l_template_name,
2756: p_parameterlist=> l_parameter_list);
2757:

Line 2758: wf_event.AddParameterToList(

2754: p_name => 'DC_TEMPLATE_NAME',
2755: p_value => l_template_name,
2756: p_parameterlist=> l_parameter_list);
2757:
2758: wf_event.AddParameterToList(
2759: p_name => 'DC_REJECTION_MESSAGE',
2760: p_value => p_rejection_message,
2761: p_parameterlist=> l_parameter_list);
2762:

Line 2767: wf_event.AddParameterToList(p_name=>'FND_USER_ID',

2763: -- set fnd values so workflow process can use this values
2764: -- since they can now be run in deferred mode
2765: -- working:fnd_global.apps_initialize(1005258,57124,210);
2766:
2767: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2768: p_value=> fnd_global.user_id,
2769: p_parameterlist=>l_parameter_list);
2770:
2771: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

Line 2771: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',

2767: wf_event.AddParameterToList(p_name=>'FND_USER_ID',
2768: p_value=> fnd_global.user_id,
2769: p_parameterlist=>l_parameter_list);
2770:
2771: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
2772: p_value=> fnd_global.resp_appl_id,
2773: p_parameterlist=>l_parameter_list);
2774:
2775: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',

Line 2775: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',

2771: wf_event.AddParameterToList(p_name=>'FND_APPLICATION_ID',
2772: p_value=> fnd_global.resp_appl_id,
2773: p_parameterlist=>l_parameter_list);
2774:
2775: wf_event.AddParameterToList(p_name=>'FND_RESPONSIBILITY_ID',
2776: p_value=> fnd_global.resp_id,
2777: p_parameterlist=>l_parameter_list);
2778:
2779: -- wf debugging

Line 2782: wf_event.raise(p_event_name => 'oracle.apps.zpb.dc.worksheet.reject',

2778:
2779: -- wf debugging
2780: wf_log_pkg.wf_debug_flag := TRUE;
2781: -- raise the event
2782: wf_event.raise(p_event_name => 'oracle.apps.zpb.dc.worksheet.reject',
2783: p_event_key => l_item_key,
2784: p_parameters => l_parameter_list);
2785:
2786: l_parameter_list.delete;