DBA Data[Home] [Help]

APPS.OKE_AMG_GRP dependencies on FND_GLOBAL

Line 1110: X_CREATED_BY => Fnd_Global.User_Id,

1106: X_ITEM_ID => p_dlv_rec.item_id,
1107: X_DESCRIPTION => p_dlv_rec.dlv_description,
1108: X_COMMENTS => Null,
1109: X_CREATION_DATE => sysdate,
1110: X_CREATED_BY => Fnd_Global.User_Id,
1111: X_LAST_UPDATE_DATE => sysdate,
1112: X_LAST_UPDATED_BY => Fnd_Global.User_Id,
1113: X_LAST_UPDATE_LOGIN => Fnd_Global.login_id
1114: );

Line 1112: X_LAST_UPDATED_BY => Fnd_Global.User_Id,

1108: X_COMMENTS => Null,
1109: X_CREATION_DATE => sysdate,
1110: X_CREATED_BY => Fnd_Global.User_Id,
1111: X_LAST_UPDATE_DATE => sysdate,
1112: X_LAST_UPDATED_BY => Fnd_Global.User_Id,
1113: X_LAST_UPDATE_LOGIN => Fnd_Global.login_id
1114: );
1115: elsif p_action=G_UPD then
1116:

Line 1113: X_LAST_UPDATE_LOGIN => Fnd_Global.login_id

1109: X_CREATION_DATE => sysdate,
1110: X_CREATED_BY => Fnd_Global.User_Id,
1111: X_LAST_UPDATE_DATE => sysdate,
1112: X_LAST_UPDATED_BY => Fnd_Global.User_Id,
1113: X_LAST_UPDATE_LOGIN => Fnd_Global.login_id
1114: );
1115: elsif p_action=G_UPD then
1116:
1117: update OKE_DELIVERABLES_B

Line 1132: LAST_UPDATED_BY = fnd_globaL.user_id,

1128: INVENTORY_ORG_ID = p_dlv_rec.inventory_org_id,
1129: SOURCE_CODE = 'PA',
1130: SOURCE_DELIVERABLE_ID = p_dlv_rec.pa_deliverable_id,
1131: LAST_UPDATE_DATE = sysdate,
1132: LAST_UPDATED_BY = fnd_globaL.user_id,
1133: LAST_UPDATE_LOGIN = fnd_global.login_id
1134: where DELIVERABLE_ID = l_deliverable_id;
1135: if (sql%notfound) then
1136: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1133: LAST_UPDATE_LOGIN = fnd_global.login_id

1129: SOURCE_CODE = 'PA',
1130: SOURCE_DELIVERABLE_ID = p_dlv_rec.pa_deliverable_id,
1131: LAST_UPDATE_DATE = sysdate,
1132: LAST_UPDATED_BY = fnd_globaL.user_id,
1133: LAST_UPDATE_LOGIN = fnd_global.login_id
1134: where DELIVERABLE_ID = l_deliverable_id;
1135: if (sql%notfound) then
1136: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1137: end if;

Line 1142: LAST_UPDATED_BY = fnd_globaL.user_id,

1138:
1139: update OKE_DELIVERABLES_TL set
1140: DESCRIPTION = p_dlv_rec.dlv_description,
1141: LAST_UPDATE_DATE = sysdate,
1142: LAST_UPDATED_BY = fnd_globaL.user_id,
1143: LAST_UPDATE_LOGIN = fnd_global.login_id,
1144: SOURCE_LANG = userenv('LANG')
1145: where DELIVERABLE_ID = l_deliverable_id
1146: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 1143: LAST_UPDATE_LOGIN = fnd_global.login_id,

1139: update OKE_DELIVERABLES_TL set
1140: DESCRIPTION = p_dlv_rec.dlv_description,
1141: LAST_UPDATE_DATE = sysdate,
1142: LAST_UPDATED_BY = fnd_globaL.user_id,
1143: LAST_UPDATE_LOGIN = fnd_global.login_id,
1144: SOURCE_LANG = userenv('LANG')
1145: where DELIVERABLE_ID = l_deliverable_id
1146: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
1147:

Line 1157: LAST_UPDATED_BY = fnd_globaL.user_id,

1153: UNIT_PRICE = decode(action_type,G_REQ,p_dlv_rec.unit_price,unit_price),
1154: UOM_CODE = p_dlv_rec.uom_code,
1155: QUANTITY = p_dlv_rec.quantity,
1156: LAST_UPDATE_DATE = sysdate,
1157: LAST_UPDATED_BY = fnd_globaL.user_id,
1158: LAST_UPDATE_LOGIN = fnd_global.login_id
1159: where DELIVERABLE_ID = l_deliverable_id;
1160:
1161: end if;

Line 1158: LAST_UPDATE_LOGIN = fnd_global.login_id

