DBA Data[Home] [Help]

APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on GMD_SPEC_GRP

Line 207: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'

203: --
204: -- Means either no AME rule is matching for this transaction ID or Approver list is empty.
205: -- change status of the object to target status
206: --
207: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'
208: , p_id => lSpecId
209: , p_source_status => lStartStatus
210: , p_target_status => lTargetStatus
211: , p_mode => 'A'

Line 251: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'

247: gmd_debug.put_line('Requesting approvers');
248: gmd_debug.put_line('Final Status ' || lTargetStatus);
249: END IF;
250:
251: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'
252: , p_id => lSpecId
253: , p_source_status => lStartStatus
254: , p_target_status => lTargetStatus
255: , p_mode => 'P'

Line 484: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'

480: gmd_debug.put_line('Finished approvers; changing status');
481: gmd_debug.put_line('Final Status ' || lTargetStatus);
482: END IF;
483:
484: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'
485: , p_id => lSpecId
486: , p_source_status => lStartStatus
487: , p_target_status => lTargetStatus
488: , p_mode => 'A'

Line 567: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'

563: api_ret_status VARCHAR2(1);
564: api_err_mesg VARCHAR2(240);
565: BEGIN
566: IF p_funcmode = 'RUN' THEN
567: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'
568: , p_id => lSpecId
569: , p_source_status => lStartStatus
570: , p_target_status => lTargetStatus
571: , p_mode => 'S'

Line 631: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'

627: transactionIdIn => lSpecId,
628: transactionTypeIn => transactionType,
629: ApproverIn => nextApprover);
630: END IF;
631: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'
632: , p_id => lSpecId
633: , p_source_status => lStartStatus
634: , p_target_status => lTargetStatus
635: , p_mode => 'R'