APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on GMD_SPECIFICATIONS_B

Line 163: FROM GMD_SPECIFICATIONS_B

159:
160: --RLNAGARA Bug 4706861 Rework
161: CURSOR get_spec_det(p_spec_id NUMBER) IS
162: SELECT SPEC_NAME,SPEC_VERS
163: FROM GMD_SPECIFICATIONS_B
164: WHERE SPEC_ID = p_spec_id;
165:
166: l_base_spec_name VARCHAR2(80);
167: l_base_spec_vers NUMBER;

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 485: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'

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

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

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

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

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