DBA Data[Home] [Help]

APPS.INVTROAP dependencies on MTL_PARAMETERS

Line 40: From MTL_PARAMETERS

36: RETURN;
37: else
38: Select nvl(TXN_APPROVAL_TIMEOUT_PERIOD,0)
39: Into l_timeout_period
40: From MTL_PARAMETERS
41: Where organization_id = l_trohdr_rec.organization_id;
42:
43: if ( l_timeout_period = 0 ) then
44: Select nvl(MO_APPROVAL_TIMEOUT_ACTION,1)

Line 46: From MTL_PARAMETERS

42:
43: if ( l_timeout_period = 0 ) then
44: Select nvl(MO_APPROVAL_TIMEOUT_ACTION,1)
45: Into l_timeout_action
46: From MTL_PARAMETERS
47: Where organization_id = l_trohdr_rec.organization_id;
48:
49: if( l_timeout_action = 1 ) then
50: Inv_trohdr_Util.Update_Row_Status(To_Header_Id,

Line 871: From MTL_PARAMETERS

867: itemkey => itemkey,
868: aname => 'ORG_ID');
869: Select nvl(MO_APPROVAL_tIMEOUT_ACTION,1)
870: Into l_timeout_action
871: From MTL_PARAMETERS
872: Where organization_id = l_org_id;
873:
874: if ( l_timeout_action = 1 ) then
875: result := 'COMPLETE:APPROVED';

Line 1015: From MTL_PARAMETERS

1011: itemkey => itemkey,
1012: aname => 'ORG_ID');
1013: Select nvl(TXN_APPROVAL_TIMEOUT_PERIOD,0)
1014: Into l_timeout_period
1015: From MTL_PARAMETERS
1016: Where
1017: organization_id = l_org_id;
1018:
1019: Select c1.calendar_date

Line 1021: from mtl_parameters o,

1017: organization_id = l_org_id;
1018:
1019: Select c1.calendar_date
1020: into l_mfg_cal_date
1021: from mtl_parameters o,
1022: bom_calendar_dates c1,
1023: bom_calendar_dates c
1024: where o.organization_id = l_org_id
1025: and c1.calendar_code = c.calendar_code