1154: UOM_CODE = p_dlv_rec.uom_code,
1155: QUANTITY = p_dlv_rec.quantity,
1156: LAST_UPDATE_DATE = sysdate,
1157: LAST_UPDATED_BY = fnd_globaL.user_id,
1158: LAST_UPDATE_LOGIN = fnd_global.login_id
1159: where DELIVERABLE_ID = l_deliverable_id;
1160:
1161: end if;
1162: end if;

Line 1532: fnd_global.user_id ,

1528: unit_price,
1529: currency_code)
1530: Values(l_ACTION_ID,
1531: sysdate,
1532: fnd_global.user_id ,
1533: sysdate,
1534: fnd_global.user_id ,
1535: fnd_global.login_id,
1536: p_dlv_action_type ,

Line 1534: fnd_global.user_id ,

1530: Values(l_ACTION_ID,
1531: sysdate,
1532: fnd_global.user_id ,
1533: sysdate,
1534: fnd_global.user_id ,
1535: fnd_global.login_id,
1536: p_dlv_action_type ,
1537: l_ACTION_NAME ,
1538: l_PA_ACTION_ID ,

Line 1535: fnd_global.login_id,

1531: sysdate,
1532: fnd_global.user_id ,
1533: sysdate,
1534: fnd_global.user_id ,
1535: fnd_global.login_id,
1536: p_dlv_action_type ,
1537: l_ACTION_NAME ,
1538: l_PA_ACTION_ID ,
1539: l_TASK_ID ,

Line 1571: LAST_UPDATED_BY = fnd_global.user_id ,

1567: end if;
1568: If p_action='UPDATE' then
1569: update oke_deliverable_actions set
1570: LAST_UPDATE_DATE = sysdate,
1571: LAST_UPDATED_BY = fnd_global.user_id ,
1572: LAST_UPDATE_LOGIN = fnd_global.login_id,
1573: ACTION_TYPE = p_dlv_action_type ,
1574: ACTION_NAME = l_ACTION_NAME,
1575: PA_ACTION_ID = l_PA_ACTION_ID,

Line 1572: LAST_UPDATE_LOGIN = fnd_global.login_id,

1568: If p_action='UPDATE' then
1569: update oke_deliverable_actions set
1570: LAST_UPDATE_DATE = sysdate,
1571: LAST_UPDATED_BY = fnd_global.user_id ,
1572: LAST_UPDATE_LOGIN = fnd_global.login_id,
1573: ACTION_TYPE = p_dlv_action_type ,
1574: ACTION_NAME = l_ACTION_NAME,
1575: PA_ACTION_ID = l_PA_ACTION_ID,
1576: TASK_ID = l_TASK_ID,

Line 1645: LAST_UPDATED_BY = fnd_global.user_id ,

1641: , P_Expenditure_Organization_Id => l_Expenditure_Org_Id
1642: , P_Expenditure_Item_Date => l_expenditure_item_DATE ) ='Y' then
1643: update oke_deliverable_actions set
1644: LAST_UPDATE_DATE = sysdate,
1645: LAST_UPDATED_BY = fnd_global.user_id ,
1646: LAST_UPDATE_LOGIN = fnd_global.login_id,
1647: READY_FLAG = 'Y'
1648: where action_id=l_action_id;
1649: else

Line 1646: LAST_UPDATE_LOGIN = fnd_global.login_id,

1642: , P_Expenditure_Item_Date => l_expenditure_item_DATE ) ='Y' then
1643: update oke_deliverable_actions set
1644: LAST_UPDATE_DATE = sysdate,
1645: LAST_UPDATED_BY = fnd_global.user_id ,
1646: LAST_UPDATE_LOGIN = fnd_global.login_id,
1647: READY_FLAG = 'Y'
1648: where action_id=l_action_id;
1649: else
1650: raise FND_API.G_EXC_ERROR ;

Line 1671: LAST_UPDATED_BY = fnd_global.user_id ,

1667: , P_uom_code => l_uom_code
1668: ) ='Y' then
1669: update oke_deliverable_actions set
1670: LAST_UPDATE_DATE = sysdate,
1671: LAST_UPDATED_BY = fnd_global.user_id ,
1672: LAST_UPDATE_LOGIN = fnd_global.login_id,
1673: READY_FLAG = 'Y'
1674: where action_id=l_action_id;
1675: else

Line 1672: LAST_UPDATE_LOGIN = fnd_global.login_id,

1668: ) ='Y' then
1669: update oke_deliverable_actions set
1670: LAST_UPDATE_DATE = sysdate,
1671: LAST_UPDATED_BY = fnd_global.user_id ,
1672: LAST_UPDATE_LOGIN = fnd_global.login_id,
1673: READY_FLAG = 'Y'
1674: where action_id=l_action_id;
1675: else
1676: raise FND_API.G_EXC_ERROR ;