66: ,QCSTAT.MEANING
67: ,SPEC.SPEC_TYPE
68: ,SPEC.OVERLAY_IND
69: ,SPEC.BASE_SPEC_ID
70: FROM GMD_SPECIFICATIONS SPEC
71: ,IC_ITEM_MST ITEM
72: ,SY_ORGN_MST ORGN
73: ,GMD_QC_STATUS QCSTAT
74: WHERE SPEC.ITEM_ID = ITEM.ITEM_ID (+)
98: ,QCSTAT.MEANING
99: ,SPEC.SPEC_TYPE
100: ,SPEC.OVERLAY_IND
101: ,SPEC.BASE_SPEC_ID
102: FROM GMD_SPECIFICATIONS SPEC
103: ,mtl_system_items_kfv ITEM
104: ,mtl_parameters ORGN
105: ,GMD_QC_STATUS QCSTAT
106: ,MTL_ORGANIZATIONS MO
130: ,SPEC.SPEC_TYPE
131: ,SPEC.OVERLAY_IND
132: ,SPEC.BASE_SPEC_ID
133: FROM
134: GMD_SPECIFICATIONS SPEC
135: ,mtl_system_items_kfv ITEM
136: ,mtl_parameters ORGN
137: ,GMD_QC_STATUS QCSTAT
138: --,MTL_ORGANIZATIONS MO
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;
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'
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'
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'
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'
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'