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

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

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

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

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

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