DBA Data[Home] [Help]

APPS.PA_CUSTOMERS_CONTACTS_PVT dependencies on FND_GLOBAL

Line 144: l_last_updated_by := fnd_global.user_id;

140: end if;
141:
142: -- Populate who column values
143: l_last_update_date := sysdate;
144: l_last_updated_by := fnd_global.user_id;
145: l_creation_date := sysdate;
146: l_created_by := fnd_global.user_id;
147: l_last_update_login := fnd_global.login_id;
148:

Line 146: l_created_by := fnd_global.user_id;

142: -- Populate who column values
143: l_last_update_date := sysdate;
144: l_last_updated_by := fnd_global.user_id;
145: l_creation_date := sysdate;
146: l_created_by := fnd_global.user_id;
147: l_last_update_login := fnd_global.login_id;
148:
149: -- Convert default constants to null
150: if p_bill_to_address_id = FND_API.G_MISS_NUM then

Line 147: l_last_update_login := fnd_global.login_id;

143: l_last_update_date := sysdate;
144: l_last_updated_by := fnd_global.user_id;
145: l_creation_date := sysdate;
146: l_created_by := fnd_global.user_id;
147: l_last_update_login := fnd_global.login_id;
148:
149: -- Convert default constants to null
150: if p_bill_to_address_id = FND_API.G_MISS_NUM then
151: l_bill_to_address_id := NULL;

Line 542: l_last_updated_by := fnd_global.user_id;

538: --dbms_output.put_line('value of p_project_relationship_code after validate '||p_project_relationship_code);
539:
540: -- Populate who column values
541: l_last_update_date := sysdate;
542: l_last_updated_by := fnd_global.user_id;
543: l_last_update_login := fnd_global.login_id;
544:
545: -- Convert default constants to null
546: if p_bill_to_address_id = FND_API.G_MISS_NUM then

Line 543: l_last_update_login := fnd_global.login_id;

539:
540: -- Populate who column values
541: l_last_update_date := sysdate;
542: l_last_updated_by := fnd_global.user_id;
543: l_last_update_login := fnd_global.login_id;
544:
545: -- Convert default constants to null
546: if p_bill_to_address_id = FND_API.G_MISS_NUM then
547: l_bill_to_address_id := NULL;

Line 1051: l_last_updated_by := fnd_global.user_id;

1047: end if;
1048:
1049: -- Populate who column values
1050: l_last_update_date := sysdate;
1051: l_last_updated_by := fnd_global.user_id;
1052: l_creation_date := sysdate;
1053: l_created_by := fnd_global.user_id;
1054: l_last_update_login := fnd_global.login_id;
1055:

Line 1053: l_created_by := fnd_global.user_id;

1049: -- Populate who column values
1050: l_last_update_date := sysdate;
1051: l_last_updated_by := fnd_global.user_id;
1052: l_creation_date := sysdate;
1053: l_created_by := fnd_global.user_id;
1054: l_last_update_login := fnd_global.login_id;
1055:
1056: if p_validate_only <> FND_API.G_TRUE then
1057: PA_PROJECT_CONTACTS_PKG.INSERT_ROW

Line 1054: l_last_update_login := fnd_global.login_id;

1050: l_last_update_date := sysdate;
1051: l_last_updated_by := fnd_global.user_id;
1052: l_creation_date := sysdate;
1053: l_created_by := fnd_global.user_id;
1054: l_last_update_login := fnd_global.login_id;
1055:
1056: if p_validate_only <> FND_API.G_TRUE then
1057: PA_PROJECT_CONTACTS_PKG.INSERT_ROW
1058: ( X_Rowid => l_rowid

Line 1252: l_last_updated_by := fnd_global.user_id;

1248: end if;
1249:
1250: -- Populate who column values
1251: l_last_update_date := sysdate;
1252: l_last_updated_by := fnd_global.user_id;
1253: l_last_update_login := fnd_global.login_id;
1254:
1255: if p_validate_only <> FND_API.G_TRUE then
1256: PA_PROJECT_CONTACTS_PKG.UPDATE_ROW

Line 1253: l_last_update_login := fnd_global.login_id;

1249:
1250: -- Populate who column values
1251: l_last_update_date := sysdate;
1252: l_last_updated_by := fnd_global.user_id;
1253: l_last_update_login := fnd_global.login_id;
1254:
1255: if p_validate_only <> FND_API.G_TRUE then
1256: PA_PROJECT_CONTACTS_PKG.UPDATE_ROW
1257: ( X_Rowid => p_rowid