DBA Data[Home] [Help]

APPS.EDR_PSIG dependencies on EDR_TRANS_ACKN

Line 544: EDR_TRANS_ACKN_PVT.INSERT_ROW

540: -- we dont have to do any validation at all as erecord id is valid
541: -- we just created it, status is valid, there is no risk of duplicate
542: -- ack status for this erecord as its just created in the step above
543:
544: EDR_TRANS_ACKN_PVT.INSERT_ROW
545: ( p_api_version => 1.0 ,
546: p_init_msg_list => FND_API.G_TRUE ,
547: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
548: x_return_status => l_return_status ,

Line 683: EDR_TRANS_ACKN_PVT.INSERT_ROW

679: -- we dont have to do any validation at all as erecord id is valid
680: -- we just created it, status is valid, there is no risk of duplicate
681: -- ack status for this erecord as its just created in the step above
682:
683: EDR_TRANS_ACKN_PVT.INSERT_ROW
684: ( p_api_version => 1.0 ,
685: p_init_msg_list => FND_API.G_TRUE ,
686: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
687: x_return_status => l_return_status ,

Line 2681: from edr_Trans_ackn ackn,

2677: )
2678:
2679: into l_result
2680:
2681: from edr_Trans_ackn ackn,
2682: fnd_lookup_values_vl lookup1
2683:
2684: where ackn.erecord_id = p_document_id
2685: and lookup1.lookup_type = 'EDR_TRANS_STATUS'