APPS.GMD_SS_APPROVAL_WF_PKG dependencies on GMD_STABILITY_STUDIES

Line 78: from gmd_stability_studies a,

74: f.organization_code LAB_ORGANIZATION_CODE , a.storage_plan_id ,
75: a.SCHEDULED_START_DATE , a.SCHEDULED_END_DATE , a.REVISED_START_DATE ,
76: a.REVISED_END_DATE , a.ACTUAL_START_DATE , a.ACTUAL_END_DATE ,
77: a.RECOMMENDED_SHELF_LIFE , a.RECOMMENDED_SHELF_LIFE_UNIT , a.DELETE_MARK , a.LAST_UPDATED_BY
78: from gmd_stability_studies a,
79: gmd_Qc_status b,
80: mtl_system_items_kfv c,
81: gmd_specifications d,
82: mtl_parameters e,

Line 193: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'

189: --
190: -- Update status to pending
191: --
192:
193: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'
194: , p_id => lSSId
195: , p_source_status => lStartStatus
196: , p_target_status => lTargetStatus
197: , p_mode => 'P'

Line 377: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'

373: -- All Approvers are approved.
374: -- change status of the object to target status
375: --
376:
377: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'
378: , p_id => lSSId
379: , p_source_status => lStartStatus
380: , p_target_status => lTargetStatus
381: , p_mode => 'A'

Line 485: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'

481: BEGIN
482: IF p_funcmode = 'RUN' THEN
483:
484:
485: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'
486: , p_id => lSpecId
487: , p_source_status => lStartStatus
488: , p_target_status => lTargetStatus
489: , p_mode => 'S'

Line 553: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'

549: ApproverIn => nextApprover);
550: END IF;
551:
552:
553: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_STABILITY_STUDIES_B'
554: , p_id => lSSId
555: , p_source_status => lStartStatus
556: , p_target_status => lTargetStatus
557: , p_mode => 'R'